- 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
- 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
- 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
- What is a nested function?
- Advanced Excel functions: Sum; Sumif; Sumifs
- Advanced Excel functions: Round functions
- Advanced Excel functions: Iferror
- 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
- 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
- Excel tips & tricks: Part 1
- Excel tips & tricks: Part 2
- Excel tips & tricks: Part 3
- Excel tips & tricks: Part 4
- 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 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
- 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
- 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