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
Learn Excel Essentials
Welcome
Course Overview (1:50)
Navigating the Course (2:28)
Buying/Trialling an Excel License (If you don't have Excel!) (1:32)
Resources
Section I - Introduction to Excel
First Steps into Excel (12:10)
Introduction to Formulas & Functions (12:30)
Order of Operations (10:57)
Relative and Absolute cell references (10:00)
More Formulas & Functions (13:24)
General Usage Features (7:39)
Test your learning
Checkpoint 1
Build a Budget - Checkpoint 1 (12:19)
Section II - Exploring Excel
Find, Replace, Go To (7:25)
Formatting (10:16)
Filtering & Sorting (14:42)
Copy & Paste Options (7:25)
Protection of Workbook, Worksheet & Cells (6:51)
Test your learning
Checkpoint 2
Build a Budget - Checkpoint 2 (20:28)
Section III - Working with Data
Conditional Formulae (6:36)
Efficiency & Shortcuts (7:03)
My Top 10 Excel Shortcuts (11:02)
Range Names & Data Validation (8:33)
Text to Columns, csv files & Remove Duplicates (6:14)
Data Visualisation (8:40)
Test your learning
Checkpoint 3
Build a Budget - Checkpoint 3 (31:21)
Section IV - Advanced Features
Lookups (15:11)
Match & Index (10:21)
Pivot Tables & Pivot Charts (12:52)
Test your learning
Checkpoint 4
Build a Budget - Checkpoint 4 (24:30)
Section V - Exercises
Exercises Introduction
Data Reconciliation (13:36)
Effective Data Set Up (6:33)
Reference Functions (23:19)
Section VI - Project
Project - Data Dashboard (1:29)
Project - Data Dashboard Walkthrough (27:30)
Wrap up
Course Completion Summary (2:15)
Navigating the Course
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock