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.
Learning 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
Major Topics
• 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