Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Formulas in Excel
Section 1: Introduction
Introduction (2:33)
Course Files
Section 2: Advanced Formulas
Filter a Dataset Using a Formula (7:56)
Sort a Dataset Using a Formula and Defined Variables (13:39)
Multiple Dependent Dynamic Drop-down Lists (10:40)
Perform a Two-way Lookup (11:51)
Make Decisions with Complex Logical Calculations (16:37)
Extracting Parts of a Text String (16:13)
Creating a Dynamic Chart Title (13:50)
Finding the Last Occurence of a Value in a List (13:59)
Looking up Information with XLOOKUP (10:52)
Find the Closest Match to a Value (8:02)
Section 3: Course Close
Course Close (1:23)
Course Quiz and Certificate of Completion
Introduction
Complete and Continue