Curriculum
11 Sections
44 Lessons
10 Weeks
Expand all sections
Collapse all sections
Excel Basics Refresher
4
1.1
Cell referencing
1.2
Formatting data
1.3
Basic formulas
1.4
Sorting and filtering
Advanced Formulas & Functions
4
2.1
IF, AND, OR
2.2
VLOOKUP, HLOOKUP
2.3
INDEX & MATCH
2.4
TEXT and DATE functions
Data Validation & Conditional Formatting
4
3.1
Drop-down lists
3.2
Custom rules
3.3
Color scales
3.4
Icon sets
Working with Tables
4
4.1
Creating Excel tables
4.2
Structured references
4.3
Table formatting
4.4
Table filtering
PivotTables & PivotCharts
4
5.1
Creating PivotTables
5.2
Grouping and summarizing
5.3
Slicers and filters
5.4
PivotCharts basics
Data Analysis Tools
4
6.1
What-If Analysis
6.2
Goal Seek
6.3
Scenario Manager
6.4
Data Tables
Advanced Charting Techniques
4
7.1
Combo charts
7.2
Dynamic charts
7.3
Sparklines
7.4
Chart formatting tricks
Power Query Basics
4
8.1
Importing multiple files
8.2
Data cleaning
8.3
Merge & append queries
8.4
Query editor tools
Power Pivot & Data Model
4
9.1
Enabling Power Pivot
9.2
Creating relationships
9.3
Using KPIs
9.4
Measures vs Calculated Columns
Macros & VBA Introduction
4
10.1
Recording Macros
10.2
VBA Editor basics
10.3
Writing simple codes
10.4
Assigning macros to buttons
Dashboard Design
4
11.1
Dashboard planning
11.2
Combining charts & visuals
11.3
Interactive elements
11.4
Clean and professional layout
Advanced Excel
Search
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
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