Microsoft Excel Essentials: Level One

No Rating(0)
See all reviews

This course is designed for those interested to learn the basics of spreadsheets, the basic and complex formulas, as well as learn in detail all of the basic functions of Excel, not only how to use it, but some powerful tools to allow you to understand how it works.

Watch Free For 30 Days

start free access


buy single class $199
  • On Demand Video Lessons
  • Course Certificate
  • 24/7 Support

About This Coursebeginner

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.

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

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

Course Sections


Downloadable Materials – Excel Essentials 1

Opening Excel, And Creating A Shortcut

The Anatomy Of A Workbook: Where Everything Is, And What It Does

A Quick Review Of What’s Where

Always Do This First – Save Your New Workbook

Let’s Enter Some Data

Editing Data

Ooops. I Made A Mistake – Undo And Redo

Changing Appearance Of Text With Formatting – Fonts

A Quick Word On Formatting

Formatting – Alignment

Saving Time With AutoFilling Sequences

Power User – Adding Your Own Lists To Autofill

Saving Time With Format Painter

Changing The Column Width

Tidy Large Titles With Merge And Centre

Entering Data – A Couple Of Shortcuts

Sums – The Old Fashioned Way

Sums – Using Autosum

Copying Formulas

SUMming Horizontally

Basic Formulas – Subtraction

Basic Formulas – Multiplication

Basic Formulas – Division

Average Function

The Order Of Mathematical Operation

Power User – Evaluate Formula Function

Inserting New Columns And Rows

Moving Existing Columns And Rows

Cutting, Copying, Inserting And Deleting

Hiding Columns And Rows

ROUNDing Functions

Formatting Numbers

A Primer In Building Complex Formulas

Building A Complex Formula


Wrapping Text And Soft Enter

Adding A New Worksheet

Creating A Simple Chart

Adding Borders

Customizing The Quick Access Toolbar

Simple Printing

Freezing For An Easier View

Getting Help


Highlighting Cells


Whizzing Around Excel

The Keyboard Shortcuts

Relative Relative Style

Absolute Absolute Style

Absolute Relative Style

Relative Absolute Style

Reverse Engineering A Sample Spreadsheet

Casing And Text Functions

Level 1 SQA 03 – Charts From A Filtered List


No Reviews found for this course.