K MENA Excel Analytics for Finance Professionals

What does the Excel Analytics program cover?

Gain mastery over key Microsoft Excel tools and functions that will enable you to automate daily tasks, enhance efficiency and accelerate performance. Discover the industry techniques and best practices in analyzing and presenting financial data.

The Excel Analytics Program by Kaplan Middle East & North Africa is approved by KHDA in the UAE.

Learning Objectives

icon

Grasp keyboard shortcuts to improve speed and efficiency

icon

Become well-versed with the excel quick access tool bar and cell styling tools

icon

Master various intermediate and advanced Excel functions

icon

Produce high quality & dynamic charts for data presentations

icon

Learn and apply pivot table to analyze large volumes of data

icon

Perform various statistical analysis in excel

img

Who is it for?

The course is suitable for anyone in the financial services industry who wants to improve their excel skills.  Professionals who are working or aspiring to work in the field of of equity research, investment banking, financial accounting and analysis, budgeting and data analytics can pursue this course.

Program Agenda

Formatting and Efficiency Skills

  • Excel keyboard shortcuts for speed and efficiency

  • Data Validation and creating drop-down lists

  • Basic and advanced conditional formatting

  • What-If analysis: Data table (sensitivity analysis), Goal seek and Scenario Manager

  • Working with large datasets through pivot tables (filtering, slicers)

Working with Functions

  • Basic Math Functions: SUM, AVERAGE, MAX, MIN, SUMIF, COUNTIF, LARGE, SMALL, AVERAGEIF

  • Logical Functions: IF and Nested IFs, AND, OR

  • Date functions: EOMONTH, EDATE, YEARFRAC, DATE, TODAY, etc.

  • Lookup functions: VLOOKUP, INDEX, MATCH, OFFSET

What Our Students Say

See All
Financial Modelling (2019) – Eva Reinerova
55 months ago
Financial Modelling (2019) – Eva Reinerova

The trainers at Kaplan Middle East & North Africa are very understanding, knowledgeable, and patient. I have studied for the CMA and CFA courses, therefore I know the quality of the training team. They are very experienced in terms of industry and course expertise.

Watch now
Financial Modelling (2019) – Tichaona Maviyo
74 months ago
Financial Modelling (2019) – Tichaona Maviyo

Rahul was exceptional! He ensured that he explained the concepts really well and I truly felt like I got more value than I paid for. I received financial modeling manuals, case studies, and beyond classroom support that has helped me develop models efficiently.

Watch now
Financial Modelling (2019) – Nikhil Kapoor
57 months ago
Financial Modelling (2019) – Nikhil Kapoor

Rahul is a fantastic trainer who is very coherent and gets his ideas across perfectly. He takes his time to answer all questions in-depth and ensures we learn the concepts thoroughly. I would 100% recommend Kaplan Middle East & North Africa to everyone.

Watch now
Financial Modelling (2019) – Umar Masood
74 months ago
Financial Modelling (2019) – Umar Masood

The course has been really detailed right from the steps to follow to the outcomes to expect. I would highly recommend the course to anyone that would like to learn about the practical application of financial models.

Watch now

Request a Call Back

The answer to your doubts is just a click away! Simply fill in your details in the form, and we will get in touch with you shortly.