Not Found
Live Webcast Replay

Analytical Procedures: Practical Applications and Standards

Total Credits: 2 including 2 Auditing - Technical

Average Rating:
Accounting and Auditing |  Industry |  ACPEN Industry Institute
Chris Harper
Course Levels:
2 Hours
Access for 90 day(s) after program date.



This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given.


Basic Course Information

Learning Objectives
  • Understand the nature of analytical procedures
  • Design and implement analytical procedures for professional engagements.
  • Understand the AICPA’s guidance for utilizing analytical procedures in audit and review engagements

Major Subjects
  • Using formulas to manipulate and transform data
  • Using formulas and reference formulas such as =VLOOKUP
  • Using pivot tables
  • Understanding Solver to perform multivariate analysis
  • Awareness of advanced functions
  • Creative methods for data manipulation
  • Using intellectual curiosity and professional skepticism to develop a problem-solving mentality
  • Real-life examples of innovative ways to analyze and report data with Excel
  • Using Excel to perform e-mail merges
  • Enhance creativity in your approach to developing Excel models Computer software and application 

Course Materials


Chris Harper's Profile

Chris Harper Related seminars and products

Chris has been serving the tax and accounting needs of individuals and closely-held businesses since 1998. As a frequent speaker, he has taught a variety of continuing education courses for several state CPA societies. Chris is frequently interviewed by media outlets on a variety of financial, tax, and accounting topics.


Fri, Feb 04, 2022 - 10:00am to 11:50am CST
Fri, Feb 18, 2022 - 08:30am to 10:20am CST
Fri, Feb 18, 2022 - 10:00am to 11:50am CST
Fri, Mar 04, 2022 - 10:00am to 11:50am CST
Fri, Mar 18, 2022 - 08:30am to 10:20am CDT
Fri, Mar 18, 2022 - 10:00am to 11:50am CDT
Fri, Apr 01, 2022 - 10:00am to 11:50am CDT
Fri, Apr 15, 2022 - 10:00am to 11:50am CDT
Mon, Apr 18, 2022 - 08:30am to 10:20am CDT
Fri, Apr 29, 2022 - 10:00am to 11:50am CDT

Additional Info

Basic Course Information

Advanced Preparation


Course Developer

Van Der Aa Tax Ed, LLC

Designed For

CPAs in public practice or members in industry seeking a better understanding of analytical procedures.

Yellow Book


Original Recording Date



Basic working knowledge of audit and review engagements and working with Microsoft Excel.

Date Added to Catalog


Additional Information

Complaint Resolution Policy

Please contact Anne Taylor for any complaints., (972-377-8199).

Course Registration Requirements

Online Registration

Instructional Delivery Method

Group Internet Based

Official Registry Statement

Business Professionals' Network, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Refund/Cancellation Policy

Please contact the ACPEN help desk 1-877-602-9877 or if you wish to cancel your attendance for a previously purchased webcast and are requesting a refund or transfer.



Overall:      4.5

Total Reviews: 24


Jerri H - Beulaville, North Carolina


Please wait ...

Back to Top