- 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
- 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
- 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 save LOTS of time in Excel
- Keyboard shortcuts in Excel
- 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
- Exercise - Excel's SUMIFS function - unsolved
- Exercise - Excel's SUMIFS function - solved & explained
- 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