March 4, 2024


2 Total CPE Credits


Webinar (CA): K2's Excel's Best New Features

  • Instructor

    Thomas Stephens, Jr

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

• Learn how to work with Dynamic Arrays
• Using Excel's new XLOOKUP and XMATCH feature
• Improvements to Power Query and why they matter to you
• New collaboration and commenting options in Excel

CPE Credits Available

Total CPE
Computer Software & Applications

Things to Know About This Course

Course Level

  • Update


Fundamental knowledge of Microsoft Office Excel

Advanced Preparation

This webinar is produced by CalCPA. You will receive your login link/instructions and Certificate of Attendance directly from this third-party vendor. It is important that you review your COCPA confirmation for details on receiving your login instructions and COA from said vendor.

Intended Audience

Accounting and financial professionals seeking to use Excel’s newest features


California CPA Education Foundation

Register For This Event

  • COCPA Member

    $ 89 89
  • COCPA Non-Member

    $ 119 119
    Your Price

Please login to register.