By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-average-median-mode/

Learn how to calculate the mean, median and mode of a list of numbers using Excel's AVERAGE, MEDIAN, MODE.SNGL and MODE.MULT functions. You'll learn how to calculate averages on a single worksheet and across a range of worksheets, how to return the median value of a range and how to return both single and multiple mode values from a list.

Chapters
00:00 Topic list
00:40 Basic AVERAGE Functions
03:15 Creating Averages with the AutoSum Feature
04:53 Averaging Multiple Ranges
06:20 A Note on Averaging Averages
08:19 Adding Averages in Group Mode
10:41 Averaging Across a Range of Sheets
13:30 The MEDIAN Function
15:57 The MODE Functions

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!