In this presentation, author and Excel expert David H. Ringstrom, CPA, will delve into the essential features of Excel that enhance collaboration and data integrity, focusing on the concept of an Audit Trail. Attendees will learn how to enable Track Changes to monitor spreadsheet edits, restore workbook sharing, and effectively review changes made by collaborators. David will also explore the Show Changes feature in Excel Online, demonstrate the use of the FORMULATEXT function for better formula management, and introduce the Inquire Add-In available in Enterprise versions of Excel to streamline data analysis and auditing processes. Join us to gain practical insights that will elevate your Excel skills and improve your workflow.
Topics typically covered:
• Changing the data type for columns of data within the results grid.
• Monitor changes in individual cells for up to the last 60 days when viewing a workbook in Excel Online.
• Most features and functions work in Excel for Mac as well but expect differences.
• Displaying all formulas in a worksheet at once with the Show Formulas feature.
• Restoring and utilizing the classic Track Changes feature in Excel.
• Protecting a worksheet to ensure users are limited to changing only specific areas of a worksheet.
Learning objectives:
• State which versions of Excel offer the Inquire add-in.
• Recognize Excel’s legacy feature that supports accepting or rejecting changes in collaborative editing.
• State the purpose of the Protect Sheet command.
This course must be completed within one year of enrollment/purchase.
Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/