Mastering Advanced Excel Functions

Mastering Advanced Excel Functions - Virtual

Create Account

Availability

Registration Required

Online Meeting

Aug 20, 2026 9:00 AM - 1:00 PM CT

Cost

Member: $260.00

Non-Member: $345.00

Retired: $260.00

Educator & Government & Non-Profit Member: $260.00

Credit Offered

4 CPE Credits

Field of Study:

4 Computer Software & Applications

Excel has more than 400 functions, many of which are unused by most accounting and finance professionals. Some of these little used functions can be used to calculate depreciation, mortgage interest and principal reduction, cash flow analysis over unequal periods, and trap errors. It’s time for you to break out of your Excel cocoon. This two-hour session will put you on the path to improved Excel productivity by introducing you to powerful and time saving but little used Excel functions. Among other topics, you will learn about logical and conditional formulas, including using Boolean operators; advanced financial formulas such as XNPV and XIRR; innovative uses for Excel’s date functions, and SUMPRODUCT, GETPIVOTDATA, and INDIRECT.

Describe the benefits of using GETPIVOTDATA for extracting summarized data from a PivotTable
Use Excel’s financial functions to compute depreciation, calculate mortgage interest and principal reduction, and perform conventional cash flow analysis
List three Excel functions for making conditional calculations that can evaluate multiple conditions
Explain the general process of entering an array formula in Excel

Good working knowledge of Excel

Please note that this course is from a third party vendor, K2 Enterprises. We strongly recommend registering no later than one-hour before the course begins. Please contact K2 if you have questions at least 24 hours before the course begins: webinar@k2e.com. Thank you.