• 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 )
710 STUDENTS
$ 249.00
Microsoft Excel Basics

Professional Marketing and Advertising Complete Online Course

Professional Marketing and Advertising Complete Online Course

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel