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.
DESIGNED FOR
CPAs in public practice or members in industry seeking a better understanding of analytical procedures.
BENEFITS
- 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
HIGHLIGHTS
- 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 LEVEL
Intermediate
PREREQUISITES
Basic working knowledge of audit and review engagements and working with Microsoft Excel.
ADVANCE PREPARATION
None
ADDITIONAL NOTES
Please contact the ACPEN help desk 1-877-602-9877 or help@acpen.com if you wish to cancel your attendance for a previously purchased webcast and are requesting a refund or transfer. Please contact Anne Taylor for any complaints. anne.taylor@acpen.com, (972-377-8199).