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 30 day(s) after program date.

Please Note: Programs with a ☾ insignia begin after 5pm or air on the weekend.


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.


Thu, Aug 12, 2021 - 08:00am to 09:50am PDT
Fri, Aug 27, 2021 - 10:00am to 11:50am PDT
Fri, Sep 10, 2021 - 12:00pm to 01:50pm PDT
Thu, Sep 23, 2021 - 02:00pm to 03:50pm PDT
Fri, Oct 08, 2021 - 08:00am to 09:50am PDT
Thu, Oct 21, 2021 - 10:00am to 11:50am PDT
Tue, Nov 09, 2021 - 12:00pm to 01:50pm PST
Sat, Nov 20, 2021 - 02:00pm to 03:50pm PST
Thu, Dec 09, 2021 - 08:00am to 09:50am PST
Tue, Dec 21, 2021 - 10:00am to 11:50am PST

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: 11

Please wait ...

Back to Top