Microsoft Excel has become extremely power tool for any data analyst. Whether you work in Sales, Marketing, Customer Service, Logistics, Accounts, Manufacturing, Finance or Administration, everyone must become an expert at using Microsoft Excel.
It is not sufficient to know Tables & Formulas in Excel. You must also know how to make sense of the data that you have.
Program Outline
Understanding Dashboards
Principles of Great Dashboard Design
Using Advanced Formulas & Functions in Excel
Referencing & Ranges
Advanced Lookup
Advanced Formatting
Advanced Pivot Table Techniques
Percentage
Computed Columns
Grouping & Sorting
Top Views
Multiple data sources
Pivot Charts & VIsual Dashboarding Techniques
Excel-Dashboard to Compare Sales – Training Example
Advanced Power Charting Techniques
Dashboard Macros
Creating Dynamic Dashboards with Excel
Creating a Sales Dashboard
Target Audience
Sales, Marketing, Finance, IT Executives, Engineers, Project Managers, Directors, CXOs, Managing Directors, General Managers, and Data Analysts who dabble with data and want to learn advanced techniques to convert Data into actionable Information.

