K2's Excel's Best New Features - Updated for Excel 2021! (2 hours) On Demand

$79.00

Description

With recent Excel updates provided through Microsoft 365/Office 365 subscriptions and Office 2021, 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 Topics

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

Learning Objectives

Upon completing this course, you should be able to:

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

Course Information

CPE credit: 2 hours Computer Software and Applications
Prerequisites: Fundamental knowledge of Microsoft Office Excel
Program level: Intermediate
Advance preparation: None
Who should participate: Accounting and business professionals seeking to use Excel’s newest features

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.