MooreSolutionsInc.com is the best online resource for medical practices to learn and then leverage Excel to better manage their data and their practices. The videos page has a wide variety of videos that have been viewed tens of thousands of times by medical practice managers across America. I've given live presentations on how to use Excel in a medical practice from Miami to San Francisco for the MGMA, physician associations, state MGMA chapters, and medical practices. The presentations are everything from full day, bring your laptop and follow along sessions to shorter concurrent sessions at annual conferences. I'd love to speak to your organization at an upcoming meeting. I do webinars for a variety of organizations as well. I also write articles for medical practice publications. Some of these sample reports may also give you some ideas to get started.
Between the videos, presentations, webinars, articles and the sample reports, you're sure to find a ton of helpful Excel information to help you and your practice. Once you're more familiar with Excel, there are all kinds of ways to use Excel to better understand your medical practice data. I help medical practices throughout America pull critical data from their practice management and electronic medical records systems into datasets, as described in my book Better Data, Better Decisions: Using Business Intelligence in a Medical Practice. I'll help you connect those datasets to Excel so that you can quickly and efficiently get to the data that matter most in your practice.