Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Beyond the Basics - On Demand (Recorded)
Resources
Course Materials
Practice Files
Lesson 1 - Review, Tips and Tricks
Lesson 1 (46:35)
Homework Assignment
Homework Review Video (15:15)
Lesson 2 - Excel Tables and Conditional Formatting
Lesson 2 (49:36)
Homework Assignment
Homework Review Video (13:52)
Lesson 3 Excel Functions: IF, COUNTIF, SUMIF
Lesson 3 (43:15)
Homework Assignment
Homework Review Video (20:56)
Lesson 4 - More Excel Functions: VLOOKUP, ROUND, NOW
Lesson 4 (48:12)
Homework Assignment
Homework Review Video (10:47)
Lesson 5 - Excel Graphs and Working with Multiple Sheets
Lesson 5 (52:57)
Homework Assignment
Homework Review Video (8:42)
Lesson 6 - Excel Sorting and Filtering
Lesson 6 (52:34)
Homework Assignment
Homework Review Video
Lesson 7 - Excel Subtotals
Lesson 7 (50:38)
Homework Assignment
Homework Review Video (8:46)
Lesson 8 - Excel Pivot Tables
Lesson 8 (54:13)
Homework Assignment
Homework Review Video (18:34)
Lesson 9 - Named Ranges and Data Validation (Drop Down Lists)
Lesson 9 (49:07)
Homework Assignment
Homework Review Video (12:01)
Lesson 10 - Review
Lesson 10 (48:15)
Files Used
Wrap up
Your feedback
Teach online with
Lesson 4
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock