Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel Masterclass
Introduction
Introduction (2:22)
Course Resources
Essential Formulas
Mathematical Functions (6:50)
Exercise 1/12: Mathematical Formulas
Textual Formulas (7:47)
Exercise 2/12: Textual Formulas
Logical Formulas (11:23)
Exercise 3/12: Logical Formulas
Date-time (Temporal) Formulas (7:07)
Exercise 4/12: Date-Time Formulas
Lookup Formulas
Lookup Formulas (8:46)
Exercise 5/12: Lookup Formulas
Data Tools
Data Tools (19:07)
Exercise 6/12: Data Tools
Formatting data and tables
Formatting data and tables (18:00)
Exercise 7/12: Formatting
Pivot Tables
Pivot Tables (8:25)
Exercise 8/12: Pivot tables
Charts
Charts-Part 1 (9:59)
Charts-Part 2 (12:00)
Exercise 9/12: Charts
Excel Shortcuts
Excel Shortcuts (12:33)
Exercise 10/12: Shortcuts
Analytics in Excel
Analytics in Excel (15:48)
Exercise 11/12: Analytics
Macros
Macros (10:04)
Exercise 12/12: Macros
Bonus Lectures
Waterfall chart (12:00)
Infographics 1: Cool charts (14:12)
Infographics 2: Cool charts (6:51)
Pivot Tables
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock