Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics10-Part-02-SORT.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 SORT Array Function:
Topics:
1. (00:00) Introduction
2. (00:11) Download practice file
3. (00:38) SORT function to create a “Fast Race Time” Report
4. (01:40) sort_index argument
5. (02:11) sort_order argument
6. (04:29) Formula to create a sorted unique list.
7. (05:11) Sort by three columns: sort_index argument
8. (06:02) Summary
9. (06:08) 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

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