April NETS15

April 27 - 30
MicroTek Computer Lab | Washington, District of Columbia

Registration Rates
Register - CLOSED
Hotel Reservations & Travel Information



Excel Techniques to Effectively Mine Data - The Basics + Advanced Concepts
Space limited to 30 participants for each session. Computers with Excel 07 will be provided.
Substitution, Cancellation, and Deadline for Participant Roster: Friday, April 10

Session 1: SOLD OUT
April 27 - 28
2 days | 16 CPEs
Level II

Session 2: SOLD OUT
April 29 - 30
2 days | 16 CPEs
Level II

Day 1

Focuses on introductory Excel skills, which will be demonstrated by faculty and participants will be given time to practice using sample data sets. Faculty will work with each participant to ensure technique mastery. Health care fraud examples will be used in each demonstration to connect skills back to health care anti-fraud activities. Participants will understand what types of information to request from their IT team and how to spot red flags in data in a variety of schemes across specialty areas, such as: timed units, days of week, peer comparisons, top billing summaries, upcoding, member comparisons, services not rendered, impossible days, and more.

Skills Covered:

Basic formatting of worksheets Formatting data
Formulas for mathematics and formatting Averaging numbers
Creating charts AutoFill
Adding/Subtracting time Printing worksheets
Sort and filter data Shortcuts
Line breaks Absolute references
Text to columns Data validation
Drop down lists Pivot table basics


Day 2

Faculty will delve deeper into pivot tables, graphing/charting, advanced formulas, and ways to present data findings to peers and supervisors. Participants will also practice finding and recognizing more complex fraud in data.

The additional content will be presented through case study examples where participants will work through sample data sets to identify potential fraud using their newly acquired skills.


  Member1 Government2 Non-Member3
2 Day Program $770 $885 $1,170

1NHCAA Member rate applies to all NHCAA Member Organizations, Affiliate Members, Individual Members, Platinum Members, Premier Supporting Members and Supporting Members.
2Government rate applies to NHCAA Law Enforcement Liaisons and other attendees from local, state and federal public agencies.
3Non-Member participants must occupy a professional position with a private for-profit or not-for-profit health care reimbursement organization, or in a local, state or federal law enforcement, prosecutorial, or regulatory agency or in a professional disciplinary organization. All registrations will be reviewed to ensure these eligibility requirements are met. If you are not in one of these positions, but wish to attend, please email us at: training@nhcaa.org.



Registration is now CLOSED.


Substitution & Cancellation Policy

Registration, Substitution, Cancellation, and Deadline for Participant Roster: Friday, April 10. NHCAA accepts registrations after this date; however, NHCAA may not be able to include your contact information in the participant roster or have a certificate of completion on-site for you.


To cancel and obtain a full refund, minus a $75.00 administrative fee, you must provide WRITTEN NOTICE OF CANCELLATION to The NHCAA Institute by the Registration, Substitution and Cancellation Cut-off Date (see above). If you cancel in writing after that date, no refund will be provided. To cancel please email the Manager, Education & Training Services, at training@nhcaa.org or mail the NHCAA Institute - NETS at 1201 New York Ave., NW Suite 1120, Washington, DC 20005.


To request a substitution, you must provide WRITTEN NOTICE OF SUBSTITUTION to the NHCAA Institute by the Registration, Substitution and Cancellation Cut-off Date (see above). All substitutions received after the cut-off date will be assessed a $75.00 fee. Please email the Manager, Education & Training Services at training@nhcaa.org to request a substitution or mail the NHCAA Institute - NETS at 1201 New York Ave., NW Suite 1120, Washington, DC 20005.



1110 Vermont Ave., NW
Suite 700
Washington, DC 20005


A public parking garage is attached to the building; the entrance is on Vermont Ave. Their rates are: $17 per day Monday through Friday from 6:00 a.m. to 7:00 p.m.


NHCAA has not negotiated discounted rooms; however MicroTek, the facility where the training will be held, has negotiated reduced room rates with several nearby hotels.

For a list of properties that MicroTek has negotiated with, please review the MicroTek website. We encourage you to book early as April is a desirable time of year to visit DC.


Ronald Reagan Washington National Airport - DCA

*IMPORTANT: Website URLs, taxi fares, parking costs, check-in & check-out times, and other quoted prices and information may be changed at the vendors' discretion. Please confirm all costs associated with your travel prior to attending the program.