Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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 Videos (39m)
    • Introduction

      1:06
    • The Formula Library & Auditing Tools

      4:37
    • DEMO: Using the Evaluate Formula Tool

      1:25
    • Basic Formula Syntax

      3:31
    • Fixed, Relative, & Mixed References

      4:57
    • Common Errors & the IFERROR statement

      7:25
    • Function, CTRL & ALT Shortcuts

      6:36
    • BONUS: Shortcuts for Mac Users

      2:08
    • Creating Custom Data Validation Rules

      3:28
    • Fixed vs. Volatile Functions

      3:21
    • Homework

      0:46