Eligible for: ACMPE: 1|ACHE: 1|CEU: 1|CME(AAPC*): 1|CPE: 1.2|PDC: 1|PDU: 1 *MGMA is now offering our full conference for AAPC credit via our partnership with ACCME. Please see the event Continuing Education page for more information.
Interactive | Intermediate | Application
Part Two of a Two-Part session: The Pivot Table feature in Microsoft Excel® is a fast and powerful way to analyze and consolidate large amounts of data and quickly extract critical knowledge. In this workshop, 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 your laptop with at least Excel 2007 to participate in the workshop training. Please also bring data from your practice to work on at the end of the workshop so that you can take home your data in a Pivot Table.
Learning Objectives:
Produce Pivot Tables using sample medical practice data.
Use Filter, Sort, Group, and Pivot function to analyze data.
Discover multiple applications for Pivot Tables in a medical practice.
