Name: Exceptional Excel - Auditing Spreadsheets
Price: 129 CAD
Rating: 4 (1 reviews)

What You'll Learn

check_circleRecognize if a file has links to other workbooks or not and remove unwanted links.

check_circleIdentify how to add, review, and print worksheet comments with ease.

check_circleApply Excel tools and techniques that allow you to evaluate portions of a formula or entire formulas.

check_circleAudit Pivot Table data sources and ensure correct calculation settings to maintain spreadsheet integrity.

About This Course

Welcome to Exceptional Excel - Auditing Spreadsheets!

In today's complex data environment, ensuring the accuracy and integrity of your spreadsheets is paramount, whether you're verifying your own work or deconstructing files built by others. This course equips you with Excel's powerful built-in tools to meticulously audit and understand spreadsheet logic.

Through practical examples, you will learn to:

Quickly identify formulas and constants in your worksheets.
Trace the relationships between cells using Trace Dependents and Trace Precedents.
Deconstruct and evaluate complex formulas step-by-step to pinpoint errors.
Effectively use the F9 key within the formula bar for quick evaluation.
Improve formula clarity and auditing using Range Names.
Monitor key cells across multiple sheets or workbooks with the Watch Window.
Leverage Excel's Error Checking features and address common warnings like green tick marks.
Locate and resolve problematic Circular References.
Verify that your Pivot Tables are referencing the correct data source.
Utilize Conditional Formatting to highlight Duplicate Values.
Understand how to approach challenges with Password Protection, Hidden Sheets, and External Links.
Ensure your workbook is calculating correctly by managing Calculation Options.
Use Cell Comments and the N function for documentation and audit trails.

By mastering these techniques, you will gain confidence in the reliability of your spreadsheets and build a solid foundation for data integrity.

Your Instructors

Lambers Inc.

menu_book146 courses

star5,388 reviews

Lambers, Inc. is a leader in review courses for the EA, AFSP, and CPA exams. Lambers also offers IRS Continuing Education for Tax Preparers and CPE for CPAs. Accounting and finance professionals around the world incorporate Lambers products into their training programs.

David H. Ringstrom

CPA

David H. Ringstrom, CPA, is President of Accounting Advisors, Inc., a spreadsheet and database consulting firm. He is a Certified Public Accountant, a technical editor for the For Dummies book series, and the author or co-author of five books, including previous editions of QuickBooks

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

Exceptional Excel - Auditing Spreadsheets

What You'll Learn

About This Course

Your Instructors

Credit Information

What Students Are Saying

Frequently Asked Questions