The No. 1 Trade Show Site in the U.S.

Menu
×
EVENT DATE
Feb 2017
M T W T F S S
2728
EXPO DATE
Feb 2017
M T W T F S S
2728

Venue


Online Event
Location map
Tel:
Type: Online Event

HOTEL DEALS

Booking.com

TRAVEL DEALS

Expedia.com

Partners

exhibitus success by design Remington Hotels

Get a Handle on Duplicates in Your Excel Data

B2B

EVENT DESCRIPTION

Excel expert David H. Ringstrom, CPA, shows you how to identify and manage duplicate data within your spreadsheets in this live Microsoft Excel training. 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 explains how to use the MATCH worksheet function to help you identify discrepancies in two different lists, how VLOOKUP will stop searching for duplicates after an initial match in found within a list, and how to use Excel’s Data Validation feature to create a rule that ensures users can’t enter the same data more than once in a given area of a spreadsheet.

Why Should You Attend

David will demonstrate techniques from Excel 2016, 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.

If the Get a Handle on Duplicates in Your Excel Data is important to your business, act now and make the appropriate connections. See the contact information below.

EVENT CONTACTS

Sign Up for FULL Membership and Log In to access Event Contact Information.

EVENT DETAILS

Primary Industry:
Banking-Money-Finance
Other Industries:
Banking-Money-Finance, Business, Business Technology, Technology
Audience:
Practitioners seeking to identify and manage duplicate data in Excel.
Notes:
Show Owner:
Compliance Global Inc.
Sponsorship: Yes

Exhibitor Information +

Booth Details:

Booth Size
Booth Cost
No Exhibiting
Amenities
Electricity:
n/a
Water:
n/a
Generator:
n/a
Marketing Vehicles Allowed:
n/a
Services
n/a
Show Owner
Compliance Global Inc.

floor plan

MORE events +

BUSINESS+
HEALTH CARE+
MANUFACTURING+
TECHNOLOGY+

Display Makers

Promo Makers

2017: 2,575 Trade Shows
2018: 575 Trade Shows
© copyright since 2008 All Rights Reserved eventsinamerica.com
495
page views