YoVDO

Standard Deviation with Criteria - Power Query, PivotTable, or Array Formula

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Power Query Courses PivotTables Courses Array Formulas Courses AVERAGEIFS Courses

Course Description

Overview

Learn how to calculate average and standard deviation with criteria in Excel using three different methods: array formulas, PivotTables, and Power Query. Explore the AVERAGEIFS function, STDEV.S function with IF conditions in array formulas, and discover how to utilize PivotTables for quick calculations. Dive into Power Query examples, including grouping rows and using the List.StandardDeviation function. Master these techniques to efficiently analyze data and gain valuable insights from your Excel spreadsheets.

Syllabus

) Introduction & Setup.
) Array Formula for calculating Average and Standard Deviation with Criteria. See AVERAGEIFS function and the STEDV.S & Two IF functions in an Array Formula..
) PivotTable for calculating Average and Standard Deviation with Criteria..
) Power Query Example 1: Group By All Rows & Extra Column with List.StandardDeviation Power Query Function. Use Group By to calculate Average and Standard Deviation with Criteria..
) Power Query Example 2: Use Group By Power Query Feature and then change M Code from List.Average Function to List.StandardDeviation function..
) Summary.


Taught by

ExcelIsFun

Related Courses

Microsoft Excel Dashboards & Data Visualization Mastery
Udemy
Excel 2011 for the Mac: Advanced Formulas and Functions
LinkedIn Learning
Microsoft Excel - Practical Excel Masterclass
Udemy
Intermediate Excel
Cybrary
Excel Statistical Analysis - Introduction to Probability, Power Query & Pivot Table Example
ExcelIsFun via YouTube