Creating Audit Trails in Microsoft Excel
Access this expert-led webinar instantly, available anytime on-demand.
Included in All-Access Membership Live Webinar
On-Demand Webinar Available
Customer Satisfaction Guarantee Learn with confidence. If you're not happy, we'll make it right. That's our guarantee.
Discover how to improve collaboration, maintain data accuracy, and build audit trails in Excel by using key features that support transparency and control. This webinar focuses on practical techniques for enabling and managing Track Changes, restoring workbook sharing, and reviewing collaborative edits effectively. You'll explore Excel Online's Show Changes functionality, apply the FORMULATEXT function for better formula management, and utilize Excel’s Inquire Add-In—available in Enterprise versions—for comprehensive data auditing.
Led by Excel expert David H. Ringstrom, CPA, this session includes step-by-step demonstrations using Excel for Microsoft 365, with notes on variations in Excel 2021, 2019, and 2016. Attendees will receive detailed handouts, including a workbook with example files used in the presentation. Topics such as data transformation with Power Query, protecting worksheets, identifying unlocked cells with Conditional Formatting, and cleaning financial reports will be covered in depth. Whether you're working with collaborative spreadsheets or auditing financial data, this session will equip you with tools to improve accuracy and efficiency.
Topics Covered:- Restoring and utilizing the classic Track Changes feature in Excel
- Monitoring cell-level changes for up to 60 days in Excel Online
- Displaying all formulas at once using the Show Formulas feature
- Toggling cell lock status with custom shortcuts
- Stepping backwards through Power Query transformations
- Defining audit trails and their role in ensuring data accuracy and accountability
- Changing data types for columns in Power Query results
- Using Conditional Formatting to highlight unlocked cells
- Displaying formulas in adjacent cells using the FORMULATEXT function
- Protecting worksheets to restrict editing to specific areas
- Cleaning accounting reports by removing blanks, merges, and missing data
- Restoring missing Workbook Sharing and Track Changes commands in Excel 2021 and Microsoft 365
- Gain clarity and control over collaborative spreadsheet changes
- Strengthen your ability to audit and validate spreadsheet data
- Improve your efficiency when working with complex formulas and data transformations
This webinar will help you enhance your Excel skills with practical tools that simplify collaboration, protect data integrity, and support more confident reporting.
Who Should Attend:
Professionals seeking to use Microsoft Excel more effectively, particularly those responsible for collaborative data environments, auditing, or reporting.
Format: Live webcast
Instructional Method: Group: Internet-based
NASBA Field of Study: Computer Software & Applications (2 hours)
Program Prerequisites: Prior experience with Microsoft Excel is recommended.
Advance Preparation: None
-
David H. Ringstrom, CPA
David H. Ringstrom, CPA, is a nationally recognized instructor who leads dozens of Excel webinars each year. He is the author of Microsoft 365 Excel for Dummies and several other books. With over 30 years of consulting and teaching experience he empowers users to work more efficiently in E [...]
ATAAA Credit
Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in administrative.
Invest in your future with confidence! Our Customer Satisfaction Guarantee eliminates all risk, letting you focus purely on mastering new skills and advancing your career. If you're not completely satisfied, we'll ensure you are. Your satisfaction is not just a promise; it's our guarantee.
This webinar received a total of 2 survey responses. Attendees have given an average rating of 4.7 stars out of a possible 5, reflecting the quality and value of the content presented.
Webinar Presentation
How many of the objectives of the event were met?
5.0 Stars
How useful was the information presented at this event?
4.5 Stars
Overall, how satisfied were you with this event?
5.0 Stars
Speaker Performance
Overall, how satisfied were you with this presenter?
4.5 Stars
How closely did the presenter follow the schedule?
4.5 Stars
Reviews From Webinar Survey
Our webinars are crafted to deliver exceptional value and insight to business professionals. Below, you'll find genuine feedback from attendees.
Kimberly A.
July 21, 2025
4.4 / 5
Webinar Rating:
4.7 Stars
Speaker Rating:
4.0 Stars
Do you have any other comments, questions or concerns?
no comment
Mary E.
July 16, 2025
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
Very informative session.
Frequently Asked Questions
Creating an audit trail in Microsoft Excel involves enabling features that record who changed what, when, and how in a workbook. The classic Track Changes feature—available in Excel 2016, 2019, and 2021—logs cell-level edits and can be reviewed through the history pane. In Excel Online and Microsoft 365, the Show Changes functionality provides more granular monitoring, tracking modifications for up to 60 days. For Enterprise users, Excel's Inquire Add-In offers comprehensive auditing capabilities, including workbook analysis, cell relationship mapping, and formula documentation. Protecting worksheets to restrict editing to designated cells limits who can make changes in the first place. The FORMULATEXT function can be used in adjacent cells to display and monitor formulas, adding a layer of formula transparency. Conditional Formatting can highlight unlocked cells visually, making it immediately clear where edits are permitted. Excel expert David Ringstrom, CPA, covers all these techniques in depth in Aurora Training Advantage's on-demand webinar, providing step-by-step demonstrations for Microsoft 365 and earlier versions.
Track Changes in Excel is a legacy collaboration and audit feature that records edits made to a shared workbook, including the cell location, original value, new value, date, and username of the person who made the change. When enabled, changes are highlighted in the workbook and stored in a change history that reviewers can accept or reject. This makes it invaluable for financial models, budgets, or data files where multiple stakeholders make edits over time. In Excel 2021 and Microsoft 365, Track Changes was removed from the default ribbon as Microsoft shifted collaboration tools toward Excel Online and co-authoring via OneDrive. However, it can be restored by customizing the Quick Access Toolbar or ribbon. Excel expert David Ringstrom, CPA, explains exactly how to restore these missing commands and get maximum value from the feature in Aurora Training Advantage's audit trails webinar. For teams needing a lightweight audit solution without enterprise tools, Track Changes combined with worksheet protection provides a solid foundation.
Excel's Inquire Add-In is a powerful auditing tool available in Microsoft 365 and Office Professional Plus editions that provides deep analysis of workbook structure, formulas, and cell relationships. Once activated through Excel's Add-In settings, it adds a dedicated Inquire tab with tools including Workbook Analysis (summarizing formula counts, errors, and hidden items), Workbook Relationship (mapping links between files), Worksheet Relationship (showing dependencies between sheets), and Cell Relationship (tracing precedents and dependents). For accounting and financial reporting professionals, the Compare Files feature is particularly valuable—it highlights differences between two versions of a workbook, functioning as a built-in version-control audit. The Clean Excess Cell Formatting option helps resolve file bloat issues common in large financial models. David Ringstrom, CPA, demonstrates the Inquire Add-In's practical audit applications in Aurora Training Advantage's on-demand Excel webinar, making it accessible even for intermediate-level users unfamiliar with enterprise auditing tools.
The FORMULATEXT function in Excel returns the formula stored in a referenced cell as a text string, displayed in an adjacent cell. For example, =FORMULATEXT(B5) will display the exact formula used in cell B5—even if that cell shows a numeric result—making the formula visible without requiring the user to click into the cell or enter edit mode. This is especially useful for financial auditors, model reviewers, and controllers who need to document or verify formula logic across a workbook without modifying the source cells. It's also valuable for training purposes: displaying formulas alongside results helps new staff understand how models are constructed. FORMULATEXT returns a #N/A error if the referenced cell contains a value rather than a formula, which itself serves as a useful indicator. In combination with worksheet protection—which can prevent formula cells from being accidentally overwritten—FORMULATEXT creates a self-documenting layer of formula transparency. David Ringstrom covers its practical applications in Aurora Training Advantage's Excel audit trails webinar.
Power Query in Excel provides a transparent, step-by-step record of every transformation applied to source data during the import and shaping process—making it an inherently audit-friendly tool. Each transformation step is logged in the Applied Steps pane on the right side of the Power Query Editor, and steps can be reviewed, modified, or removed individually. This creates a clear chain of custody from raw data to final output, which is critical for financial reporting and compliance workflows. You can step backwards through the transformation sequence to verify exactly how data was cleaned, filtered, joined, or aggregated at each stage. Power Query also allows you to change data types for columns, remove duplicates, unpivot tables, and handle blanks in a repeatable, documented way—unlike manual Excel editing which leaves no record. Excel expert David Ringstrom, CPA, demonstrates how to use Power Query's step history as an audit trail for data transformations in Aurora Training Advantage's on-demand webinar, covering techniques applicable to financial report cleaning and accounting data workflows.