WEBINAR

Excel Explained: Dealing With Duplicate Data Webinar

CFT Credits: 0.25

Are you frustrated with duplicates frequently showing up in your spreadsheets and don’t know how to identify and manage them? If so, you’ll want to attend this live webcast presented by Excel expert David H. Ringstrom, CPA.

Webinar Description and Audience

Are you frustrated with duplicates frequently showing up in your spreadsheets and don’t know how to identify and manage them? If so, you’ll want to attend this live webcast presented by Excel expert David H. 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 shows you how to:

•Use the MATCH worksheet function to help identify differences in two different lists.
•Use the COUNTIF function to determine the number of times an item appears on a list.
•Create a data validation rule that ensures users can’t enter the same data more than once in a given area of a spreadsheet.
•Eliminate duplicates from a list with just a few mouse clicks.
•Use Conditional Formatting to color-code your data, identify duplicates, and apply icons—and much more.
David typically demonstrates techniques from the version of Excel used by the majority of attendees. This means he uses Excel 2010, 2013, or 2016 to demonstrate techniques, but his detailed handouts identify differences in Excel 2007, 2010, 2013, and 2016 when needed. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain.

David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast.

What You Will Learn:
•Apply the Advanced Filter feature and the Remove Duplicates feature.
•Define how to visually identify duplicate records with the Conditional Formatting feature.
•Identify how to use a pivot table to quickly ascertain how many times duplicates appear within a list.
•Create a data validation rule that prevents users from entering the same data more than once in a list.
•Eliminate duplicates from a list with just a few mouse clicks.
•Filter list entries based on colors that you apply manually or with Conditional Formatting.
•Identify duplicates in a list using Conditional Formatting.
•Improve the integrity of spreadsheets with Excel’s VLOOKUP function.
•Learn how VLOOKUP stops looking after it finds an initial match within a list.
•See how to instantly determine the number of duplicates in a list with a pivot table.
•Learn the mouse trick that lets you quickly make a copy of an existing worksheet.
•Understand why numeric data may appear in a pivot table more than once, and how to correct the problem.
•Use a wildcard character with SUMIF to summarize data based on a partial match.
•Use Conditional Formatting to color-code your data, identify duplicates, and apply icons.
•Use Excel’s COUNTIF function with Conditional Formatting to highlight the second and beyond instances of entries on a list.
•Use the COUNTIF function to determine the number of times an item appears on a list.
•Use the MATCH worksheet function to identify differences between two different lists.
•Use the Reapply command to refresh a list as you correct duplicate instances.
•Use the SUMIF function to summarize data based on a single criterion.

Who Should Attend?

Practitioners seeking to identify and manage duplicate data in Excel.

Webinar Viewing Options

LIVE WEBINAR:                                              

INCLUDES 7 DAYS OF UNLIMITED ONDEMAND PLAYBACK!  With this option, you will participate in the webinar (via the internet) as it is being presented. You will login to the webinar on your PC to view the PowerPoint presentation, and you have the option of using your PC speakers or a telephone for the audio. You can type and send your questions to the instructor. Many companies are now running their PC through an LCD projector allowing many employees to participate at the same time.  And don’t worry if you miss the webinar, you can still view it for up to seven days after it takes place!

SIX MONTH ONDEMAND VIDEO:

With this option, you will receive an e-mail that contains a link to the PowerPoint slides (to download, print, and copy) as well as a link to the media player where you will view and hear the entire webinar just as it was delivered, featuring the full-color PowerPoint presentation with audio. You can pause, fast-forward and rewind as needed, which makes it a very effective training tool. The OnDemand Video will be available to you (and anyone else in the company) for six months and can be accessed 24/7 as many times as you wish. Delivered via e-mail the day after the webinar takes place.

CD-ROM VIDEO:

If you do not have internet access or want to make the webinar part of your training library, the CD-ROM Recording is a great option for viewing a webinar. You can pause, fast-forward and rewind as needed, which makes it an effective training tool.  With this option, you will receive a download of the PowerPoint slides and a CD-ROM Recording (featuring PowerPoint presentation with audio) of the webinar via regular mail. Mailed 7 to 10 days after the webinar takes place.

IN-HOUSE:                                                        

Webinars can be scheduled and offered exclusively for your company.  They can even be customized to best fit your needs.  To find out more, please complete the in-house request form found in the Schedule and Registration Information section below.

Continuing Education (CE) Credits

This webinar is recommended for 2.5 CE Credit Hours. Each attendee will receive a Certificate of Attendance for self-reporting of CE Credits.

Register Here!

Choose the viewing option that best suits your needs. Live Webinar times are shown as Eastern Time. You can choose to pay by credit card or invoice when you register. CFT Credit will be awarded to the registrant, unless directed otherwise (additional attendees can also receive credit for an additional fee). CFT Webinars are powered by Total Training Solutions!

Webinar DateStart TimeEnd DateEnd TimeViewing Options - See Descriptions AbovePrice
02/16/17Archived Six Month On-Dermand Recording$295.00Register
02/16/17Archived CD-ROM Recording$345.00Register
AnyIn-HouseRequest