Tech Tools: Basics of Microsoft Excel

Increase your proficiency with Microsoft Excel, one of the most essentials tools in an infection preventionist’s toolkit.

Designed by subject matter experts well-versed in the healthcare environment, each section of the course focuses on aspects of Excel that will be of specific use to an IP. Similarly the sample data set reflects the types of data that is commonly collected, analyzed, and presented by an IP.

You’ll learn how to improve workflow and data analysis through use standard Excel features, including formatting and formulas, graphs, and pivot tables.

Proficiency Level:



IPC Informatics





Member Price:


Non-Member Price:



Is the thought of learning new or unfamiliar technology overwhelming? Even the most basic of software skills can become a low priority when you’re just trying to manage your day-to-day tasks, but these “tech tools” can make you more efficient and enhance your reporting abilities. Through narrated presentations and activities, we will show you the features of Excel to help keep your data in an easy-to-use and presentable format.


  • Navigate MS Excel
  • Organize and enhance data with formulas and formatting
  • Create standard graphs and charts to present data
  • Build tables and pivot tables

Registering for this course? Participate in the MyApic online discussion board designed to accompany this class. Contributing to the discussion board will be an important part of your class experience because you will be able to:

  • Ask questions about what you learned (or any other Excel questions you might have)
  • Share your personal Excel tips and tricks with your peers
  • Suggest other software tools you’d like to see us cover in future Tech Tools classes
  • Post your personal favorite Excel-driven charts or graphs
  • Send a private message to a fellow participant or the course administrator

To access the discussion board, simply log in to, click the green arrow next to your name, and select MyAPIC in the dropdown menu. The link will also be available in the course description in your Training Menu!


Andrea Ankrum, MT(ASCP), MS, CIC, Infection Preventionist, Cincinnati Children’s Hospital Medical Center

Andrea Ankrum has twelve years of experience in clinical microbiology laboratories specializing in molecular testing and development. She has been in Infection Prevention at Cincinnati Children’s Hospital Medical Center for five years.

Kim Stanley, MPH, CIC, Surveillance Practitioner, UCSF Medical Center

Kim Stanley has worked in Infection Prevention for almost 10 years in San Francisco, CA. Currently, she works at the University of California San Francisco (UCSF) Medical Center in the Hospital Epidemiology and Infection Control department. Kim is very involved in her local APIC chapter and has served on its Board of Directors.

Deana Samms, BS, MA, CIC, Infection Preventionist, Charleston Area Medical Center

Deana Samms is an Infection Preventionist with 19 years experience at varying levels of individual and program responsibilities in infection prevention. She currently serves in a variety roles; an Infection Preventionist at Charleston Area Medical Center, a consultant with APIC Consulting, adjunct professor at Liberty University, and a professional counselor. A former APIC Chapter President, her expertise includes performance improvement, project management, conflict resolution, work group facilitation, written and verbal communication.

This program is mapped to the APIC’s IP Competency Model. This model describes the knowledge, skills, and behaviors considered key to advancement and guides IPs toward areas of professional development throughout all career stages. Click here to view the full model.

Paying by check? Please download the 2020 registration form and mail it to the noted address. Please ensure that the registration form and any corresponding documents are included as we cannot process registrations without payment.

Bulk sales are available. Email for more information.


The Association for Professionals in Infection Control and Epidemiology, Inc. (APIC) is accredited with distinction as a provider of continuing nursing education by the American Nurses Credentialing Center’s Commission on Accreditation (ANCC).

Course evaluations will be available in your online training menu at the end of the course.

All course-related evaluations must be completed within 30 days of course completion. After satisfying all evaluation requirements, a certificate of completion will be available to print and/or download under My Transcripts for your records indicating CEUs.

Accredited status does not imply endorsement by APIC or the American Nurses Credentialing Center of any commercial products displayed or discussed in conjunction with an educational activity.

Technical Requirements

APIC Education Online courses are accessed through a web browser. The web browser you use must accept cookies, run Adobe Flash, and run JavaScript.

We recommend the below browsers and plug-ins for the best online learning experience

  • Minimum Internet Bandwidth
    Standard Definition (SD) videos: 5 Mbps
  • High Definition (HD) videos: 8 Mbps

Computer Operating System

  • PC: Windows XP or newer
  • Mac: OS X 10.5 (Leopard) or newer

Web Browsers

  • Internet Explorer 8.0 or above
  • Firefox support for most recent 2 public versions
  • Safari support for most recent 2 public versions
  • Google Chrome support for most recent 2 public versions

Browser Plug-ins
Flash Player version or higher. Go to Adobe Flash Player to install the latest version.

Note: APIC Education Online is a mobile-responsive website however, devices running iOS (like iPads, iPhones, and iPod Touches) are not able to display course content at this time, due to Flash restrictions on iOS.
Technical support:

Cancellation Policy

APIC must receive all cancellations in writing within 30 days of purchase if you have not yet started the course. If you have started the course, you must submit your cancellation within 7 days of the start day to be eligible for a refund.

Please submit cancellation requests to or via fax to (202) 789-1899. Courses are non-transferrable and remain with the original registered individual regardless of position changes or employee departures.