ACPEN: K2’s Excel’s Best New Features

Overview

With the latest updates in Microsoft 365 and Office 2024, Excel is more powerful than ever. Packed with cutting-edge features, more innovative functions, and seamless collaboration tools, the newest version is designed to take your productivity to the next level.

Whether you're crunching numbers, building dashboards, or collaborating across teams, these enhancements unlock faster workflows, deeper insights, and more thoughtful decision-making.

Don't miss your chance to stay ahead of the curve-discover Excel's most exciting new features and learn how to put them to work for you.

Your spreadsheet game is about to change-let's make it extraordinary!

Highlights

• 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

Prerequisites

Fundamental knowledge of Excel

Designed For

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

Objectives

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

Preparation

 None