Excel Formulas & Functions Part 1+2: Formulas 101

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
11 Lessons (39m)
    • 1. Introduction

      1:06
    • 2. The Formula Library & Auditing Tools

      4:37
    • 3. DEMO: Using the Evaluate Formula Tool

      1:25
    • 4. Basic Formula Syntax

      3:31
    • 5. Fixed, Relative, & Mixed References

      4:57
    • 6. Common Errors & the IFERROR statement

      7:25
    • 7. Function, CTRL & ALT Shortcuts

      6:36
    • 8. BONUS: Shortcuts for Mac Users

      2:08
    • 9. Creating Custom Data Validation Rules

      3:28
    • 10. Fixed vs. Volatile Functions

      3:21
    • 11. Homework

      0:46
19 students are watching this class