Identifying duplicate data and managing it within spreadsheets has always been a challenge for most of us, especially in spreadsheets that are comparatively complicated in nature. The speaker brings here this presentation to educate on how to identify such duplicate data and manage it within the spreadsheets, which will undoubtedly prove beneficial to a huge extent.
In this online CPE Excel course, David Ringstrom has covered a variety of subjects, including the identification of 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 copies.
Excel expert David will demonstrate each technique at least twice in this online continuing education course, firstly vide a step-wise Powerpoint presentation and secondly in a subscription-based MS Office 365 version of Excel, and also he will draw your attention to differences in the older versions of Excel (i.e. 2019, 2016, 2013, etc)in his online CPE presentation and detailed handouts. He also provides an Excel workbook that includes most examples he uses during the webcast.
David brings to your attention the subscription-based product 'Office 365' which provides new feature updates as often as monthly as against the perpetual licensed versions of Excel such as Excel 2019, Excel 2016, and so on, which do not update and include the latest features.
This online Excel webinar is recommended for CPAs, CMAs, CIAs, CFEs, and Other Finance & Tax professionals desiring to upgrade their skills in excel.