Excel Advanced Filter Tricks — 3h 24m total, 29 videos

1×	3h 24m 3s
1.25×	2h 43m 14s
1.5×	2h 16m 2s
1.75×	1h 56m 36s
2×	1h 42m 2s

Plan to finish

About 4 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 4 days. Turn on JavaScript to plan around your week.

Videos (29)

3h 24m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.


1	Highline Excel 2016 Class 19: Transform Data Sets using Advanced Filter (8 Examples)	33:42	2016-06-04
2	Highline Excel Class 19: Advanced Filter Extract Data 9 Examples	21:25	2009-04-14
3	Excel Magic Trick 322: NOT Advanced Filter Data Extract	2:36	2009-05-09
4	Excel Magic Trick 525: Advanced Filter With Wild Cards	2:15	2010-02-24
5	Excel Magic Trick 660: Advanced Filter Unique Records Only	1:51	2010-07-17
6	Excel Magic Trick 1244: Transform GDP Data Set: Advanced Filter with Formula Criteria wins!	7:33	2015-11-14
7	Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data	8:19	2010-07-17
8	Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter	7:46	2009-01-09
9	Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria	2:35	2009-01-09
10	YTL Excel #122: Advanced Filter to a New Sheet (Formula Criteria)	5:19	2008-09-11
11	Excel Magic Trick #249: Data Extract To New Workbook using Advanced Filter	2:25	2009-02-04
12	YTLE#54: Excel Advanced Filter and COUNTIF function	3:09	2008-07-14
13	Excel Magic Trick 165p2 MACRO Advanced Filter Extract B-days	5:38	2008-12-02
14	Excel Magic Trick 165p1 MACRO Advanced Filter Extract B-days	8:22	2008-12-02
15	Excel Magic Trick #152: Extract records w Field Not Blank	3:17	2008-11-19
16	Excel Magic Trick #126: Macro: Advanced Filter Extract Text	8:51	2008-10-17
17	Excel Magic Trick #103: Pie Chart For Student Scores	4:55	2008-09-30
18	Excel Magic Trick #105: Extract Records Trick	5:10	2008-09-26
19	YTLE#106: Alternatives To Pivot Tables - Excel	9:23	2008-08-30
20	YTLE#95: Complex Advanced Filter Extract	10:07	2008-08-12
21	Excel Statistics 12: Categorical Frequency Distribution w Formulas	10:36	2008-07-25
22	YTLE#65: Merge 2 Tables: VLOOKUP & Advanced Filter	8:00	2008-07-24
23	YouTubersLoveExcel#40: Extract top 5 scores	4:21	2008-06-17
24	Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria)	2:31	2009-02-03
25	Excel Magic Trick 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature	4:27	2009-09-10
26	Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter	4:02	2010-04-27
27	Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract Unique Records & Adding W Criteria	6:21	2011-09-27
28	Extract Customer Names, Not in Master Lists with Advanced Filter - Excel Magic Trick 1598	5:06	2019-09-02
29	Advanced Filter: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1594	4:01	2019-08-25

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Markdown

[![Watch time: 3h 24m · 29 videos](https://playlistduration.com/badge/playlist/PLA6E69131CB6CD9C1.svg)](https://playlistduration.com/playlist/PLA6E69131CB6CD9C1)

HTML

<a href="https://playlistduration.com/playlist/PLA6E69131CB6CD9C1"><img src="https://playlistduration.com/badge/playlist/PLA6E69131CB6CD9C1.svg" alt="Watch time: 3h 24m · 29 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLA6E69131CB6CD9C1 returns them as JSON — free, no key. API docs →