Introduction
  • Introduction
  • Course Resources
Basic Formula Operations and Mathematical Functions
  • Basic Formula Operations
  • This is a milestone!
  • Mathematical Functions Part 1
  • Mathematical Functions Part 2
  • Exercise - Mathematical Functions
  • Quiz
Textual Functions
  • Textual Functions Part 1
  • Textual Functions Part 2
  • Exercise - Textual Functions
  • Quiz
Logical Functions
  • Logical Functions
  • Exercise - Logical Functions
  • Quiz
Date-time Functions
  • Date-time Functions
  • Exercise - Date-time Functions
Lookup Functions (V Lookup, Hlookup, Index-Match)
  • Lookup Functions (V Lookup, Hlookup, Index-Match)
  • Exercise - Lookup Functions
New! XLookup - only Excel 2021 and Office 365
  • XLookup as a replacement of Vlookup
  • Handling #NA and Approximates match in Xlookup
  • Wildcard matching in XLookup
  • Search modes in XLookup
Data Tools
  • Sorting, Filtering and Data Validation
  • Text-to-columns and remove duplicates
  • Advanced filter option
  • Quiz
Indirect Function
  • Named Ranges
  • Indirect Function
  • Quiz
Financial Functions
  • Loan Repayment concepts
  • Excel: Calculating Payments
  • Excel: Calculating Rate or Term
  • Depreciation Methods and Straight Line Method
  • Double Declining Balance Depreciation
  • Sum of Years Digits Method
  • Excel: Calculating Depreciation
Pivot Tables
  • Pivot Tables
Bonus Section
  • Popular Excel charts
  • The final milestone!
  • Bonus Lecture