Microsoft Excel for Healthcare Risk Management Professionals
This “hands-on” skill-building course is designed to equip healthcare risk management professionals and their support staff with the technical skills necessary to fully utilize the data analytics features of Microsoft Excel. This course uses industry-specific scenarios to enable healthcare risk management professionals to apply their knowledge to the principles of data analysis. The goal of the course is to empower healthcare risk management professionals “reach the next level” in their understanding of the analytic tools that are an integral part of Microsoft Excel.
Course Outcomes:
Upon completion of this course, each participant will have the ability to:
- Track Pending and Active Claims
- Harvest Data From External Systems
- Track, Analyze and Report Medication Errors
- Create and Modify Pivot Tables and Pivot Charts
- Assess Data-Drive Risk Management Dashboards
- Develop and Implement Clinical Monitoring Systems
- Establish and Maintain Incident Tracking Spreadsheets
- Track, Analyze and Report Provider Insurance Coverage
- Implement and Analyze Clinical Risk Stratification Models
- Utilize the Principles of Data Visualization to Enhance Reporting
- Enhance Information Integrity Through the Use of Data Validation Techniques
- Integrate Microsoft Excel, Access and Power Point for Data Reporting Purposes
- And Many Other Useful and Practical Topics
Course Outline
This course is offered in two sessions consisting of three hours each.
Part I: (3.0 Contact Hours)
- Organizing healthcare risk data to maximize opportunities for analysis
- Overview of Microsoft Data Analytics Tools and Techniques
- The Challenges of Creating and Implementing Clinical Risk Tracking Tools
- Improving Information Integrity Using Data Validation Techniques and Procedures
- Data Reporting Overview: Detail and Summary Report Creation and Modification
- Implementing Consolidation Techniques to Enhance Data Visualization and Presentation
- Overview Pivot Tables and Pivot Charts for Healthcare Risk Management Datasets
- Understanding and Utilizing VLOOKUP Formulae and Techniques (Part 1)
Part II: (3.0 Contact Hours)
- Understanding and Utilizing VLOOKUP Formulae and Techniques (Part 2)
- Harvesting and Analyzing Data From External Clinical and Regulatory Sources
- Modifying Pivot Tables, Pivot Charts and VLOOKUP Formulae for Data Visualization
- Overview of Implementing Administrative and Clinical Monitoring Systems
- Fundamental Aspects of Creating Risk Management Dashboards Using Excel and Access
- Implementing and Analyzing Clinical Risk Stratification Tools and Techniques
- Integrating Excel, Access and Power Point for Enhanced Data Visualization
Course Prerequisites
Participants should be familiar with Excel spreadsheet functionality, navigation skills and the basic terms associated with the healthcare risk management field. No previous knowledge of Excel’s data analytical tools or techniques is necessary to enroll in this course.
Who Will Benefit From This Course
- Healthcare Risk Management Professionals
- Healthcare Risk Management Support Staff
- Clinicians Interested in Risk Management
- Compliance Professionals
- Quality Resource Managers
- Legal Professionals Working in Healthcare Risk Management
- IT Professionals With An Interest in Risk Management
- Long Term Care Administrators
- Ambulatory Care Administrators
- Healthcare Actuaries
- Insurance Agencies and Providers
- Insurance Brokers
- Healthcare Consultants
- Healthcare Internal Auditors
- Others Individuals with an interest in Healthcare Risk Management
For More Information or corporate classes or workshops, call or email Jim Irvine, Director, Corporate and Continuing Professional Education at james.irvine@sunywcc.edu or 914-606-6658.
This course provides six contact hours of continuing education credit toward fulfillment of the requirements of ASHRM (American Society for Health Care Risk Management) and / or designations of fellow (FASHRM) and / or distinguished fellow (DFASHRM) and towards the Certified Professional in Healthcare Risk Management (CPHRM) renewal.