JOIN NOW | Print Page | Contact Us | Sign In
Webinar: Carving Up and Drilling Down: Using Microsoft Excel’s Pivot Table to Analyze Revenue
Tell a Friend About This EventTell a Friend
Webinar: Carving Up and Drilling Down: Using Microsoft Excel’s Pivot Table to Analyze Revenue

Presented by Nate Moore, CPA, MBA, FACMPE

8/8/2018
When: 08/08/2018
From 1:00 - 2:00 PM Eastern Time
Where: Adobe Connect
United States
Contact: Marcus Dean
(412) 243 - 5156


Online registration is closed.
« Go to Upcoming Event List  

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. 

 

Educational 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.

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.

AOA Office

2400 Ardmore Blvd., Suite 302
Pittsburgh, PA 15221
Phone: 412-243-5156
Fax: 412-243-5160

info@aoanow.org

Privacy Statement