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 workshop will be a hands-on demonstration of Pivot Tables using Office 365. Please bring a laptop with Excel installed to follow along with the examples.
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
