Excel Training Techniques to Effectively Mine Data

This two-day program (March 11-12) brings together investigators and analysts from the health care anti-fraud industry to learn how to effectively utilize Excel to arrange, analyze, and showcase health care fraud data. Hosted in Washington, DC at the Attune Computer Lab, each participant has their own workstation for hands-on training. Participants will be able to immediately apply the skills and concepts learned at this program.

Designed for skill mastery, each topic builds upon previous concepts. Participants begin with an introduction to various Excel features and layout options that maximize efficiency and quickly move on to basic formatting and data maneuvering. The day finishes with formulas, graphing, and advanced layout features. As those skills are mastered, faculty use fraud examples to showcase pitfalls and errors that might occur while using Excel.

The second day focuses on advanced formulas, pivot tables, and graphs. In addition to the physical manipulation of data, faculty showcase ways to appraise data content for red flags, such as: timed units, days of week, peer comparisons, top billing summaries, upcoding, member comparisons, services not rendered, and impossible days.

Excel Agenda

Interactive Learning

As new skills are introduced, participants will practice using guided exercises and sample data while faculty provide necessary support and answer questions. As skills become more complex, the program shifts focus to organizing and manipulating data to find red flags. At the end of the program, using deidentified data, participants will work through a variety of case studies that incorporate all the skills covered to identify potential fraud.

Skills Developed

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

Program Objectives

Participants will be able to:

  • Use the ribbon functions, shortcuts, and quick access features to work more efficiently.
  • Demonstrate how formals (text, math, date, and time) work.
  • Format data for accurate manipulation and analysis.
  • Organize data within a pivot table.
  • Identify key health data fields necessary to finding fraud and abuse red flags.

Continuing Education Credits


Participants earn 16 Continuing Professional Education (CPE) hours applicable to the training requirements for the Accredited Health Care Fraud Investigator (AHFI) designation.


The NHCAA Institute is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

This program is ideal for analysts and investigators in commercial or government programs insurance or law enforcement who need to enhance their Excel skills to manipulate data to find health care fraud and abuse red flags.

As a Level II, or intermediate, program, some investigative, health care and/or coding expertise is assumed and training content is focused on building upon existing skills using case examples to highlight strategy and technique.

Pre-Requisite: Participants who have the basic Excel skills listed below will gain the most from this program; however, all levels are welcome to attend.

Ideal participants will have a working knowledge of Excel and be confident in basic functions, such as: open and save a spreadsheet, insert and delete worksheets, enter data, basic formatting (e.g., bold text or change general text to currency), adjust a row or column, find and replace data, sort data, and use the AutoSum feature.

Participants should also have a general understanding of health care data and the fields important to recognize potential fraud and abuse.

  Member1 Government2 Non-Members3
2-Day Program $775 $900 $1,175

Ways to Register


Registration is closed. To add your name to the waitlist, please email training@nhcaa.org.


Registration is closed. To add your name to the waitlist, please email training@nhcaa.org.

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 Policy

Registration Deadline: February 28
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.

All cancellations (regardless of date) will be assessed with at $100.00 administrative fee.

  • All written notice of cancellations and substitutions should be sent via email to training@nhcaa.org.
  • Before cut-off date - To cancel and obtain a full refund (minus an administrative fee) or to request a substitution, you must provide written notice to The NHCAA Institute - NETS.
  • After cut-off date - If you cancel in writing after the cut-off date, no refund will be provided but credit for future training is available. All substitution requests received after the cut-off date will be charged a $100.00 administrative fee.

For more information regarding administrative policies on refunds and cancellations or to register a complaint, please contact training@nhcaa.org.

Attune Computer Lab
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 Attune Computer Lab, the facility where the training will be held, has negotiated reduced room rates with several nearby hotels.

For a list of properties that Attune Computer Lab has negotiated with, please review the Attune Computer Lab website.


Ronald Reagan Washington National Airport - DCA

  • Distance to hotel: 5 miles
  • Estimated taxi fare one-way to MircoTek: $35
  • Super Shuttle, $28.00 each way

*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.