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

Venue: ESAMI Headquarters, Arusha, TANZANIA  
Learning Duration:  1 week 
Starting: 18 Oct 2021  Ending: 22 Oct 2021
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 too

 

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:  2021-10-18-3-9-3095

Apply Online

PROGRAMME ANNOUNCEMENTS

ESAMI COURSES RUNNING IN DUBAI FROM JUNE - AUGUST, 2021

18 May 2021
    PROGRAMME TITLE START DATE END DATE DURATION Building Strategic Agility: The Leadership Paradigm 14 June 18 June 1 week Proj...

2021 ESAMI BUSINESS SCHOOL ACTIVITY CALENDAR

26 Jan 2021
    2021 ESAMI BUSINESS SCHOOL ACTIVITY CALENDAR PROGRAMME STARTING DATES S/N VENUE PROGRAMME STARTING DATE INTAKE 44 EVENING ...
View More
 

Short Courses Calendar

bullet

CENTERS

bullet

DOWNLOADS

 
 
 
facebook   twitter