Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Essentials - you need these first
Welcome
Overview and what to expect (5:49)
About the instructor (3:40)
Let's meet the Excel environment (2:07)
Resources
Data Entry
Introduction to Data Entry (1:07)
Why is data entry so important?
Dos and Don'ts of Data Entry (3:54)
Enter dates and numbers in sequence (3:10)
What to do when you see ###### (3:12)
Here's your homework (3:39)
Quiz on Data Entry
Data Formatting
Introduction to Data Formatting (1:04)
Formatting Text (2:29)
Formatting Text - alignment (3:23)
Formatting numbers (2:26)
Test your learning
Copying the formatting from another cell - Using the Format Painter (1:28)
Clearing all formats (1:20)
Here's your homework (5:03)
Quiz on Data Formatting
Introduction to Formulas
Introduction to Basic Formulas (1:20)
Basic formula entry (2:46)
Addition and subtraction (2:43)
Multiplication and Division (2:04)
Test your learning
Using Brackets (1:54)
Here's your homework (6:53)
Quiz on Basic Formulas
Fixing cells
Introduction to fixing cells aka making it absolute (1:59)
Fixing cells (3:25)
Here's your homework (2:28)
Quiz on fixing cells
Navigation around Excel
Excel keyboard shortcuts
Working with rows and columns (3:40)
Homework
Quiz on navigating in Excel
Basic Functions
Introduction to Basic Functions (2:10)
Using Autosum to create totals (1:41)
Basic Functions: Max, Min, Count, Average, Count, CountA (3:28)
Here's your homework (1:32)
Quiz on Basic Functions
Creating charts
Introduction to Charts (1:14)
Use Recommended charts and clean data (2:36)
Chart Formatting (2:51)
Here's your homework (2:12)
Quiz on Charts
Worksheets
Introduction to working with worksheets aka tabs (1:18)
Move/Copy to another workbook (2:37)
Add/Colour/Delete/Hide/New worksheets (3:28)
Creating 3-D formulas i.e. creating a formula across worksheets (3:58)
Here's your homework (1:38)
Quiz on Worksheets
Creating lists in Excel
Introduction to Lists in Excel (1:09)
Guidelines on setting up a list (4:55)
Sorting by one level (2:12)
Sorting by more than one level (2:35)
Filtering with Text (2:25)
Filtering with numbers (3:00)
Filtering with dates (2:06)
Here's your homework (4:41)
Quiz on creating lists in Excel
Printing
Introduction to Printing (1:21)
Getting the text to fit (2:06)
Adding headings AKA Using Print Titles (3:56)
Here's your homework
Quiz on Printing
Teach online with
Test your learning
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock