• LOGIN
  • No products in the cart.

Login

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

Microsoft Excel Basics

4.9( 7 REVIEWS )
686 STUDENTS
$ 249.00
Microsoft Excel Basics

Self Motivation Course

Self Motivation Course

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel