Animate an Excel Chart in PowerPoint

There are times when you need to present your Excel chart.  And usually if you have Excel, you probably would have PowerPoint. Instead of a static Excel chart, you can make it "dynamic" with the animation features of PowerPoint. This video shows how to animate Excel chart that are pasted into a PowerPoint slide.  You can animate the whole chart or specific parts of the char

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.

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