- Introduction Free
- Formula Syntax Free
- Fixed & Relative References Free
- Common Error Types Free
- Formula Auditing: Trace Precedents & Dependents Free
- Formula Auditing: Evaluate Formula & Error Checking Free
- Ctrl Shortcuts Free
- Function Shortcuts Free
- Alt Key Tips Free
- PRO TIP: Data Validation Free
- Congrats, You're a Developer! Pro
- HOMEWORK: Formulas 101 Pro
- QUIZ: Formulas 101 Pro
- Introduction Pro
- Basic Statistical Functions Pro
- SMALL/LARGE & RANK/PERCENTRANK Pro
- RAND() & RANDBETWEEN Pro
- The SUMPRODUCT Function Pro
- SUMPRODUCT Demo Pro
- COUNTIFS/SUMIFS/AVERAGEIFS Pro
- DEMO: Building a Basic Dashboard Pro
- Combining COUNTIF & SUMPRODUCT Pro
- PRO TIP: Data Profiling with COUNT & SUMPRODUCT Pro
- HOMEWORK: Statistical Functions Pro
- QUIZ: Statistical Functions Pro
- Introduction Pro
- Working with Named Arrays Pro
- ROW/ROWS & COLUMN/COLUMNS Pro
- VLOOKUP/HLOOKUP Pro
- Joining Data with VLOOKUP Pro
- Fixing Errors with IFERROR & VLOOKUP Pro
- VLOOKUP Reference Array Options Pro
- Approximate Match Lookups Pro
- The INDEX Function Pro
- The MATCH Function Pro
- Using INDEX & MATCH Together Pro
- Combining MATCH with VLOOKUP Pro
- UPDATE: VLOOKUP Correction Pro
- XLOOKUP (Office 365 Only) Pro
- DEMO: Building Dashboards with XLOOKUP Pro
- Selecting List Items with CHOOSE Pro
- The OFFSET Function Pro
- Combining OFFSET with COUNTA Pro
- DEMO: Using OFFSET to Create a Dynamic Scrolling Chart Pro
- HOMEWORK: Lookup/Reference Functions Pro
- QUIZ: Lookup/Reference Functions Pro
- Introduction Pro
- DATEVALUE Pro
- Date Formatting & Fill Series Pro
- TODAY()/NOW() Pro
- YEAR/MONTH/DAY & HOUR/MINUTE/SECOND Pro
- The EOMONTH Function Pro
- The YEARFRAC Function Pro
- WEEKDAY, WORKDAY & NETWORKDAYS Pro
- The DATEDIF Function Pro
- DEMO: Designing a Sample Budget Pacing Tool Pro
- HOMEWORK: Date & Time Functions Pro
- QUIZ: Date & Time Functions Pro
- Introduction Pro
- Creating, Editing & Managing Formula-Based Rules Pro
- Highlighting Every Other Row Using the MOD Function Pro
- Formatting Cells Based on the Value of Another Cell Pro
- Formatting Cells Using Statistical Functions Pro
- Formatting Cells Using Text Functions & Logical operators Pro
- HOMEWORK: Formula-Based Formatting Pro
- QUIZ: Formula-Based Formatting Pro
- Intro & Compatibility Pro
- Project Intro: Maven Recruiters Pro
- Legacy vs. Dynamic Excel Pro
- Spill Range Properties Pro
- PRO TIP: Growing Source Data Pro
- Common Dynamic Array Functions Pro
- The SORT Function Pro
- The SORTBY Function Pro
- The FILTER Function Pro
- The UNIQUE Function Pro
- PRO TIP: Drop-down Lists with SORT & UNIQUE Pro
- Combining SORT, FILTER & UNIQUE Pro
- Referencing Spill Ranges in Calculations Pro
- Conditional Formatting with Dynamic Arrays Pro
- PRO TIP: Creating Charts from Dynamic Arrays Pro
- The SEQUENCE Function Pro
- PRO TIP: Top N Calculations with SEQUENCE & LARGE Pro
- The RANDARRAY Function Pro
- PRO TIP: Creating Random Top N Lists Pro
- The FREQUENCY Function Pro
- The TRANSPOSE Function Pro
- PRO TIP: Joining Arrays with CHOOSE Pro
- PRO TIP: Declaring Variables with LET Pro
- HOMEWORK: Dynamic Array Formulas Pro
- QUIZ: Dynamic Array Formulas Pro