Please ensure Javascript is enabled for purposes of website accessibility

About This Course

Who this course is for:

  • This course is aimed at complete beginners, or those who want to get a thorough knowledge of the basics
  • Anyone looking to increase their chances of better paying jobs, through mastering MS Excel

What you’ll learn: 

  • All of the basic functions of Excel in details
  • Some powerful tools to allow you understand how the functions work

Excel is the most commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light.

If you are a complete beginner looking to master Excel, or you just want to brush up on the basics, you’ve come to the right place. If you want to earn more money by developing a skill set that today’s employers demand, this is the course for you. Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities.

Many of my students have gone on to get better paying jobs, or even start their own businesses, using the very skills you will soon master. In this course we cover in detail all of the basic functions of Excel, and you will learn not only how to use it, but some powerful tools to allow you understand how it works. There is a difference between repeating something and understanding it.

Together we concentrate on building a single complete project from beginning to end, using all the basic functions and give you a thorough understanding. I know your time is valuable, so most lectures are between 3-5 minutes, allowing you to dip in and out when it’s convenient for you. This also maximizes your learning, and makes it easy if you ever need to go back to refresh your memory. There are screencasts, lots of quizzes, presentations, pdfs, downloadable files all designed to optimize your learning.

Our Promise to You

By the end of this course, you will have learned the basics of Excel.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked. 

Get started today and learn more about the essentials of Microsoft Excel.

Course Curriculum

Section 1 - Introduction
Introduction 00:00:00
Downloadable Materials – Excel Essentials 1 00:00:00
Section 2 - Start Here: All The Basics
Opening Excel, And Creating A Shortcut 00:00:00
The Anatomy Of A Workbook: Where Everything Is, And What It Does 00:00:00
A Quick Review Of What’s Where 00:00:00
Always Do This First – Save Your New Workbook 00:00:00
Let’s Enter Some Data 00:00:00
Editing Data 00:00:00
Ooops. I Made A Mistake – Undo And Redo 00:00:00
Changing Appearance Of Text With Formatting – Fonts 00:00:00
A Quick Word On Formatting 00:00:00
Formatting – Alignment 00:00:00
Saving Time With AutoFilling Sequences 00:00:00
Power User – Adding Your Own Lists To Autofill 00:00:00
Saving Time With Format Painter 00:00:00
Changing The Column Width 00:00:00
Tidy Large Titles With Merge And Centre 00:00:00
Entering Data – A Couple Of Shortcuts 00:00:00
Section 3 - Doing The Simple Math
Sums – The Old Fashioned Way 00:00:00
Sums – Using Autosum 00:00:00
Copying Formulas 00:00:00
SUMming Horizontally 00:00:00
Basic Formulas – Subtraction 00:00:00
Basic Formulas – Multiplication 00:00:00
Basic Formulas – Division 00:00:00
Average Function 00:00:00
The Order Of Mathematical Operation 00:00:00
Power User – Evaluate Formula Function 00:00:00
Section 4 - Rearranging Things
Inserting New Columns And Rows 00:00:00
Moving Existing Columns And Rows 00:00:00
Cutting, Copying, Inserting And Deleting 00:00:00
Hiding Columns And Rows 00:00:00
Section 5 - Formulas: Learning The Clever Stuff
ROUNDing Functions 00:00:00
Formatting Numbers 00:00:00
A Primer In Building Complex Formulas 00:00:00
Building A Complex Formula 00:00:00
Section 6 - A Few More Essentials
Sorting 00:00:00
Wrapping Text And Soft Enter 00:00:00
Adding A New Worksheet 00:00:00
Creating A Simple Chart 00:00:00
Adding Borders 00:00:00
Customizing The Quick Access Toolbar 00:00:00
Simple Printing 00:00:00
Freezing For An Easier View 00:00:00
Getting Help 00:00:00
Filters 00:00:00
Highlighting Cells 00:00:00
Closing 00:00:00
Section 7 - Bonus Section: The Keyboard Shortcuts
Whizzing Around Excel 00:00:00
The Keyboard Shortcuts 00:00:00
Section 8 - Bonus Section: Absolute And Relative Cell References
Relative Relative Style 00:00:00
Absolute Absolute Style 00:00:00
Absolute Relative Style 00:00:00
Relative Absolute Style 00:00:00
Section 9 - Bonus Section: Student Questions Answered
Reverse Engineering A Sample Spreadsheet 00:00:00
Casing And Text Functions 00:00:00
Level 1 SQA 03 – Charts From A Filtered List 00:00:00

Course Reviews


5 ratings
  1. Cherie Zhang

    Microsoft Excel Essentials: Level One


    Great Teacher and Wonderful Class!!! Have learned a lot, thank you!

  2. Paul Edward Montador
    Paul Edward MontadorApril 26, 2021 at 3:33 am

    Beginner to almost Basics Expert


    Thanks, Alan. This course was so informative.
    It gave me a lot of information I knew nothing about before.

    I highly recommend this course to those that want to understand the basics of working with Excel Spreadsheets.

  3. Ma. Charyvic AbellanosaMarch 7, 2021 at 6:21 am

    Microsoft Excel Essentials: Level One


    The tutorial have a clear explanation. Thank you for this tutorial.

  4. Melody Downey

    Easy to follow


    Thanks Alan for making this easy to follow. I appreciated the step by steps that were given. It was nice to learn some basics that I didn’t know and to brush up on things that I already knew. I look forward to taking the next level with you.

  5. Nicholas MacNeil
    Nicholas MacNeilDecember 6, 2020 at 1:21 pm

    Love it!


    Thank you Alan for providing this course! Excel was always beyond my understanding. You break it down so nicely. Thank you!

Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel