Excel Formula's Accountants & Financial Professionals Need to Know

Excel Formula's Accountants & Financial Professionals Need to Know - Virtual

Create Account

Availability

Registration Required

Online Meeting

Sep 29, 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 Specialized Knowledge

Excel is ubiquitous in the accounting and financial professionals' workplace, but some of the best functions and features for accounting and financial professionals are unknown or underutilized. Leverage Tables, shortcuts, and best practices to increase efficiency. Master the functions such as VLOOKUP, INDEX & MATCH, Dynamic Array Formulas. As well as Formulas and uses such as Depreciation, Amortization, Interest, Payment, and more. In this course, we will even take you deeper into statistical analysis with formulas for everything from median, most, and standard deviation and regression analysis.

Demonstrate the ability to locate data anywhere using Lookup formulas such as VLOOKUP, INDEX & MATCH
Make balance sheet calculations for depreciation & amortization using SLN, DB, DDB & VDB
Determine Interest and payment amounts using PMT, IPMT, NPV, IRR. Additionally how to visualize this data with Excel’s chart functionality
Discover how to do easy statistical analysis using excels, statistical tool pack and related functions.
Leverage Excel’s table functionality to make writing formulas more efficient & Effective

Excel is ubiquitous in the accounting and financial professionals' workplace, but some of the best functions and features for accounting and financial professionals are unknown or underutilized.
Leverage Tables, shortcuts, and best practices to increase efficiency.
Master the functions such as VLOOKUP, INDEX & MATCH, Dynamic Array Formulas.
As well as Formulas and uses such as Depreciation, Amortization, Interest, Payment, and more.
In this course, we will even take you deeper into statistical analysis with formulas for everything from median, most, and standard deviation and regression analysis.

Financial professionals that would like to have better 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.