Practical Excel Effectively Handling Duplicate Data 2018 is a webinar that covers topics such as:
- Creating an in-cell list by way of Excel’s Data Validation feature
- Learning the mouse trick that lets you quickly make a copy of an existing worksheet
- Seeing how to quickly duplicate a group of two or more worksheets
- Identifying duplicates in a list using Conditional Formatting
- Using Conditional Formatting to color-code your data, identify duplicates, and apply icons
- Using the COUNTIF function to determine the number of times an item appears on a list
- Using the SUMIFS function to sum values based on multiple criteria
- Understanding why numeric data may appear in a pivot table more than once and how to correct the problem
- Filtering list entries based on colors that you apply manually or with Conditional Formatting
- Using the Reapply command to refresh a list as you correct duplicates
- Using a wildcard character with SUMIF to summarize data based on a partial match
- Improving the integrity of spreadsheets with Excel’s VLOOKUP function
Practical Excel Effectively Handling Duplicate Data 2018 is intended for:
- CPA’s
- Accountants
- Controllers
- CFO’s
- Income Tax Preparers
- Excel Users
- Financial Consultants
- Enrolled Agents
- Auditors
- IT Professionals
- Bookkeepers
- Human Resource Personnel
- Government Personnel
- Marketers
- Every Practitioner who wish to learn how to create error-free Excel spreadsheets