Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel Essentials: Level 1 Basics - Excel Made Simple
Section 1 - Start Here - All The Basics
Welcome To The Course! (2:06)
Opening Excel, And Creating A Shortcut (3:45)
The Anatomy Of A Workbook (15:19)
A Quick Review Of What's Where (6:11)
Always Do This First! - Save Your New Workbook (2:00)
Let's Enter Some Data (1:41)
Quiz 1
Editing Data (1:42)
Ooops. I Made A Mistake - Undo and Redo (1:20)
Changing Appearance Of Text With Formatting - Fonts (9:03)
A Quick Word On Formatting (1:20)
Formatting Text - Alignment (3:07)
Saving Time With AutoFilling Sequences (4:40)
POWER USER - Adding Your Own Lists To Autofill (4:23)
Saving Time with Format Painter (2:48)
Quiz 2
Changing The Column Width (3:33)
Tidy Large Titles With Merge And Centre (3:01)
A Couple Of Shortcuts For Entering Data (3:57)
Section 2 - Doing The (Simple) Math
Sums - The Old Fashioned Way! (3:11)
Sums - Using Autosum (5:32)
Quiz 3
Copying Formulas (3:16)
SUMming Horizontally (3:16)
Basic Formulas - Subtraction (2:28)
Basic Formulas - Multiplication (1:32)
Basic Formulas - Division (1:21)
Average Function (2:41)
The Order Of Mathematical Operation (6:38)
POWER USER - Evaluate Formula (4:50)
Section 3 - Rearranging Things
Inserting New Columns And Rows (6:21)
Moving Existing Columns And Rows (2:27)
Cutting, Copying, Inserting And Deleting (6:07)
Hiding Columns And Rows (2:41)
Quiz 4
Section 4 - Formulas Learning The Clever Stuff!
ROUNDing Functions (5:55)
Formatting Numbers (2:12)
A Primer In Building Complex Formulas (3:10)
Building a Complex Formula (4:19)
Section 5 - A Few More Essentials
5000 Sorting (4:16)
Wrapping Text And Soft Enter (3:59)
Adding A New Worksheet (1:07)
Creating A Simple Chart (4:20)
Quiz 5
Adding Borders (2:36)
Customizing the Quick Access Toolbar (2:11)
Simple Printing (3:34)
Freezing For An Easier View (4:06)
Getting Help (1:39)
Filters (6:21)
Highlighting Cells (2:03)
Final Quiz
Closing (1:29)
Section 6 - Bonus Section - The Keyboard Shortcuts
Bonus 1 Whizzing Around Excel Revision (6:45)
Bonus 2 Keyboard Shortcuts (11:18)
Section 7 - Bonus Section Absolute and Relative Cell References
Bonus 3 - A1 Style - Relative Relative (2:15)
Bonus 3 - $A$1 Style - Absolute Absolute (2:44)
Bonus 3 - $A1 Style - Absolute Relative (2:16)
Bonus 3 - A$1 Style - Relative Absolute (2:01)
Section 8 - Student Questions Answered
Level 1 SQA 01 - Reverse Engineering A Sample Spreadsheet (20:55)
Level 1 SQA 02 - Casing And Text Functions (6:35)
Level 1 SQA 03 - Charts From A Filtered List (2:54)
Saving Time with Format Painter
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock