Accounting and Auditing with Excel (7101014A)

Software tools enable us to be more productive and efficient. Learn how to leverage the powerful features of Excel for accounting and auditing. Explore the use of Excel as an audit and analysis tool, as well as selected features that help prepare accurate reports and workpapers. Review SAS 56 requirements and how to satisfy them with Excel, as well as certain FASB pronouncements that Excel can automate. Explore how certain fraud analysis may be accomplished with Excel, including the implementation of Benford's law. The course will demonstrate many of the features in Excel 2007 for Windows, and all spreadsheets will be available for download prior to the class.

• Explore Excel features relevant to auditing and fraud examination.
• Examine Excel tools that facilitate accurate financial reports.
• More fully leverage Excel to add efficiency to engagements.

• Reports: Quickbooks exports, electronic reporting, IF function for error checking, SUBTOTAL function for balance sheets
• Workpapers: trace dependents, show formulas, conditional format, search for plug numbers, data validation
• Auditing: SAS 56, sampling techniques, analysis tool pack
• Analysis: Pivot tables, auto filter, advanced filtering, duplicate records, VLOOKUP
• Fraud: Benford's law

CPAs who focus on accounting and auditing.

None

None

To ensure that all credit is properly recorded, please review your personal profile and update your CPA, CFP, CTEC and/or Bar license number(s).