This site is powered by
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Putting Excel to work (Full Excel course)
Relative, Absolute and Mixed cell references
Relative cell references (3:55)
Absolute cell references (7:04)
Mixed cell references (7:01)
Practice exercises
PDF summary
Working with Worksheets
Worksheet basics (2:41)
Moving worksheets, Ranges, Groups and Protection (16:03)
Hiding, Unhiding and protecting structure (4:34)
Practice exercises
PDF summary
Working with lists
Sorting (9:06)
Filtering (10:05)
Subtotaling (5:17)
Practice exercises
PDF summary
Printing from Excel
Print Preview (4:45)
Headers and Footers (6:56)
Large worksheets (6:06)
Practice exercises
PDF summary
Using named ranges
Named range basics (10:14)
Drop-down lists and reporting (11:06)
Managing Names (7:12)
Practice exercises
PDF summary
The IF function
IF basics - Numbers, text and formulas (9:30)
ANDs ORs and NOTs (9:33)
IFS and nested IF (12:22)
Practice exercises
PDF summary
Dates and Time
Dates are numbers (4:04)
Date functions (11:32)
Date formats (1:22)
Times are numbers (12:19)
Time functions (5:45)
Date and Time combos (2:51)
Practice exercises
PDF summary
Lookup techniques with XLOOKUP
Do I use XLOOKUP or VLOOKUP? (0:47)
XLOOKUP Basics (8:30)
Matching and More about Return arrays (9:23)
Using Tables with XLOOKUP (4:38)
Nested XLOOKUPs (5:03)
Practice exercises
PDF summary
Lookup techniques with VLOOKUP
Do I use VLOOKUP or XLOOKUP? (0:47)
VLOOKUP with Exact match (7:08)
VLOOKUP with Approximate match (4:27)
Using Named ranges (5:02)
Using Tables (4:04)
HLOOKUP (2:22)
Practice exercises
PDF summary
Conditional formatting
Basic formatting rules (5:59)
Tweaking the rules (5:52)
Using formulas for rules (5:40)
Rules management (6:05)
Practice exercises
PDF summary
Data validation and drop-down lists
Basic validation techniques (12:42)
Using formulas in validation (11:24)
Practice exercises
PDF summary
The magic of Tables
Creating a Table (11:32)
Using Tables with functions (6:44)
Practice exercises
PDF summary
Charts
Line charts (10:39)
Column and Pie charts (11:00)
Combo charts and Templates (5:27)
Practice exercises
PDF summary
Massaging data
Splitting and joining (7:24)
Manipulating text (9:41)
Trimming and converting text (5:35)
Practice exercises
PDF summary
Consolidating data
Simple linking (10:03)
The CONSOLIDATE function (11:16)
Practice exercises
PDF summary
PivotTables
Creating a PivotTable (8:37)
PivotTable Calculations (7:02)
Sprucing up PivotTables and PivotCharts (6:44)
Practice exercises
PDF summary
Custom number formatting
Built-in formats (17:32)
Writing custom formats (10:13)
Practice exercises
PDF summary
Get & Transform (Power Query)
Introduction to Power Query (15:05)
Combining Queries (14:43)
Practice files
Practice exercises
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock