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.
Sorry,the application deadline for this course has expired.

Coourse Title: ADVANCD MS Excel for Business Modelling

Venue: ESAMI Headquarters, Arusha, TANZANIA  
Learning Duration:  2 weeks 
Starting: 11 Oct 2021  Ending: 22 Oct 2021
Fees: 1500 USD
Payment Details: To cover tuition and training materials only.

COURSE OVERVIEW

Driving organisations into the future requires the development of sound business and financial models. The models, anchored on strong foundation, are important for simplifying complex business situations and therefore improving on the quality and time taken to make decisions. Moreover, the models do provide sound business solutions. With its powerful tools, MS excel creates a perfect platform for the development of sound business models.

 

WHO SHOULD ATTEND?

The programme is relevant for officers interested in learning advanced MS excel for the development of sound business models. Participants are encouraged to bring their laptops loaded with the latest version of MS excel.

 

HOW PARTICIPANT WILL BENEFIT

At the end of the course, participants will be able to:

Learn advanced MS excel functions appropriate for data mining, gathering, analysis and manipulation;

Appreciate the importance of financial models;

Learn how to design and build models using MS excel;

Learn how to use MS excel for data analysis and reporting;

Learn how to design, create and present dashboard using MS excel;

Learn how to communicate models.

 

TOPICS INCLUDE

Introduction to modeling;

Financial models: drivers and assumptions building;

Designing models and advanced ms excel functions and tools sharing and collaborating with workbooks;

Applying formulas and functions;

Using index, match, sum ifs, array formulas, lookup functions, sing the forecast / trend function, pivotal tables and logical nested functions, scenario and sensitivity analysis methods and what-if analysis with goal seek;

Data mining and building own financial models;

Financial statements and project evaluation;

Designing dashboard using ms excel, leveraging on ms excel for data analysis;

Presentation of model output and model documentation.

 

Course No:  2021-10-11-3-9-3093

PROGRAMME ANNOUNCEMENTS

ESAMI COURSES RUNNING IN DUBAI & TURKEY FROM OCTOBER - DECEMBER, 2021

22 Sep 2021
DUBAI & TURKEY COURSES: OCTOBER – DECEMBER, 2021 NITA/TRN/1123   S/N PROGRAMME TITLE START DATE     END DATE WEEKS VENUE ...

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
bullet

DOWNLOADS

 
 
 
facebook   twitter