Description:

Over the years, Excel has added MANY new features and functionality, yet most people still use it in the same way they first learned. Part of the reason is new features were added when the newest version was announced approximately every 3 years. The list was so extensive, making it difficult to learn what was new. Microsoft attempted to solve this for Office 365 customers by releasing new features more often, making it difficult to pinpoint the latest update.

This class focuses on the specific added elements to Excel 2019 plus new functionality available to Office 365 users. Not only is this a great class to learn about what's new, it provides those who have not upgraded an opportunity to determine the value of upgrading or purchasing an Office 365 license.

Learning Objectives:

After completing this course you will have the ability to...  

• Identify features that allow you to create spreadsheets more efficiently

• Select the features that you can use to build better spreadsheet

• Recognize features and functions to enhance your spreadsheets

Program Content:

The major topics that will be covered in this class include... 

• The new capabilities of Array Formulas
• New formula functions, including XLOOKUP, XMATCH, SEQUENCE and more
• Using the Ideas feature
• Many more new features

Who should attend: All Excel 2019 users, all Office 365 Excel users, anyone considering the value of upgrading

Field of Study: Computer Applications & Software

Program Level: Intermediate

Developed By: CPA Crossings, LLC

Instructor: Bryan L. Smith, CPA.CITP, CISA

Prerequisites: Basic Knowledge of Excel

Advanced Preparation: None

Format: QAS Self-Study