Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Microsoft Excel
Course Overveiw
Overview (2:59)
Section 0 Course Revision
0.0 Advanced Excel Exercise Instructions (12:38)
Section 1 IFs, CountIFs, AverageIFs and SumIFs with Match and Index
1.0 Avanced Excel Part 1 (41:27)
1.0A Let Function (8:13)
1.0B Sequence Function (9:31)
1.0C Stock History (6:03)
1.0D Rolling Averages (7:10)
1.1 exercise Instructions Part 1 (17:26)
Section 2 Data Analysis
2.0 Avanced Excel Part 2 (40:02)
2.1 Exercise Instructions Part 2 (11:40)
Section 3 Power Query, Power Pivot
3.0 Avanced Excel Part 3 (45:37)
3.1 Exercise Instructions Part 3 (3:27)
Section 4 Search, Concatenate, Filter, Text and Date Functions and Frequency
4.0 Avanced Excel Part 4 (66:27)
4.1 Exercise Instructions Part 4 (8:05)
4.1A Filter Function with SumIFs, SumIF (10:33)
Section 5 Vlookup and Weblinks
5.0 Avanced Excel Part 5 (13:57)
5.2 Exercise Instructions Part 5 (6:29)
5.1 Xlookup (10:14)
Section 6 Basic Macros
6.0 Avanced Excel Part 6 (14:15)
6.1 Exercise Instructions Part 6 (4:07)
Section 7 Form Controls
7.0 Avanced Excel Part 7 (10:09)
7.1 Exercise Instructions Part 7 (3:41)
Gantt Charts in Excel (19:31)
Section 8 Data Validation and Indirect Validation
8.0 Avanced Excel Part 8 (11:49)
8.1 Exercise Instructions Part 8 (3:50)
Section 9 Final Consolidation Exercise
9.0 Exercise Instructions Final (13:33)
Teach online with
9.0 Exercise Instructions Final
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock