Excel Training Techniques to Effectively Mine Data
This two-day program (March 27 – 28) 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 MicroTek Training facility, 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.
Space is limited; maximum class size is 30 individuals. Computers with the version of excel common to most attendees will be provided.
- Who should attend? Details 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.
- Interactive Learning Details 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 Details - Absolute references
- Adding/subtracting time
- 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
- Sort and filter data
- Text to columns .
- Program Objectives Details 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 Details
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.
|2 Day Program||$775||$900||$1,190|
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: firstname.lastname@example.org.
Multiple Ways to Register
- Online: register online via secure transactions. Please have a Visa, MasterCard, Discover or American Express card available.
- Fax: Fill out & print completed registration form. Fax form along with credit card payment information or purchase order to 202.785.6764.
- Email: Email your completed registration form along with purchase order to email@example.com.
- Mail: Fill out & print completed registration form. Mail form along with payment information to NHCAA 1220 L Street, NW, Ste 600, Washington, DC 20005. Make check payable to "The NHCAA Institute".
Registration Deadline: March 13
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 firstname.lastname@example.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 email@example.com.
HOTEL RESERVATIONS & TRAVEL INFORMATION
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 June is a desirable time of year to visit DC.
- 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.