Monday, June 17, 2019

Add a Trendline to a Chart to Make Forecasts

Line charts are a good way to look at how data changes through time. It also aids you in seeing a trend.  With that in mind, there is an option is Excel to add a trendline that helps you forecast how the existing data might be interpreted for the future.  See this video to learn how  to add a trendline to a line chart to make forecasts.

Wednesday, June 12, 2019


Did you know that is more than one function to perform an average calculation? I'm talking about the calculation to get the mean.  In fact there are several average-type of calculations.  In this video, I'll cover four different AVERAGE functions and how to use them

Tuesday, June 11, 2019

Use the FIND Function

If you've got heaps of info in your worksheet sometimes it's hard to look for specific info in all those cells.  Luckily Excel has a useful function that can help you perform a search in a cell and better yet use that result in other formulas.  This video covers how to use the FIND function to do that.