Microsoft Excel 2019

This course is broken into three expertise levels covering Essentials, Power users and Pro. You can take which level and section best suits your needs.

Three months for only £29, $39 USD
or £79, $109 USD annually

Buy the course

See the bundle

Microsoft Excel 2019 Essentials

In this course, Excel 2019/365 Power Users, you will take your Excel knowledge to the next level.

First, you will learn how to format cells with borders, styles, shapes and more. Next, you’ll learn how to work with workbooks, worksheets and data. Then you’ll learn more about printing workbooks (in whole or parts). Finally you’ll learn about tables and a few advanced functions.

When you’re finished with this course, you will have the skills to format and manage more advanced spreadsheets (and continue preparation for the Microsoft Office exams).

Course Content

This course has 57 lessons spanning 2 hours and 35 minutes

  1. Getting to Know Excel 2019: 13 lessons
  2. Backstage View: 15 lessons
  3. Working with Worksheets and Data: 11 lessons
  4. Working with Rows and Column: 4 lessons
  5. Formatting: 6 lessons
  6. Totalling Values: 4 lessons
  7. Saving a File: 4 lessons

Microsoft Excel 2019 Power Users

In this course, Excel 2019/365 Power Users, you will take your Excel knowledge to the next level.

First, you will learn how to format cells with borders, styles, shapes and more. Next, you’ll learn how to work with workbooks, worksheets and data. Then you’ll learn more about printing workbooks (in whole or parts). Finally you’ll learn about tables and a few advanced functions.

When you’re finished with this course, you will have the skills to format and manage more advanced spreadsheets (and continue preparation for the Microsoft Office exams).

Course Content

This course has 62 lessons spanning 4 hour and 5 minutes

  1. Formatting Data: 21 lessons
  2. Working with Workbooks, Worksheets, and Data: 14 lessons
  3. Printing a Workbook: 9 lessons
  4. Working with Tables: 14 lessons
  5. Working with Advanced Functions: 4 lessons

Microsoft Excel 2019 Pro

In this course, Excel 2019 Pro, you will take your Excel knowledge to the ultimate level.

First, you will learn how to format and work with data . Then you’ll learn about queries, text/logical/statistical and other functions. Finally you’ll learn conditional formatting, charts, pivot tables, macros and form controls.

When you’re finished with this course, you will have the skills needed to feel fully complete in creating professional spreadsheets (and complete preparation for the Office exams).

Course Content

This course has 81 lessons spanning 2 hours

  1. Formatting: 3 lessons
  2. Working with Data: 7 lessons
  3. Power Query: 2 lessons
  4. Text functions: 3 lessons
  5. Logical and Statistical Function: 9 lessons
  6. Expanded Functions: 7 lessons
  7. Error checking: 5 lessons
  8. Conditional Formatting: 4 lessons
  9. Charts: 13 lessons
  10. Pivot Tables: 13 lessons
  11. Advanced Options: 2 lessons
  12. Finalizing a Workbook: 7 lessons
  13. Macros and Form Controls: 6 lessons