Select Page

## Excel Video 105 Clinical 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...

## Excel Video 104 Moving Averages

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

## Excel Video 103 Forecasting Part 3

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

## Excel Video 102 Forecasting Part 2

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

## Excel Video 101 Forecasting Part 1

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