November 29, 2022


Webinar


4 Total CPE Credits

product-artwork-1759450

K2’s Mastering Advanced Excel Functions

  • Instructor

    Thomas Stephens

Learning Objectives

  • 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

Major Topics

  • Excel
  • Retrieve summarized data with the GETPIVOTDATA and CUBEVALUE functions
  • Making sophisticated calculations with array formulas

CPE Credits Available

4
Total CPE
4
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Prerequisites

Fundamental knowledge of Excel 2016 or newer

Advanced Preparation

None

Intended Audience

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

Provider

ACPEN

Register For This Event

  • ASCPA Member

    $ 129 129
    Join
  • ASCPA Non-Member

    $ 159 159
    Your Price

Please login to register.