Course Title: Microsoft Excel for Dashboard Design and Reporting

COURSE OVERVIEW
Dashboards are important tools for analyzing, monitoring and reporting on the achievement of project and organizational objectives. They are important tools for fast and improved decision making. They also provide a spot on helicopter view of an entity. Dynamic and interactive dashboards not only enrich reporting but also capture the attention of viewers and decision makers. With its powerful tools, ms excel creates a perfect platform for designing, reporting and analyzing dashboards.

WHO SHOULD ATTEND?
The programme is relevant for officers interested in learning quick tools for projects and organizational reporting and analysis. Participants are encouraged to bring their laptops loaded with the latest version of MS excel.

HOW PARTICIPANTS WILL BENEFIT
At the end of the course, participants will be able to:
• Appreciate the importance dashboard reporting and analysis;
• Learn how to design an interactive and dynamic dashboard;
• Learn how to incorporate users’ need in dashboard design;
• Learn advanced ms excel functions for dashboard reporting and analysis;
• Learn how to use ms excel for data analysis and reporting;
• Learn how to present dashboard and scorecards using ms excel visualization tools.

TOPICS INCLUDE
• Introduction to dashboards;
• Defining user requirements;
• Designing and creating dashboard using ms excel;
• Advanced ms excel functions for dashboard reporting and analysis;
• Pivot tables
• Visualization charts;
• Dashboards and scorecards;
• Data modeling and manipulation;
• Data gathering and analysis;
• Interactive and dynamic features for dashboard.

Course No:  2022-10-17-3-9-3405