Live Educational Webinar
Excel Efficiency: Managing Duplicate Data in Spreadsheets
Price: FREE
Mar. 21, 2019 Thursday
11:00 AM - 12:00 PM (Pacific)
1 Hour
shutterstock_1027851961.jpg

Free Live Webinar

  • Free CPE
  • Non-sponsored webinars 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
David Ringstrom President and CPA, Accounting Advisors Inc
Excel expert David Ringstrom, CPA, teaches you how to identify and manage duplicate data within your spreadsheets in this beneficial presentation. David covers a variety of topics, including identifying duplicate data visually by way of the Conditional Formatting feature, using a pivot table to determine how many duplicates are in a list, and applying worksheet functions like SUMIF or COUNTIF to sum or count instances of duplicates.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (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.

Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

REGISTER

Learning Objectives

After attending this event you will be able to:
Define how to apply the Advanced Filter feature and the Remove Duplicates feature.
Identify how to use a pivot table to quickly ascertain how many times duplicates appear within a list.
Recall how to eliminate duplicates from a list with just a few mouse clicks.

Speakers

David RingstromPresident and CPA, Accounting Advisors Inc
David Ringstrom
President and CPA, Accounting Advisors Inc
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.
Moderated by Jennifer RobbinsIllumeo Webinar Manager
Moderated by Jennifer Robbins
Illumeo Webinar Manager
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.

Continuing Education Information

Certified Public Accountant

Continuing Ed Credit: 1 CPE Credits
Field of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online

International Continuing Professional Development IES 7

Continuing Ed Credit: 1 Hours
Field of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online

Certified Management Accountant

Continuing Ed Credit: 1 CPE Credits
Field 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 Credits
Field 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 Credits
Field 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.

Register for this Event

Price: FREE
By submitting this form, you agree to the terms of Illumeo’s User Agreement and to receive email marketing from Illumeo. Consent can be withdrawn at any time.