Education & Certification
Tech Tools: Basics of Microsoft Excel
OpenTech Tools: Basics of Microsoft Excel 1.0
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.
- 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!
Cost: Members: $60 / Non-members: $85
CNE: APIC is accredited as a provider of continuing nursing education by the American Nurses Credentialing Center's Commission on Accreditation.
Nursing contact hours: 1
How can I get contact hours?
To receive contact hours for an online course, you must complete the program in its entirety and complete an online evaluation. Your feedback is not only required by the accrediting organization, but it is vital to development of future programming.
How do I meet requirements to evaluate the program?
Complete the online evaluation from your computer immediately upon completion of the course by using the course survey link provided in the training menu. Once the online evaluation is complete you will be eligible to obtain your contact hours via the certificate of completion.
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”.
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.
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 firstname.lastname@example.org for more information.
Please note that online courses will be available 24 hours after your registration has been processed.
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.