Financial Modeling Course

INTRODUCTION

While there is a lot of value in mastering the advanced functions in excel, you need to understand how to apply them. This financial modeling course takes all the advanced functions and combine multiple formulas into one, to do functions, models and apply principles that any financial person should know to let them stand out.

Examples would be how to do improve reporting, cash flows, reconciliations etc.

The first two days is the same as our advanced excel course. We would advise to the first two days and last two days over two months to give you time to practice the formulas. The application of these formulas in real scenarios are not easy.



CONTENT

This is the most advanced content you will be able to get. The following main topics will be covered:

Advanced excel topics

  1. Formula basics (Basics, absolute referencing)
  2. Logical formulas (LOGICAL TESTS, AND, OR, IF, IFERROR, ISERROR)
  3. Lookup formulas (VLOOKUP, INDEX, MATCH, ADDRESS, SUBTOTAL, AUTOFILTERS)
  4. Text formulas (MID, LEFT, RIGHT, PROPER, UPPER, LOWER, SEARCH, REPLACE, TEXT, VALUE, TRIM, SUBSTITUTE)
  5. Reporting formulas (Pivottables, Pivotcharts, Pivot Slicers, SUMIFS, INDIRECT, Macros)
  6. Formatting functions (Conditional formatting, Paste Special for formulas)
  7. Other (COUNTIF, COUNTA, HYPERLINKS, CELL NAME DEFINING, BREAKING LINKS)
  8. Dates (Date principles, Calculation of time, NETWORKINGDAYS, TODAY, NOW, YEAR, MONTH, DAY, DATE).

Financial Modeling topics

  1. Automatic numbering
  2. How to make cells unique
  3. Automatically reconcile one list
  4. Automatically reconcile two lists
  5. Changing a column format (budgeting months next to each other) into a row format which pivots can use
  6. Consolidation of multiple excel files into one without using links
  7. The reporting principle to ensure accuracy and save up to 80% time in preparation
  8. Create reports which pulls from actuals, budgets and prior year even if formats are different
  9. Compiling an age analysis in 5 minutes
  10. Creating amortization tables where you can change interest rates, add payments and change number of months automatically
  11. Preparing cash flows that always balances
  12. Get more than one result with VLOOKUP's


DURATION OF THIS FINANCIAL MODELING COURSE

This course is normally 20 hours in total. These 20 hours can be delivered in different ways:

  1. Four full days consecutively
  2. Four days split (This can be split over different weeks or different months)
  3. 8 Sessions of 2.5 hours each. (This can be split over different weeks or different months)


CERTIFICATION

This course qualifies for 20 variable hours for Chartered Accountants. You will also get a certificate of competence once you pass the exam after the course. This exam is based on our eLearning site.



WHAT DO YOU GET INCLUSIVE

You get the following when attending the course

  1. Manuals
  2. eLearning access (videos, assessments, exam, simulations, more examples)
  3. Webinar access (weekly webinars on excel content)
  4. Support during working days

Empower Yourself - BOOK NOW!

Financial Modelling Course
For Learnership Interviews (On appointment only)
1st Floor - SpecCon Holdings (above Huge PC),
1294 Heuwel Ave
Centurion, 0046
South Africa

For Corporate Appointments
4th Floor, Block 2
Anew Hotel Centurion (Conference Centre)
Cnr Gordon Hood and Hendrik Verwoerd Drive
Centurion 0046
South Africa

Contact Details:

Tel: 012 667 4928
Email: [email protected]



VAT No: 4410263224

*


Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do
Nelson Mandela