Course ID: MAEF

Mastering Advanced Excel Functions

About & Customize

Popular Options

  • In-Person
  • Live Webcast

• List 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

• Cite 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

• Powerful new functions and features in Excel, such as XLOOKUP, Dynamic Arrays, PIVOTBY, and GROUPBY

• How to use “legacy” features and functions such as AGGREGATE

• Creating effective forecasts in Excel

Designed For

Business professionals who work with Excel and want to extend their knowledge of advanced features and functions to become more accurate, effective, and efficient with spreadsheets.

Field of Study
Computer Software & Applications
Prerequisites

Fundamental knowledge of Microsoft Office Excel

CPE Credits
4
Level
Intermediate
Available Formats
In-Person, Live Webcast

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org