by Nate Moore | Oct 27, 2010 | Charts
Excel Video 105 showcases clinical data instead of the financial data we’ve spent time charting in prior videos. More and more, the ability to track clinical data in a dashboard will be critical to a practice’s success. Besides applying our charting tricks to clinical...
by Nate Moore | Oct 25, 2010 | Charts
Excel Video 104 covers moving averages, another way to use a trendline in your chart. A moving average is simply an average over the last several periods of data in a chart. We chose to use a three month moving average, so Excel averages the last three months on the...
by Nate Moore | Oct 20, 2010 | Charts
Excel Video 103 introduces the TREND function to forecast the next three month’s billed charges. Trend is an array function, so instead of getting the formula right in one cell and copying down, you select all of the cells you want the answer in first. The other thing...
by Nate Moore | Oct 18, 2010 | Charts
Excel Video 102 takes you back to your algebra days to forecast billed charges. Remember y=mx+b, the equation to chart a straight line? That equation will come in handy in Excel Video 102. To forecast billed charges, we’ll use the y=mx+b equation to project future...
by Nate Moore | Oct 13, 2010 | Charts
Excel Video 101 helps you add a forecast to your chart. Adding the forecast is easy. Figuring out what Excel’s forecast and how Excel calculates that forecast is a little more work. Excel Video 101 is a little longer than the average video because I give you some...
