Excel Formula's Accountants & Financial Professionals Need to Know

Author: Stephen M. Yoss

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.

Publication Date: June 2024

Designed For
Financial professionals that would like to have better knowledge of Excel

Topics Covered

• Tables, Data Models, and Defined Names
• Essential Excel Formulas
• Utilizing Text Formulas in Excel
• Advanced Financial Calculations
• Logical Formulas in Excel
• Lookup Formulas in Data Analysis
• Dynamic Arrays

Learning Objectives

• Recognize how to demonstrate the ability to locate data anywhere using Lookup formulas such as VLOOKUP, INDEX & MATCH
• Identify how to 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
• Identify how to do easy statistical analysis using Excel's, statistical tool pack and related functions
• Recognize how to leverage Excel’s table functionality to make writing formulas more efficient & effective

Level
Basic

Instructional Method
Self-Study

NASBA Field of Study
Specialized Knowledge (2 hours)

Program Prerequisites
None

Advance Preparation
None