Advanced Excel Modeling Course

Module 1: Introduction

In this module, we'll learn the course structure allowing you to gain a clear understanding of what to expect as you progress through the material.

Module 2: Fundamentals

In this module, we'll learn the shortcuts and concepts that we'll build upon in the rest of the course.

Module 3: Navigation

In this module, we'll learn the shortcuts you need to use when navigating in Excel. You'll learn Excel shortcuts and navigation controls to move around effortlessly.

Module 4: Formatting

In this module, we'll learn how to access and use the various formatting tools.

Module 5: Custom and Conditional Formatting

In this module, we'll look into detail the crucial topics of custom and conditional formatting.

Module 6: Efficiency

This module explains how you can get maximum efficiency when working with Excel. You will learn the top shortcuts and practice them to take your Excel skills to the next level.

Module 7: Maths and Statistical Functions

In this module, we'll learn basic and advanced math functions that will come up frequently on the job, along with advanced statistical ones.

Module 8: Date and Text Functions

In this module, you'll learn to create dynamic text fields using date and text functions.

Module 9: Logical Functions

In this module, we dive into some of the more complex and foundational functions used throughout financial modeling. This includes IF and Nested IF statements, IFERROR, AND, OR functions, and more.

Module 10: Lookup and Financial Functions

In this module, we explore lookup functions such as VLOOKUP, HLOOKUP, and INDEX-MATCH and the reasons for using them in the context of financial modeling.

Module 11: Print

In this module, we'll learn everything needed to master printing Excel files, a skill that will showcase your mastery in Excel.

Module 12: Importing and Structuring Data

In this module, we explore in detail how data must be imported and structured efficiently for you to really stand out from your peers.

Module 13: Data Analysis and Charts

Last but certainly not the least, we'll learn how to analyze data used advanced tools like Goal Seek, and how to present data appropriately in charts.