Courses and lessons

Educational material

Excel for Decision Analysis and Modeling

A five module series that introduces the basics of Excel and how to use it for data analysis and modeling

Courses

A five module series that introduces the basics of Excel and how to use it for data analysis and modeling

1. Introduction to Excel for Decision Analysis

Basic intro to Excel and what to expect in other modules

2. Excel Module 2

Prepping Data and Formulas & Functions

3. Excel Module 3

conditional analysis in Excel

4. Excel Module 4

Database (lookup) functions

5. Excel Module 5

VBA and Macros

Policies and reimbursement under Medicare and Medicaid

1. Medicare Severity Diagnosis Related Groups (MS-DRGs)

Inpatient reimbursement under Medicare FFS

2. Cost-to-charge Ratios (CCRs)

a review of charges vs payments vs costs and how hospitals bill

3. PPS-exempt Cancer Hospitals

PCHs in the context of Medicare FFS reimbursement

5. Overview of Commercial Reimbursement Methods

High-level overview of commercial (private) reimbursement, focused on ...

Showing 2 of 2

Lessons

Excel Module 5

VBA and Macros

Overview of Commercial Reimbursement Methods

High-level overview of commercial (private) reimbursement, focused on hospital payment methods and high-cost therapies

PPS-exempt Cancer Hospitals

PCHs in the context of Medicare FFS reimbursement

Cost-to-charge Ratios (CCRs)

a review of charges vs payments vs costs and how hospitals bill

Medicare Severity Diagnosis Related Groups (MS-DRGs)

Inpatient reimbursement under Medicare FFS

Showing 6 of 6