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