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
Use the AVERAGE (AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS) Functions
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.
Subscribe to:
Posts (Atom)