This video is a free beginner Excel tutorial. You’ll learn how to calculate average in Excel using the AVERAGE Function or by using the ‘eyeball method’. This video also introduces you to the MIN and MAX functions in Excel.
Watch two examples in my video below to learn how to calculate averages using the Excel AVERAGE Function. Learn how to calculate average in Excel for your columns or for your rows (or neither- just quickly eyeball the average without typing in any formula!).
The examples in the video tutorial are everyday examples of things you might want to take an average of. For example, in an average month, how much did I spend on gas on my credit card? In an average month, how much did I spend on dining out, travel, or entertainment with my credit card?
The MIN and MAX Function introduction also helps you identify what were your lowest and highest spending months for a category on your credit card.
Another everyday example in this tutorial is calculating your grade for a class. When I calculate the averages of my exam scores, what does my final grade come out to for each one of my classes?
Watch my video below to learn how to calculate average in Excel to quickly and efficiently answer these questions, saving yourself time and energy! Practice along as you watch!
I know, I know, the AVERAGE Function in Excel is a huge time saver! No more calculating averages on your computer or cellphone calculator (adding every number and then dividing by the number of numbers- I get dizzy just thinking about it!). With a few clicks you’ve got your average, the minimum, and the maximum numbers in any given range of numbers.
Whether you’re calculating your average credit card bill, your grade point average, or your average calories in a day, having the AVERAGE, MIN, and MAX functions at your disposal will make you a lean, mean, spreadsheet-analyzing machine.
I hope you enjoyed my ‘Calculate Average in Excel’ video. Leave a comment below and let me know if this tutorial helped you save time in Excel!