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.
David has more than 30 years of experience as a spreadsheet and accounting software consultant and speaker. He has presented over 2,500 live webinars and is the author or co-author of ten books, including “Microsoft 365 Excel All-in-One for Dummies”, “Microsoft 365 Excel for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and “QuickBooks Online for Dummies”.
In his webinars, David demonstrates every technique twice: first on a PowerPoint slide with numbered steps, and then live in Excel for Microsoft 365 for Windows. He highlights any differences in Excel 2024, 2021, or 2019 during the presentation and in his detailed handouts. Attendees also receive an Excel workbook containing most of the examples he uses, making it easy to follow along and apply the techniques later. David additionally supports Excel for Mac users by answering their follow-up questions via email.
blank
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.
blank
- Understanding data transformations by stepping through Power Query and renaming individual steps.
- Protecting workbooks to prevent users from renaming, hiding, unhiding, or otherwise affecting worksheets.
- Defining audit trails and their role in tracking changes, ensuring accuracy, and accountability.
- Reviewing Inquire menu options available to Excel users that have an Enterprise license.
- Turning on Excel’s hidden auditing tools (if your license supports it).
- Reviewing cell edits when AutoSave is enabled in OneDrive or SharePoint.
- Toggling cell lock status with a custom shortcut.
- Protecting a worksheet to ensure users are limited to changing only specific areas of a worksheet.
premium webinar
live_webinars
Excel
CPA, CPD-IES8, CMA, CIA, CRMA
Online
No advanced preparation or prerequisites are required for this course.
NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890
Online
Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
Online
Online
No advanced preparation or prerequisites are required for this course.
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.
Online
No advanced preparation or prerequisites are required for this course.
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. 19 ILL 000 has been approved for 1.0 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). Please make note of the Course Code on your CPP Recertification Log. For more information about certification or recertification, please visit the APA website at www.americanpayroll.org. |
This program has been approved for 12 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). For more information about certification or recertification, please visit the APA homepage at www.americanpayroll.org.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. 19 ILL 000 has been approved for 1.0 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). Please make note of the Course Code on your CPP Recertification Log. For more information about certification or recertification, please visit the APA website at www.americanpayroll.org. |
This program has been approved for 12 Recertification Credit Hour(s) toward RCH recertification through the American Payroll Association (APA). For more information about certification or recertification, please visit the APA homepage at www.americanpayroll.org.
On Demand/Online
No advanced preparation or prerequisites are required for this course.
Approved for up to 2.4 CTP/CCM recertification credits by the Association for Financial Professionals
On Demand/Online
No advanced preparation or prerequisites are required for this course.
Approved for up to 2.4 FP&A recertification credits by the Association for Financial Professionals
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. XXXXXX has been approved for #### CPE credit hours toward IRS Enrolled Agent (EA) continuing education requirements. In accordance with the standards set forth in Circular 230 section 10.6, CE credits have been granted based on a 50-minute hour. |
Online
Online
Online
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Online
Online
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. XXXXXX has been approved for #### recertification credit hours toward SHRM-CP™ and SHRM-SCP™ recertification through the Society of Human Resource Management® (SHRM®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the Society for Human Resource Management website at www.shrm.org. |
Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CP℠. This program is valid for 2 PDCs for the SHRM-CP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. XXXXXX has been approved for #### recertification credit hours toward SHRM-CP™ and SHRM-SCP™ recertification through the Society of Human Resource Management® (SHRM®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the Society for Human Resource Management website at www.shrm.org. |
Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-SCP℠. This program is valid for 2 PDCs for the SHRM-SCP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
blank
David Ringstrom, President & CPA, Accounting Advisors
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.
Jennifer Robbins, Webinar Manager, Illumeo
Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 500 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.
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.
- Understanding data transformations by stepping through Power Query and renaming individual steps.
- Protecting workbooks to prevent users from renaming, hiding, unhiding, or otherwise affecting worksheets.
- Defining audit trails and their role in tracking changes, ensuring accuracy, and accountability.
- Reviewing Inquire menu options available to Excel users that have an Enterprise license.
- Turning on Excel’s hidden auditing tools (if your license supports it).
- Reviewing cell edits when AutoSave is enabled in OneDrive or SharePoint.
- Toggling cell lock status with a custom shortcut.
- Protecting a worksheet to ensure users are limited to changing only specific areas of a worksheet.