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 demostrate 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!
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.
HIIM Domain: Informatics, Analytics, and Data Use
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.