Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics10-Short-GROUPBY.xlsx
Full free YouTube class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ ExcelBasics10-Parts-01-02-03
The Only App That Matters book by Mike Girvin at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ccs_id=70eb6de0-afb4-4979-a9a7-a1bdc0089ad3
In this video learn about the GROUPBY Function to create a Percent Of Count Total Report:
Topics:
1. (00:00) Introduction
2. (00:15) Download File
3. (00:23) How a PivotTable calculates Count and % of Total Count
4. (00:50) Use GROUPBY & PERCENTOF to create a frequency distribution that can count and do a percent of count total.
5. (01:05) How PERCENTOF function works
6. (01:21) SEQUENCE Array Function to create a helper column of one values
7. (02:11) Final GROUPBY formula
8. (03:02) Summary
9. (03:16) Closing

Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese.
Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish.

#excel #excelisfun #groupby #dataanalysis #Sort #filter
#filterarrayfunction #filterfunction #excelfilter #percentof

#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions