Are you were repeatedly frustrated with the inability to efficiently get data out of our practice management systems in a format that mere mortals could really use with our shrinking budgets. This webinar can change the ways you gather and look at your data. This is not about what to report or even what is important for your practice. It is about how to obtain the data (even those “unreportable data fields” your vendors tell you are not available) and what will now be an endless number of ways to look at your data. You will be delighted to know that gathering this data is also relatively inexpensive!
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.
This is a preview of what's to come at a session for AOA-36 that will be presented by Nate Moore, CPA, MBA, FACMPE.
- 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.
Speaker: Nate Moore, CPA, MBA, FACMPE
Our speaker, Nate Moore, CPA, MBA, FACMPE, speaks, consults, and writes about business intelligence in medical practices throughout the country. His presentations consistently receive top marks as powerful, entertaining tools that can be used in the clinic immediately. Nate’s two books, Even Better Data, Better Decisions: Advanced Business Intelligence for Medical Practices, and Better Data, Better Decisions: Using Business Intelligence in the Medical Practice, are MGMA best sellers. Nate’s consulting focuses on using SQL Server to mine and leverage medical practice data into actionable knowledge.