Excel Formula - Average Excluding Outliers in a Range

Calculate the average excluding outliers in Excel. Outliers are numbers that are outside the typical range and can affect the average result. To ignore these outliers the TRIMMEAN function is used. This function calculates the mean average, but allows for a percentage of numbers to be recognised as outliers. This video tutorial shows this formula being used to calculate the average exam score from a range. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/