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).
Author Name: Bill Kulterman
Author Description:
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.

Table of Contents

• Formatting
  10mins
• Working with Data
  27mins
• Power Query
  15mins
• Text Functions
  8mins
• Logical and Statistical Functions
  33mins
• Expanded Functions
  40mins
• Error Checking
  16mins
• Conditional Formatting
  20mins
• Charts
  44mins
• Pivot Tables
  50mins
• Advanced Options
  9mins
• Finalizing a Workbook
  21mins
• Macros
  15mins
• Form Controls
  6mins