Practice Excel for 30 Days with Stephen.
In Day 4, we cover sorting and filtering - sorting from the Data tab, multi-column custom sort by profit then month, keyboard shortcuts for sorting, filtering with number filters, and filtering between values.
Timestamps:
0:00 - Intro: Sort and filter overview
1:00 - Sorting from the Data tab
2:00 - Multi-column custom sort (profit then month)
3:30 - Keyboard shortcuts for sorting
4:00 - Filtering data (number filters)
5:00 - Filter between values
6:30 - Key takeaway
Code + datasets: https://github.com/sdw-online/30-Day-Excel-Challenge
Playlist: https://www.youtube.com/playlist?list=PL92LwdfbhlXG4E-u5i7ZnLq2HeQYLVnbM
Join the waitlist:
Free community - https://data100x.carrd.co/
Private community - https://data100.carrd.co/
Become a data analyst:
Analyst Builder - https://www.analystbuilder.com/?via=stephen-david-williams
Socials:
LinkedIn - https://www.linkedin.com/in/stephen-david-williams-860428123/
GitHub - https://github.com/sdw-online
TikTok - https://www.tiktok.com/@sdw.online
Instagram - https://instagram.com/sdw.online
Twitter/X - https://twitter.com/sdw_online
#excel #dataanalysis #dataanalytics #excelchallenge #sorting #filtering
Download
0 formats
No download links available.
DAY 4 | Sorting and filtering data | 30 Day Excel Challenge | #dataanalysis #datascience #exceltips | NatokHD