LF logo
by learnformula
search
Log in
search
Courses/Office Productivity/NASBA - Computer Software & Applications

Exceptional Excel - Auditing Spreadsheets

Excel Workbook Audit: Advanced Techniques for Ensuring Data Accuracy and Reliability

Created byLambers Inc.
4.0
(1 reviews)
BeginnerUpdated Jan 22, 2025
Exceptional Excel - Auditing Spreadsheets

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.
Lambers Inc.
menu_book146 courses
star5,391 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
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

Credit Information

Do these courses count toward my professional development requirements?

This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.

If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.

What Students Are Saying

4.0
Student's Choice
1 reviews

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.