Course

Course Overview

Estimated Training Hours: 30 Hrs

Mode - Classroom

To be completed within 30 Hrs

Excel is a combination of various spreadsheets that can be used for storing, organizing and working on data. This course is designed for professionals who want to explore this dynamic tool and learn practical usage of basic and advanced excel functions for constructing various dashboards & models.

This program will teach the participants how to build their own interactive dashboards/models “from scratch”. It will not only help them practice blending Accounting/ HR/ Marketing/ Banking concepts and Excel skills, but will also help them express their thoughts and findings in a more effective way.

Learning Objectives

After completing this course, the participants will be able to:

  • Build different dashboards from scratch
  • Modify and improve an inherited model
  • Select the most appropriate formula to achieve the desired outcome
  • Identify common errors in data analysis models
  • Mitigate errors by building in error checks
  • Prevent incorrect use of their model by protecting worksheets
  • Validate data entry by setting data entry parameters
  • Create a navigation page to help users find their way around their model
  • Develop drop-down boxes which enable a model to produce a series of results depending on the selected scenario variable
  • Gain an in-depth understanding of how to build a business case
  • Communicate the results of their model clearly and concisely
  • Make use of Excel and implement best practices, efficient formula construction, and appropriate driver selections
  • Use Advanced Excel functions to present various sensitivities to projected metrics
  • Fix circularity problems, iteration, and other common modeling troubleshooting

What you will get:
  • Industry recognised certificate
  • Fast track your career in Capital Markets

*Completing this course does not guarantee a job or internship with MAKS.

You may also like

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Comparable Company Analysis....

Course duration - 60 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Comparable Transaction Analysis....

Course duration - 60 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Discounted Cash Flow Analysis....

Course duration - 50 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Financial Statement Analysis....

Course duration - 40 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

LBO Modeling....

Course duration - 50 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

On-line Investment Analyst Training Program....

Course duration - 200 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Acuity Knowledge Partners Certified Financial Rese....

Course duration -

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Investment Analyst Training Program....

Course duration -

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Finance for Non-Finance....

Course duration - 20 Hrs

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

LBO Modelling....

Course duration - 20 Hrs

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Valuation Modeling....

Course duration -

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Advanced Financial Modeling for Investment Banking....

Course duration - 320 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Financial Modeling + Valuation Modeling (Combo)....

Course duration - 400 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Equity Research....

Course duration - 120 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Private Equity....

Course duration - 80 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Advanced FMIB + Credit Research (Combo)....

Course duration - 300 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Advanced Financial Modeling for Investment Banking....

Course duration - 200 Hours