Autoplay
Autocomplete
Previous Lecture
Mark as completed
Microsoft Excel for Analytics
Module 1 Excel Essentials
Exercise Files
Database Features (28:38)
Text Functions (21:04)
FlashFill (6:38)
Data Validation (20:21)
Logical Functions (26:17)
COUNTIFS (23:54)
VlookUP (21:53)
3D Formulas (9:21)
Consolidate Data (29:06)
Module 2 Excel Tables
Exercise Files
Label Replacement (5:05)
Introduction (7:14)
Auto Expansion (10:15)
Slicers (4:36)
Structured Referencing (12:18)
Module 3 Excel Charts and visual analytics
Exercise Files
Excel Reporting (85:39)
Visual analytics (139:29)
Module 4 Conditional Formatting
Exercise Files
Highlight cells (8:55)
Data Bars (5:21)
Color Scale (4:07)
Icon Sets (6:17)
Top and Bottom rules (4:47)
Module 5 Pivot Tables and Charts
Excel Tables and PivotTables (182:34)
Advanced Pivot Tables (141:37)
Module 6 Excel Business Intelligence: Power Query
Getting started with Power Query
System Requirements
Data Cleaning and Wrangling using Power Query (199:36)
Module 7 Data Modeling with PowerPivot
Data Modeling and DAX (202:42)
Guided Project
Exercise Files
Guided Project (124:04)
Exercise Files
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock