Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel 2019 Advanced
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (1:21)
Creating and Applying Named Ranges (8:18)
Navigating with Named Ranges (1:43)
IF Functions (3:51)
More IF Functions (2:50)
Introduction to Nesting Functions (4:09)
The Round Function (3:22)
Formula Auditing Tools (4:00)
Introduction to VLOOKUP (4:17)
VLOOKUP (2:15)
VLOOKUP and IFERROR (2:23)
Database Functions - SUMIF and AVERAGEIF (4:05)
Database Functions - SUMIFS (3:30)
Text Functions (7:04)
Consolidate by Position (4:17)
Consolidate by Category (2:56)
Goal Seek (2:50)
Introduction to Data Tables (3:03)
Data Tables (1:19)
Scenario Manager (4:42)
Macros - Adding the Developer Tab (2:14)
Macros - Recording and Running the Header Macro (5:46)
Macros - Visual Basic Editor and Form Control (4:32)
Macros - Adding Macros to the Ribbon (2:36)
Macros - Exercise (5:04)
Macros - Adding Macros to the Ribbon
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock