Skip to main content

Microsoft Excel 2019 Training

Beginner5 Hours 30 Minutes58 Course Videos54 Test Questions

$99.00

Learn Microsoft Excel 2019 from the basics to PivotTables, macros and VBA. Three levels of training in 5 hours 30 minutes across 58 videos, for beginners and office staff.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Microsoft Excel 2019 Training takes you from your first spreadsheet to advanced tools such as PivotTables, macros and VBA. It is made for beginners, office staff and anyone who works with numbers or lists and wants to do it faster and with fewer mistakes. The course runs for 5 hours 30 minutes across 58 videos, with 54 practice questions.

What you will learn

  • Find your way round the ribbon, then enter, format, save and print data
  • Write formulas with absolute references and named ranges, and fix formula errors
  • Use functions such as SUM, COUNT and AVERAGE, plus conditional, logical, date and time functions
  • Build and customise charts and sparklines
  • Work across several worksheets and link workbooks together
  • Turn data into Excel tables, filter it, group it and check it with data validation
  • Look up values with VLOOKUP and HLOOKUP and build drop-down lists
  • Highlight results with conditional formatting rules
  • Summarise data with PivotTables and PivotCharts, and test ideas with scenarios and Goal Seek
  • Automate tasks with macros and an introduction to VBA

Course outline

  1. Beginner: the ribbon, saving, entering and formatting data, printing, formulas, named ranges, functions and charts.
  2. Intermediate: multiple worksheets, linking workbooks, freezing cells, filters, grouping, sparklines, Excel tables, structured references, data validation and comments.
  3. Advanced: conditional and nested formulas, lookups, drop-down lists, text to columns, data protection, conditional formatting, PivotTables, PivotCharts, scenarios, Goal Seek, macros and VBA.

Who this course is for

  • Complete beginners who want a clear start in Excel
  • Office and admin staff who handle data each day
  • Students who need spreadsheet skills for study or work
  • Business analysts, accountants and project managers who want faster reporting

Before you start

You only need basic computer skills. The course starts at the very beginning, so you can join with no Excel experience. If you already know the basics, you can skip ahead to the intermediate or advanced module. Having Excel open while you watch will help you practise each step.

Jobs this course supports

  • Administrative Assistant
  • Operations Associate
  • Data Analyst
  • Financial Analyst
  • Accountant
  • Project Coordinator

Skill level

Beginner
Duration

5 Hours 30 Minutes
Videos

58 Course Videos
Questions

54 Test Questions
Prerequisites

Basic computer skills. No Excel experience needed.
Best for

Office and admin staff, students, business and data analysts, accountants, project managers
Topics covered

Formulas and functions, charts, Excel tables, data validation, VLOOKUP and HLOOKUP, conditional formatting, PivotTables, macros and VBA
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

3 modules and 58 lessons. Here is the full outline.

Module 1: Beginner13 lessons
  1. 1.0 Intro
  2. 1.1 The Ribbon
  3. 1.2 Saving Files
  4. 1.3 Entering and Formatting Data
  5. 1.4 Printing from Excel & Using Page Layout View
  6. 1.5 Formulas Explained
  7. 1.6 Working with Formulas and Absolute References
  8. 1.7 Specifying and Using Named Range
  9. 1.8 Correct a Formula Error
  10. 1.9 What is a Function
  11. 1.10 Insert Function & Formula Builder
  12. 1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE
  13. 1.12 Create and Customize Charts
Module 2: Intermediate18 lessons
  1. 2.0 Recap
  2. 2.1 Navigating and editing in two or more worksheets
  3. 2.2 View options - Split screen, view multiple windows
  4. 2.3 Moving or copying worksheets to another workbook
  5. 2.4 Create a link between two worksheets and workbooks
  6. 2.5 Creating summary worksheets
  7. 2.6 Freezing Cells
  8. 2.7 Add a hyperlink to another document
  9. 2.8 Filters
  10. 2.9 Grouping and ungrouping data
  11. 2.10 Creating and customizing all different kinds of charts
  12. 2.11 Adding graphics and using page layout to create visually appealing pages
  13. 2.12 Using Sparkline formatting
  14. 2.13 Converting tabular data to an Excel table
  15. 2.14 Using Structured References
  16. 2.15 Applying Data Validation to cells
  17. 2.16 Comments - Add, review, edit
  18. 2.17 Locating errors
Module 3: Advanced27 lessons
  1. 3.1 Recap
  2. 3.2 Conditional (IF) functions
  3. 3.3 Nested condition formulas
  4. 3.4 Date and Time functions
  5. 3.5 Logical functions
  6. 3.6 Informational functions
  7. 3.7 VLOOKUP & HLOOKUP
  8. 3.8 Custom drop down lists
  9. 3.9 Create outline of data
  10. 3.10 Convert text to columns
  11. 3.11 Protecting the integrity of the data
  12. 3.12 What is it, how we use it and how to create a new rule
  13. 3.13 Clear conditional formatting & Themes
  14. 3.14 What is a Pivot Table and why do we want one
  15. 3.15 Create and modify data in a Pivot Table
  16. 3.16 Formatting and deleting a Pivot Table
  17. 3.17 Create and modify Pivot Charts
  18. 3.18 Customize Pivot Charts
  19. 3.19 Pivot Charts and Data Analysis
  20. 3.20 What is it and what do we use it for
  21. 3.21 Scenarios
  22. 3.22 Goal Seek
  23. 3.23 Running preinstalled Macros
  24. 3.24 Recording and assigning a new Macro
  25. 3.25 Save a Workbook to be Macro enabled
  26. 3.26 Create a simple Macro with Visual Basics for Applications (VBA)
  27. 3.27 Outro

Your learning path

Where Microsoft Excel 2019 Training fits. Build your skills one step at a time.

You are hereMicrosoft Excel 2019 Training
Next stepMicrosoft Word 2019 TrainingNext stepIntroduction to Microsoft Power BINext stepMicrosoft Office 365 Online Versions

Frequently asked questions

Is this Excel course suitable for complete beginners?

Yes. The first module starts with the ribbon, saving files and entering data before moving on to formulas and charts.

Does the course cover PivotTables?

Yes. The advanced module covers PivotTables and PivotCharts, along with scenarios and Goal Seek for data analysis.

Will I learn VLOOKUP?

Yes. VLOOKUP and HLOOKUP are taught in the advanced module, along with drop-down lists and nested formulas.

Does it teach macros and VBA?

Yes. The course ends with recording macros and an introduction to Visual Basic for Applications (VBA) to automate repeat tasks.

Can I skip the basics if I already use Excel?

Yes. The course is split into beginner, intermediate and advanced modules, so you can start at the level that suits you.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$99.00
Buy course