If you have any questions or comments please give us a call at 1.800.348.1831 or submit a form here and we will get back to you as soon as possible. Please visit our Educational Services page for more webinars.
|Event Name:||Excel Explained: Dealing with Duplicate Data|
|Date:||Thursday, February 16, 2017 1:30pm CST|
|Panelist(s) Info:||David Ringstrom (Bio)
David Ringstrom, CPA owns Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David has written freelance articles about spreadsheets since 1996, some of which have been published internationally. He teaches scores of webinars on Excel each year, along with speaking at conferences. David coined the phrase "Either you work Excel, or it works you!" Accordingly his sessions are designed to help you turn the tide and become a much more effective spreadsheet user.
|Credits:||2.5 CE Credits|
Are you frustrated with duplicates frequently showing up in your spreadsheets and don’t know how to identify and manage them? If so, you’ll want to attend this live webcast presented by Excel expert David H. Ringstrom, CPA. He 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.
In addition, David shows you how to:
David typically demonstrates techniques from the version of Excel used by the majority of attendees. This means he uses Excel 2010, 2013, or 2016 to demonstrate techniques, but his detailed handouts identify differences in Excel 2007, 2010, 2013, and 2016 when needed. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain.
David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast.
What you will learn:
Who should attend?
Practitioners seeking to identify and manage duplicate data in Excel.