Consultants' Training Institute Webinar Details |
Accelerate Excel: Dealing with Duplicate Data
Monday, September 18, 2017
12:30 p.m. Mountain time (MT)
Program Description
If you’re frustrated with duplicates showing up frequently in your spreadsheets and don’t know how to identify and manage them, you’ll want to attend this live webcast presented by Excel expert David 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 shares information and tips on how you can:
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 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.
Topics Typically Covered
Learning Objectives
After completing this webinar, attendees will be able to:
Who Should Attend
Practitioners seeking to identify and manage duplicate data in Excel
Presenter(s)
David H. Ringstrom, CPA
Mr. David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).
CPE Credit
Program Level: Intermediate | Prerequisites: Previous training or research on subject matter being taught. | Advanced Preparation: Experience Working with Excel Spreadsheets Is Recommended |
Delivery Method: Group Internet-Based | CPE Credits: Two (2) Hours | Fields of Study: Computer Software & Applications |