This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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
Basic Functions - Revision
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock