Building Surveyor and Property Development Diploma
Testimonial
Hear what our happy students want to say
Previous
Next
Course Curriculum
Course Curriculum
| 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 | ||
