Get Full Access to Every 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.