This is a free course with over 6.5 hours of video content

Course Curriculum

    1. Course Introduction

    1. Chapter Overview

    2. Excel Support File (XLS)

    3. Lesson 1: Setting Shortcuts

    4. Lesson 2: Number Cycles & Decimals

    5. Lesson 3: Date Cycle

    6. Lesson 4: Font Colours

    7. Lesson 5: Fill Colours

    8. Lesson 6: Smart Precedent Tracer & Zoom

    9. Conclusions

    10. Quiz: Financial Modelling Macros

    1. Chapter Overview

    2. Excel Support File (XLS)

    3. Excel Shortcuts (PDF)

    4. Lesson 1: Select Ribbons

    5. Lesson 2: Go To Cell A1

    6. Lesson 3: Move Quickly To Different Sections

    7. Lesson 4: Select Contiguous Cells

    8. Lesson 5: Open Cells

    9. Lesson 6: Show Dependent Cells

    10. Lesson 7: Move Up And Down Quickly

    11. Lesson 8: Move Between Different Tabs

    12. Lesson 9: Move Tabs

    13. 10: Change Tab Name

    14. Practice Test 1: Navigating & Auditing Shortcuts

    15. Quiz 1: Navigation & Auditing Shortcuts

    16. Lesson 11: Copy And Paste

    17. Lesson 12: Undo And Redo

    18. Lesson 13: Fill Right And Fill Down

    19. Lesson 14: Sum Totals

    20. Lesson 15: Repeat Last Action & Lock Cells

    21. Lesson 16: Enter Cells

    22. Lesson 17: Select And Copy Columns And Rows

    23. Lesson 18: Deleting And Adding Rows And Columns

    24. Lesson 19: Paste Special

    25. Lesson 20: Saving Model Versions

    26. Lesson 21: Delete Inputs

    27. Practice Test 2: Modelling Shortcuts

    28. Quiz 2: Modelling Shortcuts

    29. Lesson 22: Select All Cells

    30. Lesson 23: Gridlines

    31. Lesson 24: Font Styles And Alignment

    32. Lesson 25: Page Setup

    33. Lesson 26: Inserting Rows & Columns

    34. Lesson 27: Print Preview & Page Setup

    35. Lesson 28: Row Height & Column Width

    36. Lesson 29: Adding & Removing Borders

    37. Lesson 30: Changing Font To Bold & Italics

    38. Lesson 31: Removing Background Colors

    39. Lesson 32: Control Box

    40. Lesson 33: Spellchecker

    41. Lesson 34: Macabacus Shortcuts (Refresher)

    42. Practice Test 3: Formatting & Macabacus Shortcuts

    43. Conclusions

    44. Quiz 3: Modelling Shortcuts

    1. Chapter Overview

    2. Excel Support File (XLS)

    3. Lesson 1: Font Colours & Number Formatting

    4. Lesson 2: Center Across Selection & Decimals

    5. Lesson 3: Clear Labelling & Assumptions

    6. Lesson 4: Titles, Borders & Negatives

    7. Lesson 5: Subtotals & Totals

    8. Lesson 6: Footnotes, Indentations & Total Columns

    9. Lesson 7: Present in thousands & toggles

    10. Lesson 8: Page Setup

    11. Formatting Practice Test 1

    12. Formatting Practice Test 2

    13. Conclusions

    14. Quiz: Formatting

    1. Chapter Overview

    2. Excel Support File (XLS)

    3. Lesson 1: If(error)

    4. Lesson 2: Max (X, zero)

    5. Lesson 3: Rounding

    6. Lesson 4: Sumif

    7. Lesson 5: Eomonth & XIRR

    8. Lesson 6: XNPV

    9. Lesson 7: Choose

    10. Lesson 8: Text

    11. Lesson 9: If statement

    12. Lesson 10: If (or) statemeent

    13. Lesson 11: If (and) statement

    14. Lesson 12: Asterisk (*) Conditions

    15. Lesson 13: Sumproduct

    16. Lesson 14: Weighted Avgs.

    17. Lesson 15: Index (Match)

    18. Lesson 16: Complex Coumpounded Formulae

    19. Lesson 17: Vlookup

    20. Lesson 18: Hlookup

    21. Lesson 19: Offset

    22. Lesson 20: Nestled If statements

    23. Lesson 21: Indirect Functions

    24. Lesson 22: IRR & NPV

    25. Practice Test: Excel Formulae

    26. Conclusions

    27. Quiz: Excel Formulae

    1. Chapter Overview

    2. Excel Support File (XLS)

    3. Lesson 1: Moving Cells

    4. Lesson 2: Cicular References & Model Updates

    5. Lesson 3: Tracing Dependents

    6. Lesson 4: Compounding

    7. Lesson 5: Toggles

    8. Lesson 6: Conditional Formatting

    9. Lesson 7: Goalseek

    10. Lesson 8: Lists

    11. Lesson 9: Locking Cell References

    12. Lesson 10: Excel Marcos

    13. Lesson 11: Merging Cells

    14. Lesson 12: Hiding & Grouping

    15. Lesson 13: Naming Cells

    16. Practice Test: Excel Tips & Tricks

    17. Conclusions

    18. Quiz: Tips & Tricks

About this course

  • Free
  • 124 lessons
  • 6.5 hours of video content

Course Highlights

Turbocharge your financial modelling and unlock the power of Excel. This course teaches you everything you need to know to become a world-class financial modeller and to progress to the financial modelling courses of the REIA starter package including the intermediate and the advanced financial modelling courses (REIA course 4 & 5).

  • Support files: includes several financial models such as dynamic LBO and DCF cash-flow models.

  • Best-in-class financial modelling techniques: learn how the best investment firms build dynamic cash-flow models.

  • Beyond real estate: valuable for any role where Excel is used including investment banking and private equity.

  • Immersive learning: over 6.5 hours of video lessons, divided into smaller sections that can be completed one step at a time.

  • Proven results: our students have successfully secured coveted positions at prestigious private equity firms and investment banks

  • Taught by industry expert: instructed by Steffen Kluners, a seasoned professional with extensive private equity experience.

  • Seamless learning journey: the course starts with basic excel functions and gradually progresses to more advanced concepts.

  • Mobile-friendly app: access course materials conveniently through the REIA mobile-friendly app.

  • Certificate of completion: receive a course completion certificate for job applications or social media sharing.

  • No-questions-asked refund policy: students are entitled to a full refund within the first 72 hours of signing up for this course.

Your Instructor

Steffen Kluners

Founder of the Real Estate Investment Academy

The course is taught by Steffen Kluners, industry expert with over 12 years of private equity experience, including at Blackstone. Steffen has worked on transactions with an aggregate volume of over $3.0bn. Before launching the Real Estate Investment Academy, he worked as an Investment Director at a private equity firm in London. In the REIA courses, he shares valuable insights on how the most prestigious private equity firms analyse real estate transactions.

Course Completion Certificate

You will receive a course completion certificate at the end of this course, which you can use for your applications, and you can also share the certificate on any social media platform such as LinkedIn, Facebook, and Instagram.

The REIA Mobile App

The course content can be accessed via our REIA mobile app so that you can access our courses on-the-go, providing for a more user-friendly experience.

Course Overview

With over 6.5 hours of video lessons, this Excel and financial modelling course is structured as an immersive and interactive experience. Each lesson is designed to provide practical examples and insights, ensuring that you can apply what you learn in real-world scenarios. For example, we will build simple LBO (levered buy-out) and DCF (discounted cash-flow) models.

It covers six essential chapters: 

  • Chapter 1: Financial Modelling Macros: Discover the power of macros in financial modelling and learn how to automate repetitive tasks, saving you valuable time and effort.

  • Chapter 2: Excel Shortcuts: Learn how to use Excel shortcuts and increase your productivity by quickly navigating the software.

  • Chapter 3: Formatting Tricks: Transform your spreadsheets into visually appealing documents. This chapter teaches you how to change the formatting of your financial models so that these look professional.

  • Chapter 4: Excel Functions & Formulae: Use complex functions to build dynamic cash-flow models. This chapter teaches you all the functions that you need for advanced financial models.

  • Chapter 5: Additional Tips & Tricks: Discover additional tips and tricks to work more efficiently in Excel, boosting your productivity and accuracy.

  • Chapter 6: DCF (Discounted-Cash-Flow) Case Study: Apply all the Excel tricks and techniques you have learned throughout the course by building a simple DCF model via a case study.


Who is this course for?

  • Anyone who wants to learn how to build financial models and how to work more efficiently and accurately in Excel. 
  • The course goes beyond real estate and is valuable for students and finance professionals in any role where Excel is used at work.


Recommended Prerequisites

No minimum level is required, although familiarity with basic Microsoft Excel functions is recommended. After completing this course, you will have gained a solid foundation in Excel for financial modelling and will be well-prepared for more advanced financial modelling courses.


Refund Policy

This course is for free. For the other paid courses of the REIA package, you will be entitled to a full refund within the first 72 hours of signing up this course. Just send an e-mail to admin@reia-edu.com.

Industry Expert Opinion

“As a real estate recruiter in London, I see many candidates including junior to mid-level professionals from top banks who want to break into the investment industry but fail in assessment centers and financial modelling tests. What sets this course apart is that it has real practical applications and teaches candidates exactly what they need to secure a job in the real estate investing industry.”

Jamie McCord (Head of Real Estate Investment Recruitment and Executive search)

Additional products