Day 1: Course Introduction & Professional-looking Excel formatting
  • What does the course cover?
  • Why Excel and why modeling?
  • Let's start from scratch and create a P&L sheet
  • Quiz - Formatting
  • Cell styles allows you to be faster…
  • Quiz - Cell Styles
  • Pasting values, formulas, and formats with Paste Special
  • Quiz - Paste Special
  • Formatting Cells Part I - Working with data in Excel
  • Formatting Cells Part II - Customize numbers the way you like
  • Quiz - Format Cells
  • Highlight key data with Excel Conditional Formatting
  • Quiz - Conditional Formatting
  • Filter by color
  • Recording Macros - The perfect way to avoid repetitions
Day 2: Be 3.0x faster than average users - shortcuts and quick navigation tools
  • The secret of fast scrolling: navigation and keyboard shortcuts
  • Fix the top row of your Excel tables
  • Use multiple screens simultaneously
  • Quiz - Split Screens
  • Excel formulas that make sense - Named Ranges
  • Creating drop-down menus in Excel
  • F1 to F12 - Using Excel's function keys
  • Quiz - F keys
  • How to select visible cells only
  • Quiz - Select visible cells
Day 3: Excel mechanics - A collection of indispensable tools
  • Fixing cell references properly
  • Quiz - Fixing cell references
  • Grouping Excel rows and columns - The correct way to do it!
  • Quiz - Group rows and columns
  • Working on multiple sheets at the same time
  • Find & Replace - Our favourite Excel tool
  • Quiz - Find & Replace
  • A great way to apply Find & Replace
  • Quiz - Find & Replace Formatting
  • Create easily printable documents by using Set Print Area
  • What Are Circular References in Excel?
  • Circular References - An example
  • Quiz - Circular References
  • Trace precedents - Display the relationship between formulas and cells
  • Quiz - Trace precedents
  • Completing 33% of the course
Advanced Excel functions made easy
  • What is a nested function?
  • Advanced Excel functions: Sum; Sumif; Sumifs
  • Advanced Excel functions: Round functions
  • Advanced Excel functions: Iferror
Day 4: Advanced Excel functions - Part 1
  • Advanced Excel functions: Vlookup & Hlookup
  • Advanced Excel functions: Index; Match; Index & Match
  • Advanced Excel functions: Index, Match, Match
  • Advanced Excel functions: Indirect; Vlookup & Indirect
  • Advanced Excel functions: Rows; Columns; Vlookup & Columns
  • Advanced Excel functions: Vlookup & Match
  • Advanced Excel functions: Choose; Vlookup & Choose
  • Advanced Excel functions: Offset; Offset & Match
  • Completing 50% of the course
Day 5: Advanced Excel functions - Part 2
  • Financial functions: FV and PV
  • Discounting Cash flows and calculating Net Present Value (NPV)
  • Financial functions: IRR
  • Financial functions: PMT and building a complete loan schedule
  • Date functions
Day 6: Excel Tips & Tricks
  • Excel tips & tricks: Part 1
  • Excel tips & tricks: Part 2
  • Excel tips & tricks: Part 3
  • Excel tips & tricks: Part 4
Day 7: Financial modeling fundamentals
  • What is a financial model?
  • Why use a financial model?
  • Financial modeling Don'ts - Worst practices we should avoid
  • Financial modeling Do's - This is what solid modelers do
  • The different types of models
  • What is the right level of detail in a financial model?
  • Quiz: Financial modeling
Forecasting future financials - A cornerstone of financial modeling
  • Forecasting guidelines: apply these principles when forecasting financials
  • How to build a complete model
  • Forecasting Income statement financials
  • Forecasting Balance sheet financials - Part one
  • Forecasting Balance sheet financials - Part two
Day 8: Building a complete 3-statement model
  • Introduction to the Exercise
  • Let's create a mapping of financials
  • Building an output P&L sheet
  • Filling in the output P&L sheet with historical financials
  • Calculating percentage variances and applying conditional formatting
  • Building an output Balance sheet
  • Using Index, Match, Match to fill in the output Balance sheet
  • Adding the forecast period
Day 9: Let's build a flexible model with multiple scenarios
  • Calculating historical percentage ratios and use Index and Match for scenarios
  • Building a flexible model with Choose & Match
  • Building a flexible model with Vlookup & Columns
  • Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %
  • Forecasting DSO, DPO, DIO, Other assets and Other liabilities
Day 10: We are almost there! Today we'll complete the 3-statement model