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...
by Nate Moore | Oct 11, 2010 | Charts
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...
by Nate Moore | Oct 6, 2010 | Charts
Excel Video 99 covers how to adjust your chart to handle gaps in your data, hidden data, and filtered data. If for some reason you’re missing some data that you want to include in your chart, the Hidden and Empty Cells Window (accessed from Select Data Source) allows...
