Practical Excel – Effectively Handling Duplicate Data
November 16, 2018 - Online Event ON CAWebinar Compliance
info@webinarcompliance.com
Phone:1-416-915-4458
If you’re tired of dealing with duplicates in your Excel spreadsheets and you don’t know how to identify or manage them, you won’t want to miss this webcast presented by Excel expert David Ringstrom, CPA. He covers a variety of topics, such as identifying duplicate data visually by way of the Conditional Formatting feature, using a pivot table to determine how many duplicates are in a list, applying such worksheet functions as SUMIF or COUNTIF to sum or count instances of duplicates, and more. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to 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.