To create effective dashboards, one needs to have excellent knowledge of excel. One needs to know many things including below:

1. Excel keyboard shortcuts.
2. Preparing accurate worksheet workflow.
3. Great colour combination sense.
4. Well versed with the source data from which dashboard will be prepared.
5. Knowledge of many useful excel functions like Vlookup, Index & Match, Text functions, IFs functions, etc.
6. Knowledge of form control.
7. Knowledge of advanced chart techniques.
8. Knowledge of conditional formatting and data validation.
9. Knowledge of pivot table and advanced pivot table techniques.
10. Knowledge of shapes and objects.
11. Availability of a project based on which dashboard can be prepared by using above tools.

Homepage
MS EXCEL TRAINING