Microsoft Excel’s Pivot Table feature is a fast and powerful way to analyze and consolidate large amounts of data and quickly extract critical knowledge. In this two-part session, you’ll learn how to use Pivot Tables in a medical practice setting to better track collections, analyze reimbursement, collect accounts receivable, and more. You’ll also learn a variety of techniques to filter, sort, group, and manipulate practice data. We’ll also discuss ways to use Pivot Tables to analyze your internal business operations. This extended session will be a hands-on demonstration of Pivot Tables using Office 365.
Please bring a laptop fully charged with Excel installed to follow along with the examples. You can access the spreadsheets for the session here: https://www.mgma.com/content/nate-moore
Learning Objectives:
Create a Pivot Table using sample medical practice data
Filter, Sort, Group, and Pivot to analyze data
Discover multiple applications for Pivot Tables in a medical practice
