Before we get into the content, I want to thank each of the viewers across the country and in many parts of the world for watching the Excel Videos series at mooresolutionsinc.com. If you watched all of the videos, you’ve spent 6-7 hours and covered a lot of valuable Excel information. I hope the videos have been very helpful for you in your practice.
Excel Video 100 starts our discussion of how to add trendlines to an Excel chart. Excel offers several different types of trendlines, but I think the ones that will be most important for a medical practice are the linear trendlines, moving averages, and the forecasting equations behind the trendlines. We’ll cover those areas in coming Excel Videos.
Excel Video 100 walks through the basics of creating a simple trendline. Typically, you’ll use trendlines on time-based data charted in column, line, and area charts. That’s the example we’ll work through today. Once you understand the basics, in coming Excel Videos we’ll get a little fancier and extend the trendline into the future and do some forecasting and then look at moving averages.
Once we’ve looked at forecasting and moving averages, I’ll also show you how to do some simple regression analysis that might come in handy as you look at clinical data. Speaking of trends, one of the trends in medical practice management and EMRs going forward will be the ability to chart and track clinical data in dashboards like we’re tracking financial data today. Trendlines in those types of clinical charts will be a powerful application in the future.
Thanks again for watching.
