Practical Excel – Effectively Handling Duplicate Data 2018

Topics

• 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

Who should Attend

• 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