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)
First Steps into Excel
Summary
Starting Excel
Excel window - Quick access toolbar, Ribbon, Formula Bar (collapse/reopen)
Cells
Navigation
Data entry
Undo and Redo
Basic copy/paste and the fill handle
Add/remove rows/columns/cells
Zoom in and out
'Workbook' vs 'Sheets within Workbook'
Complete and Continue
Discussion
0
comments
Load more
0 comments