Skip to main content

Excel - New Features That Benefit Excel 2019 & O365 Users

Available Until Wednesday, Mar. 31, 2027

Online

2.00 Credits

Member Price $58.00

Non-Member Price $93.00

Overview

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.


Objectives

  • 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

Highlights

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

Developed by: CPA Crossings, LLC

Designed For

All Excel 2019 users, all Office 365 Excel users, anyone considering the value of upgrading

Prerequisites

Basic Knowledge of Excel

Preparation

None

Notice

You will receive an email from CPA Crossings with instructions to access this product.

Leader(s):

Leader Bios

Bryan Smith, CPA Crossings LLC

Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing. Qualifications and Experience: •Leadership role in IT consulting services for a top 10 and two top 100 firms over the past 25 years. •Nationally recognized speaker on technology issues impacting the CPA profession, with an emphasis on internal controls, disaster recovery planning and information security. •Specialized knowledge in project management systems •Charter member of the Masters of Science in Information Assurance (MISA), Walsh College, Troy, Michigan •Treasurer of the Microsoft Project Users Group - Michigan •Member of the AICPA CITP (Certified Information technology Professional) Credential Committee •Past Chair of the Michigan Association of CPAs Information Technology Committee and Leadership Committee

Return to Top

Non-Member Price $93.00

Member Price $58.00