Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Intermediate
Introduction
Introduction Video (7:18)
Revision
Basic Functions - Revision (15:34)
Named cells and Ranges
Named cells and ranges (10:44)
Conditional Formatting
Conditional Formatting (14:39)
Covid19 Test Monitor (8:00)
Weight Loss Tracker (9:35)
Automatically highlight weekends (4:51)
Grouping, SubTotals and CountiF
Grouping (10:31)
Subtotals and CountIF (3:17)
Pivot Tables
Pivot Tables (19:13)
Dashboard with Camera (10:44)
9.0B Link Access to Excel (7:20)
IF SumIF and CountIF
IF SumIF and CountIF (17:11)
Ratios (6:35)
Charts
Waterfall charts and dial charts (10:12)
Maps in Excel (5:15)
3D Maps (7:25)
Dynamic Charts (8:27)
Pareto Analysis charts (7:51)
Gantt Charts (8:52)
S Curve (4:27)
QR Codes (5:26)
Lookups
Vlookup and Hlookup (4:05)
Consolidation Exercise
Consolidation exercise two
Teach online with
Grouping
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock