Learn how to easily summarize your data in Excel by group!

Download the Excel files or Excel Cheatsheet: [ Ссылка ]

I am going to go through how to calculate averages, standard deviation, standard error, number of samples, max and mins.

We will also dive into how to if statements including averageif, countif, maxifs, and minifs.
---------------------------------------------------------------------------------------------------------------------------
Follow me:
Twitter: [ Ссылка ]
Instagram: [ Ссылка ]
Buy Me A Coffee: [ Ссылка ]
My Merch: [ Ссылка ]

My Filming Setup:
Canon EOS M50 Camera: [ Ссылка ]
Tripod: [ Ссылка ]
Lights: [ Ссылка ]
Table Microphone: [ Ссылка ]
Lavalier Microphone: [ Ссылка ]
Microphone Stand: [ Ссылка ]
SD card: [ Ссылка ]

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you.

Timestamps
0:00 How to summarize your data in Excel
1:00 Summarizing data by formula
5:30 Averageif
6:25 Standard deviation with if functions
7:48 Text criteria
11:44 Finding the Max number with if statements
15:48 Summarizing data with pivot tables

свернуть