| Introduction |
|
Level 1 Welcome |
|
00:02:00 |
| Start Here- All TheBasic |
|
Opening Excel, And Creating A Shortcut |
|
00:04:00 |
|
The Anatomy Of A Workbook |
|
00:15:00 |
|
A Quick Review Of What’s Where |
|
00:06:00 |
|
Always Do This First! – Save Your New Workbook |
|
00:02:00 |
|
Let’s Enter Some Data |
|
00:02:00 |
|
Editing Data |
|
00:02:00 |
|
Ooops I Made A Mistake – Undo and Redo |
|
00:01:00 |
|
Changing Appearance Of Text With Formatting – Fonts |
|
00:09:00 |
|
A Quick Word On Formatting |
|
00:01:00 |
|
Formatting Text – Alignment |
|
00:03:00 |
|
Saving Time With AutoFilling Sequences |
|
00:05:00 |
|
NEW! – POWER USER – Adding Your Own Lists To Autofill |
|
00:04:00 |
|
Saving Time with Format Painter |
|
00:03:00 |
|
Changing The Column Width |
|
00:04:00 |
|
Tidy Large Titles With Merge And Centre |
|
00:03:00 |
|
A Couple Of Shortcuts For Entering Data |
|
00:04:00 |
| Doing The (Simple) Math |
|
Sums – The Old Fashioned Way! |
|
00:03:00 |
|
Sums – Using Autosum |
|
00:06:00 |
|
Copying Formulas |
|
00:03:00 |
|
SUMming Horizontally |
|
00:03:00 |
|
Basic Formulas – Subtraction |
|
00:02:00 |
|
Basic Formulas – Multiplication |
|
00:02:00 |
|
Basic Formulas – Division |
|
00:01:00 |
|
Average Function |
|
00:03:00 |
|
The Order Of Mathematical Operation |
|
00:07:00 |
|
POWER USER – Evaluate Formula |
|
00:05:00 |
| Rearranging Things |
|
Inserting New Columns And Rows |
|
00:06:00 |
|
Moving Existing Columns And Rows |
|
00:02:00 |
|
Cutting, Copying, Inserting And Deleting |
|
00:06:00 |
|
Hiding Columns And Rows |
|
00:03:00 |
| Formulas: Learning The Clever Stuff |
|
ROUNDing Functions |
|
00:06:00 |
|
Formatting Numbers |
|
00:02:00 |
|
A Primer In Building Complex Formulas |
|
00:03:00 |
|
Buliding a Compex Formula |
|
00:04:00 |
| A Few more Essentials |
|
Sorting |
|
00:04:00 |
|
Wrapping Text And Soft Enter |
|
00:04:00 |
|
Adding A New Worksheet |
|
00:01:00 |
|
Creating A Simple Chart |
|
00:04:00 |
|
Adding Borders |
|
00:03:00 |
|
Customizing the Quick Access Toolbar |
|
00:02:00 |
|
Simple Printing |
|
00:04:00 |
|
Freezing For An Easier View |
|
00:04:00 |
|
Getting Help |
|
00:02:00 |
|
Filters |
|
00:06:00 |
|
Highlighting Cells |
|
00:02:00 |
|
Closing |
|
00:01:00 |
| Bonus Section: Absolute and Relative Cell References |
|
$A1 Style – Absolute Relative |
|
00:02:00 |
|
$A$1 Style – Absolute Absolute |
|
00:03:00 |
|
$A1 Style – Absolute Relative |
|
00:02:00 |
|
A$1 Style – Relative Absolute |
|
00:02:00 |
| Additional Resources |
|
Resources : Microsoft Excel Basics |
|
00:00:00 |
| Order Your Certificate |
|
Order Your Certificate New |
|
00:00:00 |
