Course Introduction
  • Introduction and About the Instructor
  • What will I Learn?
Logical Functions
  • AND and IF Functions
  • IFERROR and XOR Functions
Financial Functions
  • PV and FV Functions
  • PMT-PPMT-PRICE-YIELD Functions
  • PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions
  • Depreciation Lecture
  • SLN-SYD-DB-DDB-VDB Functions
Text Functions
  • TEXT and CONCATENATE Functions
  • PROPER-UPPER-LOWER-SUBSTITUTE Functions
Lookup & Reference Function
  • LOOKUP Function Lecture
  • Working with Advanced VLOOKUP
  • HLOOKUP-INDEX-MATCH Functions
Additional Learning resources
  • Modifying Existing Templates
  • Copying Macros Between Workbooks
  • Working with External Data Sources
  • Exploring Tracking Changes Feature
Course Conclusion
  • Course Conclusion