This video demonstrates three Microsoft Excel filter exercises:
1 - Warm-up with the Filter command and the right-click shortcut
2 - Filtering with Tables, and using the Total row to get the subtotal of visible rows
3 - Write a formula with the FILTER function to retrieve a copy of a subset of rows from the data table
Chapters in this video:
00:00 - Introduction
00:18 - Warm-up
01:51 - Total Row
02:46 - Formula
Watch the previous video: Excel IF Function (including multiple conditions) https://youtu.be/Sl9h-FprAVE
Learn Excel the FAST way, find out how here 👉 https://www.excel-university.com/challenge
Subscribe here 👉 youtube.com/@UCTVwsjWbfs2UjxfvX5OHhaw
and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!