This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
0.0 Advanced Excel Exercise Instructions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock