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

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.

Create a 3D Table Cube

Excel sure gives you many ways to present data in a visual format. Sure there are different graphs like line charts or bar charts, but what about a cube?  Although not always practical, this is more of a novel way to capture your audience for an initial reaction to data. Check out this video on how to create a 3D Table Cube.

P.S. Feel free to provide a comment or share it with a friend!