Educational Webinar
Excel Efficiency: Auditing Spreadsheets
THIS EVENT IS IN THE PAST
Webinar Highlights
In this illuminating
session, Excel expert David Ringstrom, CPA, shares techniques you can use to
verify the integrity of even the most complicated Excel workbooks. David
demonstrates Excel’s formula auditing and error-checking tools, as well as how
to verify which cells contain formulas versus values. In addition, David
explains how to: find buried worksheets; access password-protected workbooks;
use the Conditional Formatting feature to identify duplicates in a list;
monitor even minor changes to your workbooks; hide, display, and locate cells
that contain comments; and much more.
David
demonstrates every technique at least twice: first, on a PowerPoint slide with
numbered steps, and second, in the subscription-based Microsoft 365 (formerly
Office 365) version of Excel. David draws your attention to any differences in
the older versions of Excel (2021, 2019, 2016, 2013, and earlier) during the
presentation as well as in his detailed handouts. David also provides an Excel
workbook that includes most of the examples he uses during the webcast.
Learning Session
- Free CPE
- Non-sponsored Events mean you never listen to a 3rd party sales pitch – it’s all just great education
- Expert-instructor-led learning with live Q&A
- Based on a great course on Illumeo
Speakers
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 300 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.
Objectives
After attending this event you will be able to:- Recognize if a file has links to other workbooks or not and remove unwanted links.
- Identify how to add, review, and print worksheet comments with ease.
- Apply Excel tools and techniques that allow you to evaluate portions of a formula or entire formulas.
Continuing Education Information
Certified Public Accountant
Continuing Ed Credit: 1 CPE CreditsField of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online
Chartered Accountant (IES7 CPD)
Continuing Ed Credit: 1 HoursField of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online
Certified Management Accountant
Continuing Ed Credit: 1 CPE CreditsField of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Certified Internal Auditor
Continuing Ed Credit: 1 CPE CreditsField of Study: Computer science
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Certification in Risk Management Assurance
Continuing Ed Credit: 1 CPE CreditsField of Study:
Other activities contributing to professional competence
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
