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.
Course 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

