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 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 see a variety of techniques to filter, sort, group, and manipulate practice data. We’ll also discuss several different applications of pivot tables throughout a medical practice. The presentation will be a live demonstration using Excel 2016 for the PC. No prior knowledge of pivot tables is required, but the webinar will assume an intermediate level of Excel experience.
- 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.
Once you purchase the recording, you will receive two emails - one confirming your purchase and one that contains your "downloadable items." The downloadable items email will link you to a zip file containing the webinar handout and the recording link.