ObjectivesTo provide the knowledge and skills required to use the various features of Excel to create dashboards without VBA programming.
Targeted audienceManagers and employees
PrerequisiteIntermediate knowledge of MS Excel. Experience with dynamic pivot tables (Course CH166).
- Examples of dashboards: information systems, project heads, etc.
- Building the dashboard summary page: choosing indicators by department
- Advanced dynamic pivot tables
- Advanced macro-commands
- Budget preparation and follow-up
At the end of this training, yoiu will have a real exemple of dashboard for a company.