Table of Contents

1. Course Introduction
   • Introduction and About the Instructor 00:02:14
   • What will I Learn? 00:02:07
2. Logical Functions
   • AND and IF Functions 00:09:41
   • IFERROR and XOR Functions 00:12:24
3. Financial Functions
   • PV and FV Functions 00:14:59
   • PMT-PPMT-PRICE-YIELD Functions 00:11:40
   • PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions 00:10:29
   • Depreciation 00:07:44
   • SLN-SYD-DB-DDB-VDB Functions 00:13:46
4. Text Functions
   • TEXT and CONCATENATE Functions 00:11:10
   • PROPER-UPPER-LOWER-SUBSTITUTE Functions 00:10:13
5. Lookup & Reference Function
   • LOOKUP Function Lecture 00:04:58
   • Working with Advanced VLOOKUP 00:12:17
   • HLOOKUP-INDEX-MATCH Functions 00:17:45
6. Bonus Selection
   • Modifying Existing Templates 00:11:07
   • Copying Macros Between Workbooks 00:04:24
   • Working with External Data Sources 00:10:16
   • Exploring Tracking Changes Feature 00:11:51
7. Course Conclusion
   • Course Conclusion 00:02:37