Carving Up and Drilling Down: Using Microsoft Excel’s Pivot Table Feature to Analyze a Practice’s Revenue Cycle

Speaker: Nate Moore, CPA, MBA, FACMPE

Positioning for Future Success (Take Home Concepts):

- Understand how to use pivot tables in a medical practice setting to better track collections, analyze reimbursement, collect accounts receivable, and more.
- Comprehend a variety of techniques to filter, sort, group, and manipulate practice data.
- Be able to use pivot tables to analyze your internal business operations.
- Uncover ways to better analyze your business data as well as your customers’ data with a clear understanding of how easy it is to use pivot tables to do data mining.