Course curriculum

  • 1

    Advanced Formulas 000 - Class Introduction

    • Advanced Formulas 001 - What You'll Learn

    • Advanced Formulas 002 - Class Files

  • 2

    Advanced Formulas 100 - Lookup Functions

    • Advanced Formulas 101 - Lookup Functions File

    • Advanced Formulas 102 - VLOOKUP Explained

    • Advanced Formulas 103 - XLOOKUP Explained

    • Advanced Formulas 104 - INDEX/MATCH Explained

    • Advanced Formulas 105 - XLOOKUP Chart Demo

  • 3

    Advanced Formulas 200 - Decision functions

    • Advanced Formulas 201 - Decision Functions File

    • Advanced Formulas 202 - What Are Conditional Booleans?

    • Advanced Formulas 203 - IF Explained

    • Advanced Formulas 204 - IFS Explained

    • Advanced Formulas 205 - CHOOSE Explained

    • Advanced Formulas 206 - SWITCH Explained

    • Advanced Formulas 207 - SUMIF & COUNTIF Explained

    • Advanced Formulas 208 - Facebook Chart Demo

  • 4

    Advanced Formulas 300 - New Excel Functions

    • Advanced Formulas 301 - New Functions File

    • Advanced Formulas 302 - UNIQUE Explained

    • Advanced Formulas 303 - FILTER Explained

    • Advanced Formulas 304 - TEXTJOIN Explained

    • Advanced Formulas 305 - LET Explained

  • 5

    Advanced Formulas 400 - Advanced Formula Tools

    • Advanced Formulas 401 - Named Ranges

    • Advanced Formulas 402 - What to know about Named Ranges

    • Advanced Formulas 403 - Named Ranges Demo

    • Advanced Formulas 404 - Excel Tables

    • Advanced Formulas 405 - How Excel Tables are like advanced filters

    • Advanced Formulas 406 - Advanced Formula Tools file

  • 6

    Advanced Formulas 500 - Wrap up

    • Advanced Formulas 501 - Wrap-up