Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!
  • What does the course cover?
  • Bonus! Welcome gift
  • Welcome gift number 2
  • The best way to take this course
  • Download all course materials and frequently asked questions (FAQ)
Introduction to Excel
  • Introduction to Excel
  • Overview of Excel
  • Overview of Excel
  • The Excel ribbon
  • Basic operations with rows and columns
  • Data entry in Excel
  • Introduction to formatting
  • Rows and columns
  • Introduction to Excel formulas
  • Introduction to Excel formulas
  • Introduction to Excel functions
  • Cut, copy, & paste
  • Cut, copy, & paste
  • Paste special
  • Format cells
  • Basic operations in Excel - 38 pages
Useful tips and tools for your work in Excel
  • Excel best practices - Welcome lecture
  • Initial formatting of Excel sheets for a professional layout
  • Fast scrolling through Excel sheets
  • Fast scrolling through Excel sheets
  • Be even quicker: F5 + Enter
  • Fixing cell references
  • Introduction to fixing of cell references
  • Alt + Enter
  • Organize your data with text to columns
  • Learn how to organize your data with text to columns
  • The wrap text button
  • Set print area
  • Custom sort helps you sort multiple columns in Excel tables
  • Create drop-down lists with data validation
  • Find and select special types of cells with Select special (F5)
  • Select Special
  • Assign dynamic names in a financial model
  • Assigning dynamic names
  • Define a named range in Excel
  • Create a great Index page at the beginning of your models - Hyperlinks
  • Introduction to custom formatting in Excel
  • Apply custom formatting in a financial model
  • Macros are a great timesaver! Here's why!
  • How to save macros and use them across several workbooks
  • Excel macros - quiz
  • Fix the top row of your table with freeze panes
  • How to search functionalities in Excel
  • Filter by color - an excellent tool
  • Working with conditional formatting
  • Useful tips and tools for your work in Excel - quiz
  • A neat trick - Multiply by 1
  • Find and replace - references
  • FAQ: Why do we replace external references and how does this help us?
  • Find and replace - formatting
  • Removing (automatic) green arrows
  • Beauty saving - The professional way of saving files
  • Formula auditing with F2
Keyboard shortcuts in Excel
  • Keyboard shortcuts save LOTS of time in Excel
  • Keyboard shortcuts in Excel
Excel's key functions and functionalities made easy
  • Excel's key functions - Welcome lecture
  • A helpful consideration
  • Key functions in Excel: IF
  • Key Excel functions: SUM, SUMIF and SUMIFS
  • = and + are interchangeable when you start typing a formula
  • Key Excel functions: COUNT, COUNTA, COUNTIF, COUNTIFS
  • Key Excel functions: AVERAGE and AVERAGEIF
  • Key Excel functions: AVERAGE and AVERAGEIF
  • Work with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
  • Work with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
  • Working with text (continued)
  • Find the minimum or maximum value in a range of cells in Excel
  • Include ROUND in your financial models
  • Key Excel functions: VLOOKUP and HLOOKUP
  • How to enlarge the formula bar
  • INDEX, MATCH and their combination - the perfect substitute for VLOOKUP
  • A great Excel technique: INDEX, MATCH, MATCH
  • INDEX, MATCH and their combination - the perfect substitute for VLOOKUP
  • Using Excel's IFERROR function to trap spreadsheet errors
  • RANK is a valuable tool when using Excel for financial and business analysis
  • CHOOSE - Learn how to render your models flexible
  • Use Goal Seek to find the result that you are looking for
  • Use Goal Seek in order to find the result that you are looking for
  • Include sensitivity analysis in your models through Data Tables
  • Include sensitivity analysis in your models through Data Tables
  • Excel's dynamic and interactive tables: Pivot tables
  • Excel's key functions and functionalities made easy
Update! SUMIFS - Exercise
  • Exercise - Excel's SUMIFS function - unsolved
  • Exercise - Excel's SUMIFS function - solved & explained
Financial functions in Excel
  • Future and present values in Excel
  • Calculating the rate of return of an investment with the IRR function
  • Calculating a complete loan schedule in Excel
  • Date functions in Excel