Data Analysis with Excel DASHBOARD Reporting for Management New

Course Outline :

• The Concept of Dashboard
• Excel Functions for generating Dynamic Data
• Excel Form Controls for Interacting with the Dashboard
• Defining the KPIs
• Preparation – Create all Dynamic Data (KPIs) for the Dashboard
• Designing the Dashboard – The Interface
• Building a Sales Dashboard (using Formulas)
• Building a HR Dashboard (using Pivot Table)

Who should attend:

• For intermediate-to-advanced Excel user looking to take their skills to the next level
• Accountants, Human Resource, Business, Sales, Financial, Data Analysts, Stock or Forex Traders, Business Owners who want to build dashboards using Excel to monitor their business metrics or KPIs
• You’d like to learn how to create dynamic and interactive reports

You’d like to improve the design of your existing Excel reports

Pre-requisite:

• Must have at least intermediate skills in Excel
• Must know how to use Excel functions like IF, OR, AND, and nested functions
• Must know how to create basic Excel Chart
• Must already know how to use Excel Pivot Table. If not, you can check out our course on “Effective Pivot Table” @ASK website