返回主页
Anne Teoh
  • ☛  Certified Microsoft Excel Expert
  • ☛  Certified Train The Trainer - PSMB
  • ☛  Certified as Microsoft Office Specialist Excel,Word,Powerpoint (2013/2016)
11月 5日-6日 2020年(四至五) 7小时 / 2天
09:00AM - 12:30PM RM350
中文



☛  INTRODUCTION
   ⚬   Elements of this syllabus are subject to change. This two days course provides students with the knowledge and skills to examine and manipulate raw data through the use of Microsoft Office Excel PivotTables and Pivot Charts. Dashboard reports allow managers and decision makers to get high-level overview of the business. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.

☛  HOW WILL YOU BENEFIT
   ⚬   Upon completion of this program, participants should be able to:
   ⚬   • Understand the benefits of PivotTable Reports
   ⚬   • Convert raw data in an Excel worksheet into meaningful PivotTables and PivotCharts
   ⚬   • Manipulate the PivotTable layout
   ⚬   • Organize data for easier dashboard preparation
   ⚬   • Prepare worksheet to ease future dashboard update
   ⚬   • Prepare dashboard for better distribution

☛  PREREQUISITES
   ⚬   To ensure your success, we recommend the delegates equip with the following or equivalent knowledge:
   ⚬   • A working knowledge of Microsoft Windows
   ⚬   • A working knowledge of Microsoft Excel
   ⚬   • Prior working knowledge on Pivot Table is a plus

Course Outline

MODULE 1 – Understanding Dashboards
   ⚬   • What is a Dashboard?
   ⚬   • Principles of Great Dashboard Design
   ⚬   • Dashboard Do’s and Don’t’s
   ⚬   • Data Layout Creating Dynamic Dashboards

MODULE 2 – Working with Your Data
   ⚬   • Data Cleansing Techniques
   ⚬   • Format as Table Formulas
   ⚬   • Linking Data From Different Sources
   ⚬   • Organizing Data in Three Layers for Maintainability

MODULE 3 – Using Advanced Formulas & Functions
   ⚬   • Dynamic Range Names
   ⚬   • Advanced Lookup
   ⚬   • Advanced

MODULE 4 – Quick Dashboard with Conditional Formatting
   ⚬   • Create Dashboard Heat Maps
   ⚬   • Showing Data Bars
   ⚬   • Showing Traffic Light with Icon Sets
   ⚬   • Highlight Top and Bottom Products/ People etc.
   ⚬   • Highlight Missed Budgets and Forecasts

MODULE 5 – Advanced Pivot Table Techniques
   ⚬   • Displaying Number as Percentage
   ⚬   • Creating Custom Computed Columns
   ⚬   • Sorting & Grouping Data
   ⚬   • Showing Top & Bottom Ranks
   ⚬   • Using Pivot Charts & Visual Techniques
   ⚬   • Adding Interaction with Slicers
   ⚬   • Refreshing Pivot Table Considerations When Sheets Are Protected

MODULE 6 – Advanced Charting Techniques
   ⚬   • Dynamic Chart Title
   ⚬   • Using Mini Chart - Sparklines
   ⚬   • Capturing Attention with Key Metric
   ⚬   • Pictogram Chart
   ⚬   • Speedometer Chart

MODULE 7 – Preparing Dashboard for Distribution
   ⚬   • Aligning Charts and Objects on Dashboard
   ⚬   • Hiding Objects from Printing
   ⚬   • Preventing Charts from Shifting
   ⚬   • Locking Charts from Resizing
   ⚬   • Protecting Sheet to Prevent Unauthorized Changes

MODULE 8 – Interactive Dashboard Project
   ⚬   • Human Resource – Analysis employee data such as Leave and Attendance
   ⚬   • Training – Analysis in progression of Training by employee
   ⚬   • Sales – Analysis performance Sales Person
   ⚬   • Warehouse – Analysis Stock



线上课程购票流程

1. 确认课程后, 点击购买
2. 请选择购票的数量
3. 请填写您的个人资料:(必须填写,我们将在购票后向您发送线上课程的链接)
      -   姓名
      -   联络电话
      -   电邮地址
      -   公司名字
      -   公司地址
4. 付款
5. 付款成功后您将收到电子邮件通知。
6. 我们会电邮线上课程Zoom的链接给您。

所有线上课程都将透过Zoom来进行。请在上课前把Zoom安装好。




联系我们 | 隐私条款 | 使用者条例 | 常见问题