Practical Excel Topics for Today’s Accountant

Instructor

Dr. Chris
Harper

This course introduces practical ways that public accountants can use Excel to enhance both the efficiency and effectiveness of client engagements. We will reinforce core concepts by illustrating ways that Excel is a tool for analysis and reporting. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when obtaining, analyzing, and reporting information.

Learning Objectives

Apply a variety of advanced formulas to analyze and manipulate data
Identify solutions to data analysis problems
Identify how Excel can be used as a tool to address data analysis problems encountered in client engagements
Explore ways to enhance engagement efficiency using Excel

Major Topics

Data validation
Underutilized, but powerful, formulas
Formulas for manipulating, transforming, and cleansing data
Formulas for data analysis
Reference formulas such as =VLOOKUP
Pivot tables
Solver as a tool for performing multivariate analysis
Mail merge
Custom formatting

CPE Credits Available

2 CPE

2: Computer Software & Applications

Things to Know About This Course

Course Level

Intermediate

Professional Area of Focus

Computer Software & Applications

Advanced Preparation

None

Intended Audience

Public accounting professionals seeking a deeper, more practical understanding of Microsoft Excel

Provider

ACPEN

Register For This Event

ASCPA Member

$ 79 79
Join
Price includes $0.00 early registration discount(s) - expires 12/21

Price includes $0.00 early registration discount(s) - expires 12/21
ASCPA Non-Member

$ 109 109

Price includes $0.00 early registration discount(s) - expires 12/21

Price includes $0.00 early registration discount(s) - expires 12/21

Your Price

Please login to register.