ESAMI Offices
 
 
 
Finance and Banking
Finance is the study of how people allocate their assets over time under conditions of certainty and uncertainty.
Banking can be defined as the business activity of accepting and safeguarding money owned by other individuals and entities, and then lending out this money in order to earn a profit.

Course Title: Microsoft Excel for Dashboard Design and Reporting

Apply Online
Venue: ESAMI Headquarters, Arusha, TANZANIA  
Learning Duration:  1 week 
Starting: 17 Oct 2022  Ending: 21 Oct 2022
Fees: 1150 USD
Payment Details: To cover tuition and training materials only

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

Apply Online

PROGRAMME ANNOUNCEMENTS

ESAMI COURSES RUNNING IN DUBAI FROM JUNE - DECEMBER, 2022

7 Jun 2022
  DUBAI COURSES: JUNE – DECEMBER, 2022     ESAMI is inviting applications for the following short courses that are scheduled to run in Dubai, UAE from June to December 202...

2022 ESAMI BUSINESS SCHOOL ACTIVITY CALENDAR

7 Feb 2022
     2022 BUSINESS SCHOOL ACTIVITY CALENDAR     PROGRAMME STARTING DATES S/N VENUE PROGRAMME STARTING DATE INTAKE 46 EVENING ...
View More
 

Short Courses Calendar

bullet
bullet

DOWNLOADS

 
 
 
facebook   twitter