Tech Tools: Basics of Microsoft Excel

First installment of a multi-part series! The Tech Tools course teaches you how to improve workflow and data analysis through use standard Excel features, including formatting and formulas, graphs, and pivot tables.

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.

View the sample data set for this course

Learning Objectives:

  • 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 online discussion board that we made especially for this Excel class and all our future Tech Tools courses. 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!

Length:1 hour

Cost: Members: $30 / Non-members: $55

CNE Nursing contact hours: 1
Expiration Date: December 31, 2019

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.

Paying by credit card? Please select the orange “Register” button.

Paying by check? Please download the 2019 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.

Please note that online courses may take up to 24 hours after your registration has been processed to appear in the learning platform.

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.

The Association for Professionals in Infection Control and Epidemiology, Inc. (APIC) is accredited 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:

Meet our Subject Matter Experts!

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

Section 1: Overview of Microsoft Excel & General Formatting

Section 2: Formulas & Functions

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. In addition to her role as subject matter expert for this Tech Tools series, she also serves on APIC’s national Education committee. Andrea is currently completing an MS in Epidemiology from the University of Cincinnati.

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

Section 3: Graphs & Charts

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 for the last 7 years. This is Kim’s third year on the Education Committee and she has really enjoyed getting involved with APIC on a national level. In her spare time Kim loves to spend time outside with her family riding bikes and hiking on the coast.

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

Section 4: Tables & Pivot Tables

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. In 2012, she received the shining Star Award for her work with the APIC West Virginia chapter. In addition to her role on the APIC Tech Tools series, she has also presented on such topics as water contamination, construction and renovation, contributing to APIC’s EPI 102 course “The IP’s Role in Construction”.


Why Should You Attend?

Is the overwhelming thought of learning technology a sore point among your chapter members? Even the most basic of software skills can become a low priority due to all of the responsibilities that fall on IPs, but these “tech tools” can make you more efficient and enhance your reporting abilities. APIC is excited to release ‘Basics of Microsoft Excel for IPs” the first installment of a multi-part Tech Tools series. 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.