Highline Excel 2013 Class Video 36

Excel Filter For Extracting Records with AND or OR Criteria

DESCRIPTION

Topics in this video:
1. Sort to Extract Records.
2. Filter for extracting records.
3. Filter Toggle Keyboard: Ctrl + Shift + L or Alt, D, F, F.
4. Single Criteria Data Extract.
5. Turn Off Filter: Ctrl + Shift + L, L.
6. 2 or more criteria or conditions:
AND Criteria = All tests must get TRUE
OR Criteria = At least one test must get TRUE
7. Date Between = AND Criteria.
8. Product “Quad” or ‘Carlota” = OR Criteria.
9. SalesRep “Gault” in “East” = AND Criteria.
10. Contains or Search “15th Lane” = 1 Condition.
11. Top 5 = 1 Condition.
12. Filter by colour.
13. Don’t forget new Slicers for Tables.
14. Slicers great for Extracting records or making calculations with 1 or more conditions.
15. Alt + = adds Total Row.
16. Add New Record with Total Row.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 252 times – 21 MB




Be the first to comment

Leave a Reply