excelisfun | Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858 @excelisfun | Uploaded 6 months ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1857-1858.xlsx
Learn how to group in the GROUPBY and PIVOTBY functions to create Frequency Distributions.
Topics:
1. (00:00) Introduction to Frequency Distribution
2. (00:38) Start, Increment and Last Value for frequency distribution using MAX and CEILING.MATH functions
3. (01:12) Build Bins using SEQUENCE function
4. (01:42) Build GROUPBY Formula using LET and GROUPBY
5. (02:37) Look at PIVOTBY Formula
6. (02:43) Understanding Categories
7. (03:00) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #groupby #pivotby