Excel Dashboard Topics Covered
| Excel Dashboard Classes in Mumbai | |||
| Excel Dashboard Course Module 1: Introduction | |||
| Excel Dashboard Course Module 2: Getting Your Data Ready | |||
| Excel Dashboard Course Module 3 | |||
| Excel Dashboard Course Module 4: Design Principles |
|||
Charts & Tricks for Trending |
|||
Secondary Axis |
|||
Smoothing Data |
|||
Sparklines |
|||
Formatting Tricks |
|||
Highlighting Comparisons |
|||
Top & Bottom Ranking |
|||
Frequency Distribution |
|||
Target vs Variance Charts |
|||
Performance Against Target Range |
|||
Bullet Graphs |
|||
Win/Loss/Draw Conditional Format |
|||
Dynamic Data Range |
|||
Dynamic Labels |
|||
Text Formulas |
|||
Symbols in Formulas and Charts |
|||
Charts Referencing Non-contiguous Ranges |
|||
Embedding Objects in Charts |
|||
Dynamic, Dynamic Data Validation Lists |
|||
In Cell Charts |
|||
Panel Charts |
|||
Step Charts |
|||
| Excel Dashboard Course Module 5: Interactive Controls | |||
Form Controls Introduction |
|||
Check Boxes |
|||
List Boxes |
|||
Option Buttons |
|||
Group Boxes |
|||
Scroll Bar |
|||
Buttons |
|||
Combo Box with Macro |
|||
Dynamic Date Filters 4 Ways |
|||
Animated Charts |
|||
INDIRECT Function Tricks |
|||
Dynamic Named Range with OFFSET |
|||
Dynamic Named Range with INDEX |
|||
Dynamic Ranges for Charts |
|||
Rollover Technique |
|||
Scroll and Sort Table |
|||
| Excel Dashboard Course Module 6: Analysing the Data | |||
PivotCharts |
|||
Slicers – Excel 2010/2013/2016 |
|||
GETPIVOTDATA Function |
|||
Capture Slicer Selection in Formula |
|||
Slicer & PivotChart Dashboard Overview |
|||
| Excel Dashboard Course Module 7: Putting It All Together | |||
New Dashboard Tour |
|||
Pyramid Chart |
|||
Array Formula Alternative to SUMIFS |
|||
LARGE and SMALL Array and DAVERAGE |
|||
Rank Values with PivotTable |
|||
Scatter Chart |
|||
DMAX, DMIN, DAVERAGE |
|||
Formatting Quickly |
|||