Excel 2019 Pro

In this course, you’ll learn the most advanced aspects of working with Excel 2019. Explore how to perform all sorts of useful functions, pivot tables, macros, form controls, and much more in this massive deep dive into the world of Excel 2019.
Course info
Level
Advanced
Updated
Aug 7, 2019
Duration
5h 21m
Table of contents
Formatting
Working with Data
Power Query
Text Functions
Logical and Statistical Functions
Expanded Functions
Error Checking
Conditional Formatting
Charts
Pivot Tables
Advanced Options
Finalizing a Workbook
Macros
Form Controls
Description
Course info
Level
Advanced
Updated
Aug 7, 2019
Duration
5h 21m
Description

Learn the most advanced aspects of Excel 2019. In this course, Excel 2019 Pro, you'll take your knowledge to the ultimate level. First, you'll 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'll have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams).

About the author
About the author

Bill Kulterman is an educator, author, and a Microsoft Certified Trainer (MCT). Bill has been a trainer for more than a dozen years, educating students in Excel, Visio and a bevy of additional solutions. In recent years he has focused solely on SharePoint and SharePoint Online through Office 365. When he's not creating courses, he can usually be found riding his bike or relaxing near his Koi pond.

More from the author
Visio 2019 Power Users
Intermediate
2h 46m
Sep 24, 2019
Excel 2019 Power Users
Intermediate
3h 27m
Aug 20, 2019
More courses by Bill Kulterman