K2's Mastering Advanced Excel Functions 26-27

Overview

Are you ready to move past Excel’s simple functions, such as SUM“ If so, participate in this session to learn about many of Excel’s advanced functions, including XLOOKUP, SUMIFS, and SWITCH. You’ll also learn about the revolutionary Dynamic Arrays feature.

Highlights

• Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays
• How to use "legacy" features and functions such as AGGREGATE
• Creating effective forecasts in Excel

Prerequisites

Fundamental knowledge of Excel 2019 or newer

Objectives

• Apply examples of best practices for constructing formulas in Excel spreadsheets
• Identify situations in which each of the following functions might be useful: SUMIFS, SWITCH, and STOCKHISTORY
• Distinguish between the XLOOKUP function and legacy Excel functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH
• Identify examples of when using Dynamic Arrays would be useful
• Differentiate between Excel's AGGREGATE and SUBTOTAL functions
• Identify conditions in which the FORECAST.ETS function is preferable to the FORECAST function

Preparation

None

Notice

This pre-recorded broadcast is provided through our partnership with K2 Enterprises. Instructor will be available via the chat feature.