Excel 2019 Power & Pro

This course is included in our Advanced Digital Skills for the workplace suite, which is designed to take your teams’ skills to the next level and master all of the features within the core Microsoft apps.

If you would like to have a conversation with us to see how this suite works for your business or to explore bespoke solutions for your specific needs, then send us an email to sales@barefootelearning.com.

You can find pricing information for this suite of courses and individual courses on our pricing page.

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

Course description: 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 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

Course description: Excel 2019 Pro Users

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).