Building Surveyor and Property Development Diploma
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 |
Building Surveyor and Property Development Diploma