Excel Filter For Extracting Records with AND or OR Criteria
by
Video Lecture 36 of 50
Not yet rated
Views: 850

### Lecture Description

Topics in this video:
1. Sort to Extract Records (00:29 min)
2. Filter for extracting records. (01:02 min)
3. Filter Toggle Keyboard: Ctrl + Shift + L or Alt, D, F, F (01:24 min)
4. Single Criteria Data Extract (02:17 min)
5. Turn Off Filter: Ctrl + Shift + L, L (03:19 min)
6. 2 or more criteria or conditions: (04:00 min)
AND Criteria = All tests must get TRUE
OR Criteria = At least one test must get TRUE
7. Date Between = AND Criteria (04:27 min)
8. Product "Quad" or 'Carlota" = OR Criteria (06:10 min)
9. SalesRep "Gault" in "East" = AND Criteria (06:50 min)
10. Contains or Search "15th Lane" = 1 Condition. (07:49 min)
11. Top 5 = 1 Condition (09:05 min)
12. Filter by color (10:20 min)
13. Don't forget new Slicers for Tables (10:33 min)
14. Slicers great for Extracting records or making calculations with 1 or more conditions (12:04 min)
15. Alt + = adds Total Row (13:20 min)
16. Add New Record with Total Row (14:16 min)

### Course Description

This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.

Be sure to download the workbook to follow along with the examples. They are found on the official course website.