Webinar on Demand: PIVOT Tables 101: From Data to Information for Beginners
CHIA Product Code: WEB215
Webinar Date: February 25, 2021
The ability to manage and interpret accurate data is essential for healthcare organizations. Making sense of data is a common challenge faced in health information. Summarized reports are usually produced but they may not be easy to read and/or understand. This webinar introduces how health information professionals can utilize Microsoft Excel Pivot Table functions to convert data into meaningful tables that effectively display the information needed.
This interactive session will utilize relevant health information data and will demonstrate Pivot Tables in action. Attendees will learn how to group data together in different ways to draw helpful conclusions and significant insights more easily. With little more than a few drag and drop or point and click actions, participants will be able to summarize and visualize useful data. No complicated formulas are needed. Using Pivot Tables requires the least amount of effort but will give you the maximum amount of value in return.
Attendees that utilize data and crave a method to easily convert data into information will discover:
- An introduction to Pivot Tables
- Options for evaluating data
- Formatting worksheets effectively for use with Pivot Tables
- Ways to create Pivot Table reports
- Rethinking Pivot Tables: ideas to regroup, average, count, total or reformat to better leverage data
- A powerful tool to calculate, summarize and analyze data to see comparisons, patterns, and hidden trends in data
- How to create beautiful dynamic reports and dashboards any boss will love!
CEUs: 1.0 | HIIM Domain: Informatics, Analytics, and Data Use
This webinar has been approved for continuing education units (CEUs) for use in fulfilling the continuation education requirements AHIMA, AAPC, BRN, and ACDIS for CDI-related events not to exceed ten units from any single event. CEUs are based on contact hours. 30 minutes of attendance at an educational program equals .5 CEU. For full details on CEU qualifications, calculations, and more, view the AHIMA Recertification Website. CEUs may be adjusted based on actual time of event.
Diane Premeau, MBA, RHIA
Director, Department of Public Health San Francisco
Diane Premeau specializes in the migration from paper to a chartless environment. With a background in psychology and sociology, working in diverse environments in large health systems has been a dynamic part of her career. Diane’s areas of expertise include change management, systems analysis, development of health information systems, database management and she develops courses and teaches health informatics.
About Webinars on Demand:
CHIA offers Webinars on Demand, which are available for separate purchase after the live Webinar has been presented. This convenient format consists of the full 60-90 minute recorded presentation, distributed handout, and accompanying Continuing Education Unit (CEU) certificate. Each Webinar on Demand is only available for purchase and access for one year after the original recording date. After purchase, a Purchase Confirmation will be sent to the purchaser’s primary email address and will contain the access links.