15 Sections
49 Lessons
Lifetime
Expand all sections
Collapse all sections
Logical Functions
3
1.1
IF, AND, OR, NOT
1.2
Nested IF formulas
1.3
IF with text, numbers, and dates
Quiz for Advanced Excel
1
2.1
Quiz – Advanced Excel
40 Questions
Lookup & Reference Functions
5
3.1
VLOOKUP & HLOOKUP
3.2
XLOOKUP
3.3
INDEX & MATCH
3.4
INDIRECT, ADDRESS
3.5
CHOOSE function
Text Functions
3
4.1
LEFT, RIGHT, MID, LEN, FIND, SEARCH
4.2
UPPER, LOWER, PROPER, TRIM
4.3
TEXT, CONCAT, TEXTJOIN, SUBSTITUTE, REPLACE
Date & Time Functions
3
5.1
TODAY(), NOW()
5.2
DATEDIF(), NETWORKDAYS(), WORKDAY()
5.3
EOMONTH(), YEARFRAC(), WEEKDAY()
Data Analysis Tools
5
6.1
Data Validation (drop-downs, custom rules)
6.2
Remove Duplicates
6.3
Flash Fill
6.4
Text to Columns
6.5
Consolidate data
Conditional Formatting
3
7.1
Highlight cells based on conditions
7.2
Data bars, color scales, icon sets
7.3
Using formulas in conditional formatting
Sorting & Filtering
4
8.1
Multi-level sorting
8.2
Custom sorting
8.3
Advanced filters (AND/OR criteria)
8.4
Search box filters
Charts & Visualization
4
9.1
Column, Bar, Line, Pie, Combo Charts
9.2
Dynamic Charts with drop-down
9.3
Sparklines
9.4
Chart formatting tips
Pivot Tables & Dashboarding
5
10.1
Creating pivot tables
10.2
Rearranging Rows, Columns, Values, Filters
10.3
Grouping data (dates, numbers)
10.4
Calculated Fields & Items
10.5
Show Values As (% of total, difference from, etc.)
Pivot Charts
3
11.1
Inserting and modifying Pivot Charts
11.2
Dynamic filters with Slicers
11.3
Timelines for date-based filtering
Dashboard Techniques
4
12.1
Designing interactive dashboards
12.2
Using slicers and charts together
12.3
Linking cells for dynamic headlines/numbers
12.4
Best practices for layout and design
Power Tools & Automation
4
13.1
Importing data from Excel, CSV, Web
13.2
Cleaning data (remove blanks, split columns)
13.3
Merging and appending queries
13.4
Basic transformations (pivot/unpivot, transpose)
What-If Analysis Tools
3
14.1
Goal Seek
14.2
Scenario Manager
14.3
Data Tables (1-variable and 2-variable)
Advanced Named Ranges
0
Master Advanced Excel in 30 Days – Pro Tips, Formulas & Dashboards
Curriculum
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
Login with your Social ID
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Login with your Social ID
Are you a member?
Login now
Modal title
Main Content