Day | Course Content |
Day 1 | Dynamic Table |
Conditional Formatting | |
How to represent raw data? How to prepare a table / matrix? | |
Data Validation | |
Day 2 | Pivot Table |
Pivot Chart | |
Hyperlink | |
Day 3 | Column & Bar Chart: Normal, Conditional, Infographics, Alternate |
Line & Area chart: Normal, Conditional, Infographics, Alternate | |
Pie Chart & Doughnut Chart | |
Combo Chart & Map | |
Tree & Sunburst Chart | |
Infographics conditional chart: Speedometer, Progress, Performance | |
Day 4 | Control Tool |
Dashboard | |
Day 5 | Dashboard |