There are many ways to select data in Excel: basic and advanced filtering, range selections, pivot table filtering, date and context filtering, sorting, ranking, grouping, slicing (including timelines), creating user-defined sets, and advanced data navigation. If you want to do things faster and better in Excel, make sure you become proficient with all the different ways of selecting data by watching this in-depth, 48-minute video tutorial by Carmel Gunn, Data Specialist from Prodata, and follow her many hands-on demos.
Selecting, Filtering, and Sorting Data in Excel Purchase the entire course
Essential Enterprise BI Skills
Jump to a chapter
- Demo: Using Filters in Excel (01:57)
- Demo: Removing Filters (05:55)
- Demo: Selecting Multiple Items (07:42)
- Value Filtering (08:59)
- Date Filtering (11:56)
- Advanced Pivot Table Date Options (14:44)
- Context Filtering (15:48)
- Demo: Context Filtering and Grouping (17:03)
- Demo: Hiding Values from Lists (18:24)
- Demo: Filtering Top 10 Selling Products (19:16)
- Demo: Grouping (45:31)
- Summary (47:13)
Log in or purchase access to play the video.
Purchase a Full Access Subscription
- You can also redeem a prepaid code.
- Payments are instant and you will receive a tax invoice straight away.
- We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
- Your satisfaction is paramount: we offer a no-quibble refund guarantee.
- See pricing FAQ for more detail.
