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
Your Benefits for Attending:
- 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.
Credits and Other information:
- Recommended CPE credit – 2.0
- Recommended field of study – Taxes
- Session Prerequisites and preparation: None
- Session learning level: Basic
- Location: Virtual/Online
- Delivery method: Group Internet Based
- NASBA Sponsor: 146439
- IRS Course ID: PJGWS
- Attendance Requirement: Yes
- Session Duration: 2 Hours
- Case Studies and Live Q&A session with speaker
- PowerPoint presentation for reference
Who Will Benefit:
- CPA
- Enrolled Agents (EAs)
- Tax Professionals
- Attorneys
- Other Tax Preparers
- Finance professionals
- Financial planners
Coder Archives is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
Speaker Profile:
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 Excel.
We are approved to provide CPE/CE credits to Tax Professionals
We reports the educational credits to the respective licensing/regulatory bodies in 5 business days.
The credentials to log into your account is your EMAIL ADDRESS & PASSWORD used during account creation.
- If you’ve forgotten your password, please go to the login page and click on the ‘Forgot Password.’ Then enter your registered email id to receive the password reset email. Click on the link given in the email to enter your new password.
- If the face any challenge, please reach out to us via email support@pro2learn.com or contact our support team through live chat support. Our support line is 1-937-865-8027.Our support team is available Monday to Friday from 09:00 AM – 06:00 PM EST/EDT
When you register for any of our webinars/product, you receive will the instruction 24 hours prior to the conference. Also, the instructions are avilable in your account under ‘My Webinars’ section.
You can cancel your registration to by email at support@pro2learn.com. If you cancel your registration for the paid webinar, the amount shall be credited back in your payment method within 7 business days.
The conference materials are available 4 hours prior to the webinar. You can download it from the webinar page or by logging to your account.
Our seamlessly integrated with ZOOM, WebX and, Goto for delivering continuing education webinars. The system requirements are :
- An internet connection – broadband wired or wireless
- Speakers and a microphone – built-in, USB plug-in, or wireless Bluetooth
Our package courses are the bundles of various continuing education courses which have been specially designed to meet your continuing education requirements for a particular Qualification.
- The web download is the recording of the webinar. You will receive a link to download and save the webinar on your computer and watch it anytime and multiple times.
- The transcript is the detailed written material presented during the webinar.
On demand session is when we conduct the webinar as per your available dates after the live training. You will get access to the training for 24 hours.
To access a course that you have already purchased, all you must have to create/log in to your account. Click on the "Log In" button in the top right of the screen. Once you are logged in, you will have immediate access to all your purchased CPE courses, packages and other self-service or you can write on support@pro2learn.com.
We will email your certificate within 3 working days of the end of the webinar, or you can login your account at www.pro2learn.com. If you don’t receive the email within 3 working days of the end of the webinar, check your spam/junk folder. If it’s not there, we recommend that you send us an email at support@pro2learn.com or connect over the online chatroom.