Module 1 – Introduction to Business Analytics
Introduction
Types of Analytics
Areas of Analytics

Module 2 – Formatting Conditional Formatting and Important Functions
Introduction
Custom Formatting Introduction
Custom Formatting Example
Conditional Formatting
Logical Functions
Lookup and Reference Functions
VLOOKUP Function
HLOOKUP Function
MATCH Function
INDEX and OFFSET Function
Statistical Function
SUMIFS Function
COUNTIFS Function
PERCENTILE and QUARTILE
STDEV, MEDIAN and RANK Function

Module 3 – Analyzing Data with Pivot Tables
Introduction
Pivot Table Introduction
Concept Video of Creating a Pivot Table
Grouping in Pivot Table Introduction
Grouping in Pivot Table Example
Grouping in Pivot Table Example
Custom Calculation
Calculated Field and Calculated Item
Calculated Field Example
Calculated Item Example
Slicer Intro
Creating a Slicer

Module 4 – Dashboarding
Introduction
What is a Dashboard
Principles of Great Dashboard Design
How to Create Chart in Excel
Chart Formatting
Thermometer Chart
Pareto Chart
Form Controls in Excel
Interactive Dashboard with Form Controls
Chart with Checkbox
Interactive Chart

Module 5 – Data Analysis Using Statistics
Introduction
What is a Dashboard
Principles of Great Dashboard Design
How to Create Chart in Excel
Chart Formatting
Thermometer Chart
Pareto Chart
Form Controls in Excel
Interactive Dashboard with Form Controls
Chart with Checkbox
Interactive Chart