Excel Video 141 launches our discussion of Excel functions with five basic functions. Most Excel users will be familiar with SUM, COUNT, MIN, MAX, and AVERAGE. I’ll walk through a brief example using those 5 functions.
Even if you’re familiar with those functions, watch the video to see a shortcut to get all five functions to show up in the status bar at the bottom of your spreadsheet. Once you’ve set it up, all you have to do is highlight data with your mouse and Excel will automatically show you the sum, count, min, max, and average of the highlighted data in your status bar without having to write any functions.
Stay tuned. We’ll start on the financial functions next.