Overview
If you have a good business dashboard, figures for stocks and sales can be found more quickly.Let us learn how to make an interactive business dashboard using MS Excel.
Course outline
- 01Introduction
- 02Case Study
- 03Pivot Table
- 04Pivot Template & Pivot Field
- 05Raw data structure in Excel
- 06Create your first Pivot Table
- 07How to group dates in Pivot Table
- 08Build interactive Dashboard in Excel
- 09Top 5 productivity tricks in Pivot Table
Meet the teachers
Mohammed Alfan
Mohammed Alfan supports Microsoft's Product Development section for US and owns a data analytics institute, 'Rows & Columns' in India. He has 15+ years of MNC experience. So far, he has trained almost 14000+ students globally and bagged the Microsoft Most Valuable Professional award in the Excel Category (2022). His book, 'Data Analytics - Pivot to Rescue', is ranked in the Top 3 analytical books for beginners.
View profile ↗
