Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

23WA-0283: K2's Excel's Best New Features (Webinar)

If you have questions about this event, please call us at 952-831-2707.

Monday, April 10, 2023
1:00pm - 3:00pm Central Time
2 CPE (2 non-technical)

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!

Major subjects

  • 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

Learning objective(s)

  • 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

Who should take this program?

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

Fees

Our records indicate you are a nonmember. If you register, you will be charged $79.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Standard Member Fee $79.00
checkmark Standard Nonmember Fee $79.00

More program information

Instructor Tommy Stephens, CPA, CITP, CGMA
Location Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level Intermediate
Format Group Internet Based
Sponsor Business Professionals' Network, Inc.
NASBA ID#: 107810
Prerequisites Prereq. None
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business days before the event start date. Learn more

Not a member? Join the MNCPA to start saving on CPE and accessing members-only benefits.

Search CPE catalog

If you have questions about this event, please call us at 952-831-2707.