Excel Advanced Functions and Formulas Course Introduction
  • Introduction
  • Course Exercise Files
Advanced Excel Formula Fundamentals
  • Advanced Excel Formula Fundamentals Exercise File (DOWNLOAD)
  • Excel Absolute vs. Relative Cell References
  • Excel Absolute vs. Relative Cell References CONTINUED
  • Variations on Excel's Absolute References
  • Excel Name Ranges
  • Creating Powerful Formulas by Nesting Functions
Evaluating and Debugging Excel Formulas
  • Evaluating Excel Formulas Exercise File (DOWNLOAD)
  • Evaluate Formulas
  • Locating Errors in a Formula
  • Using Excel's IFERROR() Function
Excel Array Formulas
  • Array Formulas Exercise File (DOWNLOAD)
  • What are Arrays?
  • Nesting Array Formulas
  • Using Arrays to SUM Data
  • Streamline Conditions Using Arrays
Fundamentals of Using Excel's INDEX() and MATCH() Functions
  • Index and Match Functions Exercise File (DOWNLOAD)
  • Excels INDEX() Function
  • Excels MATCH() Function
  • Nesting INDEX() and MATCH()
Excel Index() and Match() Exercises
  • Intro to Return an Assoicated Value Using INDEX() and MATCH()
  • Exercise File (DOWNLOAD)
  • Intro to Creating a Dynamic SUM() Using INDEX()
  • Creating a Dynamic SUM() Using INDEX() Continued
  • Intro to Combine Multiplication with INDEX() and MATCH()
  • Combine Multiplication with INDEX() and MATCH() Continued
  • Intro to Create a Dynamic VLOOKUP() with MATCH()
  • Create a Dynamic VLOOKUP() with MATCH() Continued
  • Create a Dynamic VLOOKUP() with MATCH() Continued
  • Intro to Turn INDEX() and MATCH() into an ARRAY
  • Turn INDEX() and MATCH() into an ARRAY Continued
  • Intro to Returning Multiple Values with INDEX()
  • Returning Multiple Values with INDEX() Continued
  • Returning Multiple Values with INDEX() Continued
  • Returning Multiple Values with INDEX() Continued
  • Intro to Adding Criteria to INDEX() and MATCH()
  • Adding Criteria to INDEX() and MATCH() Continued
  • Return an Assoicated Value Using INDEX() and MATCH() Continued
  • Intro to Conditional Formatting Using MATCH()
  • Conditional Formatting Using MATCH() Continued
Congratulations
  • Congratulations