January 29, 2024


Webinar


4 CPE

Webinar (CA): K2's Mastering Advanced Excel Functions

January 29, 2024
Webinar
4 CPE

Webinar (CA): K2's Mastering Advanced Excel Functions

  • Instructor

    Tommy
    Stephens, Jr

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

• 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

CPE Credits Available

4 CPE
4
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Prerequisites

Fundamental knowledge of Excel 2019 or newer

Advanced Preparation

This webinar is produced by CalCPA. You will receive your login link/instructions and Certificate of Attendance directly from this third-party vendor. It is important that you review your COCPA confirmation for details on receiving your login instructions and COA from said vendor.

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

California CPA Education Foundation

This event has ended.