Home
Courses
View Courses
Purchase Courses & Bundles
Account
Home
Courses
View Courses
Purchase Courses & Bundles
Account
Advanced Excel Mastery
Curriculum
8 Sections
57 Lessons
Lifetime
Expand all sections
Collapse all sections
Week 1- Introduction
13
0.1
Download the Practice Workbook- Week 1
0.2
Introduction to interface
0.3
Formatting 1
0.4
Formatting 2
0.5
Number Formatting
0.6
Navigation Shortcut
0.7
Format Painter
0.8
Inserting Rows and Columns
0.9
Autofill
0.10
Sorting
0.11
Text Based Filter
0.12
Number Based Filter
0.13
Date Based Filter
Week 2- Part 1: Logical Formulas
9
1.1
Download the Practice Workbook- Week 2
1.2
References
1.3
Sum
1.4
If Formula
1.5
Nested If
1.6
And & Or
1.7
And + If
1.8
If + OR
1.9
If + Not
Week 2- Part 2: If & Ifs Formulas
4
2.0
Count If
2.1
Average If
2.2
Count Ifs
2.3
Average Ifs
Week 2- Part 3: Statistical Formulas
2
3.0
Statistical Formula
3.1
Large Small Rank
Week 2- Part 4: Lookups
4
4.0
VLOOK Up
4.1
Approximate Match
4.2
HLOOK Up
4.3
Index
Week 2- Part 5: Other Formulas
3
5.0
Switch
5.1
Date Formulas
5.2
Text Formulas
Week 3- Visualization
12
6.1
Download the Practice Workbook- Week 3
6.2
Bar and Column Chart
6.3
Changing Elements
6.4
Different Types of Bar and Column Chart
6.5
Line Chart
6.6
Formatting Chart Elements
6.7
Pie Chart
6.8
Donut Chart
6.9
Waterfall
6.10
Conditional Formatting
6.11
Heatmap
6.12
Combo Chart
Week 4- Pivot Table
10
7.0
Download the Practice Workbook- Week 4
7.1
Pivot Table
7.2
Tables
7.3
Intro to Source Data
7.4
Inserting Pivot Table
7.5
Understanding Fields List
7.6
Clear-Select-Move
7.7
Refreshing Data in Pivot Table
7.8
Conditional Formatting in Pivot Table
7.9
Pivot Charts
This content is protected, please
login
and
enroll
in the course to view this content!
Login
Sign Up
Remember me
Forgot Password?
Sign in
I accept the
Terms of Service and Privacy Policy
Sign Up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
Email Reset Link
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content
