Welcome to www.ExcelFundamentals.com.
This video is a free beginner Excel tutorial that teaches you 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.
This tutorial uses two examples to show you how to calculate averages using Excel's AVERAGE Function. This tutorial shows you how to apply the averages to your columns or to your rows (or neither- just quickly eyeballing the average without typing in any formula!).
The examples are everyday examples of this 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 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 average my exam scores, what does my final grade come out to for each one of my classes?
Enjoy this video and Subscribe to ExcelFundamentals to stay up-to-date with the latest ExcelFundamentals tutorials. Visit www.ExcelFundamentals.com for more detailed lessons and explanations on all of the tutorials you are watching on the ExcelFundamentals YouTube channel.
Calculate Average in Excel
Теги
average in excelexcel average functionaverage function in excelcalculate average in excelmean in excelexcel meanaverage in excel 2010average in excel 2013excel average formulaexcel average formula examplesexcel average function examplesexcel averageexcel average of columnexcel average of rowexcel average calculationexcel average percentageexcel average credit card billaverage gradegrade point average in excelcredit card expense excel