Microsoft Excel for Healthcare Risk Management
Course Overview: Over the last several years, the Healthcare Risk Management profession has rapidly expanded in both scope and complexity. As a result of this expansion, Healthcare Risk Management professionals must now master the technical skills necessary to manage a vast quantity of administrative, clinical and financial information. Contemporary Healthcare Risk Management professionals are called upon to proactively manage information from many areas which address a wide assortment of topics, including but not limited to:
- Event and Incident Tracking
- Risk Identification and Assessment
- Patient Safety and Outcomes
- Comparative Benchmarking
- e-Prescribing & CPOE
- Medication Error Tracking
- Claims Management
- Provider Credentialing
- Implant Registry Tracking
- Litigation Expense Tracking
- Provider/Patient Communication
- Appointment Tracking
Learning Outcomes / Skillset Acquisition: This course focuses on how to use Microsoft Excel for analyzing information from selected areas found within the Healthcare Risk Management environment. Using a “hands-on” learning format, each participant will master a number of analytical tools within Microsoft Excel, including but not limited to:
- Report Writing
- Data Consolidation
- Pivot Tables
- VLOOKUP/HLOOKUP
- Data Filtering
- Harvesting Data from 3rd Party sources
- Linking Excel with Power Point
- Data Validation Techniques
- What-If Analysis / Data Forecasting
- Interactive Charting & Graphing
Who will benefit from this course:
Healthcare professionals who are involved in the Risk Management area will benefit from this course. This includes administrators, physicians, nurses, financial managers and members of their support staff.
Prerequisites:
Basic working knowledge of Microsoft Excel or similar software tool is necessary. Participants in this course should be willing to actively engage with their peers in a learning experience which encourages sharing of information so all learners benefit from the collective experience of their colleagues.
Spring 2023
Location: Online (virtual or in-person)
Date(s): Call for Dates or Corporate Classes
Time: TBD
Catalog #: CE-COMP 2248
Class #: TBD
Cost: TBD
How to Register:
Register over the phone using MC, Visa or Discover. Call 914-606-6830, press 1
You will need the Class # when speaking with a representative.
Office hours for registration are Monday – Thursday 8:30 a.m. to 7:15 p.m.
Friday 8:30 a.m. to 4:30 p.m. (in summer, 9:00 a.m. – 12:00 noon)
Saturday 9:00 a.m. to 3:30 p.m. (in summer, closed some Saturdays)
For course questions, please contact:
Jim Irvine, Director of Corporate and Continuing Professional Education 914-606-6658 james.irvine@sunywcc.edu