April 7, 2023

Webinar

2 Total CPE Credits

product-artwork-1764479

K2's Excel's Best New Features

  • Instructor

    Thomas Stephens

With recent Excel updates provided through Microsoft 365/Office 365 subscriptions, Microsoft continues to pack new features into the popular spreadsheet tool. Enhancements to data analysis tools, new functions, and improved collaboration opportunities are available in more recent Excel versions. For those who know about these new features and apply them, exciting opportunities for improved productivity await. Take advantage of this opportunity to learn how you can put Excel’s best new features to work right away!


 

Learning Objectives

  • Apply primary new functions available in Excel, including STOCKHISTORY, SORT, and FILTER
  • Employ Excel’s co-authoring feature to collaborate in real-time with other users
  • List at least three new functions that capitalize on Excel’s Dynamic Arrays feature
  • Utilize Excel’s XLOOKUP and XMATCH functions to locate data in spreadsheets

Major Topics

  • New functions available in Excel 2016 and newer, including subscription-based Excel versions
  • How to collaborate more effectively in newer versions of Excel
  • The importance of Dynamic Arrays and related functions
  • The continued evolution of Power Query

CPE Credits Available

2
Total CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Prerequisites

None

Advanced Preparation

None

Intended Audience

Excel users who desire to learn about and take advantage of recently-added features to Excel

Provider

ACPEN

Register For This Event

  • ASCPA Member

    $ 79 79
    Join

  • ASCPA Non-Member

    $ 109 109
    Your Price

Please login to register.