Course Information

Tech Tools: Basics of Microsoft Excel

Tech Tools: Basics of Microsoft Excel

Upcoming Courses

  • Open
    Tech Tools: Basics of Microsoft Excel 1.0

Online course access will not be available starting June 19. Please review the Registration tab for important information

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 www.apic.org, 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: $60 / Non-members: $85

CNE Nursing contact hours: 1

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 education@apic.org or via fax to (202) 789-1899.  


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.


Member Registration Fee: $60.00
Non-Member Registration Fee: $85.00

IMPORTANT NOTICE: APIC is launching a new online education experience for our virtual learners!

The implementation of this new platform will require the system to be unavailable starting June 19 with an official launch date of August 1.

As we transition to this new system, unfortunately we will not be able to migrate partial course progress, only course completion.

If you are interested in registering for a course, we encourage the following:

  • If you do not plan to complete the course by June 18, we recommend that you start the course when the system is live on August 1 so you don’t lose any work you have done in the course. 
  • If you must complete the course prior to August, we recommend that you finish the course no later than June 18. If you are not able to complete it by this date, your work thus far will not be recorded in the new system. 

If you have any questions or concerns, please contact us at education@apic.org.

Please note that online registrations can only be paid via credit card.

To pay by check, please complete the registration form and mail it to the noted address. When mailing the check, ensure that the registration form is included as we cannot process registrations without payment. 

Bulk sales are available. Email education@apic.org for more information.

Please note that online courses will be available 24 hours after your registration has been processed. 

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 education@apic.org or via fax to (202) 789-1899. 

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 availablein your online training meny upon completion 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 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.