Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel Power User
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (1:32)
IF Function Basics (6:16)
IF Functions with Calculations (4:22)
Nesting AND with IF (6:19)
Naming Ranges and COUNTIF (5:57)
SUMIF and AVERAGEIF (4:55)
SUMIFS (4:01)
XLOOKUP (8:25)
Populating Forms with XLOOKUP (8:35)
Displaying Pivot Table Fields with COUNT Function (4:50)
Calculated Fields (6:46)
Slicers (6:08)
Using the Timeline (5:14)
Inserting Report Filter Pages (4:41)
Flash Fill for Text Functions (6:16)
Introduction to Advanced Conditional Formatting and Macros (0:47)
Array Formula Basics (6:18)
Looking Up Multiple Values with XLOOKUP (5:01)
Array Functions (7:07)
Advanced Conditional Formatting (7:27)
Combo Charts (7:42)
Developer Tab (4:13)
Macro Basics (6:36)
Relative Reference Macros (3:59)
VBA Basics (6:44)
Cleaning Up Macros (8:31)
Conclusion (1:02)
Flash Fill for Text Functions
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock