Data Analysis & Manipulation

by TeachExcel · 130 videos

Total watch time

1d 6h 26m

at speed · exactly 1 day, 6 hours, 25 minutes, 37 seconds at 1×

1d 6h 25m 37s
1.25×1d 20m 30s
1.5×20h 17m 5s
1.75×17h 23m 13s
15h 12m 49s
Average video14m 3s
Longest38m 17s
Shortest58s
Compare Open on YouTube JSON

Plan to finish

About 31 days at an hour a day

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

Days

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

Videos (130)

1d 6h 26m in total · tick what you've watched

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

Videos to
Watched
1 Excel Data Analysis 1 - Move Data from Rows to Columns - Transpose Data in Excel 3:15 2009-11-02
2 Excel Data Analysis 2 - Import CSV Files into Excel 5:28 2009-10-30
3 Excel Tips 18 - Quickly Sort Data Alphabetically and Numerically in Excel 2007 1:57 2009-11-04
4 Data Analysis in Excel 7 - Quickly Import XML Files and Data into Excel 6:27 2009-11-13
5 Data Analysis in Excel 6 - Fix Broken Links in Excel and Check Data Connections to Other Files 5:09 2009-11-13
6 Data Analysis in Excel 5 - Remove Duplicate Entries from Data Sets in Excel 7:16 2009-11-12
7 Data Analysis in Excel 4 - Sort Large Data Sets to Display Ordered Information 7:23 2009-11-12
8 Data Analysis in Excel 3 - Filter Large Data Sets to Display Only Specific Information 8:05 2009-11-12
9 Data Analysis in Excel 9 - Filter Data Based on The Frist, Last, or Middle Values in a Cell in Excel 8:01 2009-11-13
10 Data Analysis in Excel 8 - Import XML Maps and Pull Selected Columns Values into Excel 5:47 2009-11-13
11 15 Expert SUMIFS Function Examples in Excel - Simple to Advanced - Workbook Included 16:30 2018-02-14
12 5 Helpful Text Extraction Tips for Excel 23:54 2018-03-14
13 5 Data Validation Tricks - Workbook Included 19:12 2018-04-11
14 4 Easy Ways in Excel to Convert Numbers Stored as Text to Numbers - Workbook Included 11:26 2018-04-25
15 Count Occurrences of Unique Values in a List in Excel 11:43 2018-05-23
16 6 Tricks to Make Dates Work 17:58 2018-06-06
17 Get the Last Result from a List in Excel - Multiple Examples 24:26 2018-06-12
18 Automatically Timestamp Data Entries in Excel 16:44 2018-06-26
19 Edit Multiple Worksheets at Once in Excel 11:21 2018-07-31
20 Auto Update Charts in Excel 14:33 2018-08-07
21 4 Tricks for Linking Workbooks in Excel 21:54 2018-08-28
22 Master Stock Chart in Excel - Part 1 (6 Expert Chart Techniques) 25:01 2018-09-11
23 Master Stock Chart in Excel - Part 2 (6 Expert Chart Techniques) 25:17 2018-09-18
24 Searchable Lists in Excel - Easy Method 26:15 2018-09-25
25 Fast Search Entire Excel Workbook & Return All Results into a Dashboard 38:17 2018-10-02
26 Fast Excel Search on Multiple Workbooks - VBA Macros 25:45 2018-10-09
27 Fast Search Multiple Excel Workbooks using a File Picker Window 21:40 2018-10-16
28 Convert Excel Dates into Text - Includes ST ND RD TH Endings 14:33 2019-04-30
29 SUM/COUNT/IF Cells Based on Color in Excel - Includes Conditional Formatting 18:52 2019-05-07
30 Transpose Every X Number of Rows in Excel with a Macro - Advanced Transpose Technique 23:18 2019-05-21
31 Simple Excel Function to Extract Any Word from a Cell - UDF 14:03 2019-05-28
32 Simple Excel Function to Combine Values in ALL Versions of Excel - UDF 35:03 2019-06-04
33 Easy Excel Formulas Every N Rows - No Arrays! 20:56 2019-06-11
34 3 Simple Tips to Quickly Master Complex Spreadsheets in Excel 13:53 2019-06-18
35 Ignore Zeros in Excel Functions MIN() and Others 12:28 2019-06-25
36 Filter Data as you Type in Excel 25:21 2019-07-02
37 Vlookup to Return 1st, 2nd, 3rd, Nth Matches from a List in Excel 25:15 2019-07-16
38 5 Awesome Tips to Save Time Working with Huge Worksheets in Excel 25:17 2019-07-30
39 Send Emails from Excel - Automatically and Manually (Macro & Non-Macro Solution) 17:42 2019-08-06
40 Extract Text Before or After the 1st, 2nd, 3rd, Nth Delimiter in Excel 14:50 2019-08-13
41 7 Ways to Convert Excel Month Names to Numbers and Numbers to Names 16:24 2019-08-20
42 Learn Advanced Data Filter Techniques in Excel 17:29 2019-09-03
43 Data Sensitivity Analysis in Excel - What If Data Tables 18:08 2019-10-22
44 Advanced Decision Making using CHOOSE in #Excel 13:38 2019-10-29
45 #Excel Exclude Cells that are Filtered, Hidden or Grouped from Formulas 15:25 2019-11-05
46 Advanced Worksheet Controls in #Excel using a Checkbox 12:49 2019-11-12
47 Link Form Controls with Cells on Protected Worksheets without VBA Macros in Excel 10:15 2019-11-26
48 6 Must Know Text Manipulation Extraction Functions in Excel - With Examples 13:52 2020-01-21
49 Calculate Work Days Between Dates Excluding Weekends and Holidays 11:59 2020-02-25
50 Delete the First/Last Word or Part from a Cell in Excel 14:13 2020-03-10
51 Coronavirus Covid 19 Stats Analysis in Excel 15:19 2020-03-17
52 Analyze Dynamically Sized Data Sets in Excel 20:20 2020-03-24
53 Goal Seek in Excel - 2 Methods - Automated and By Hand 11:18 2020-04-14
54 Build Professional Forms in Excel - Data Entry Professional 13:49 2020-04-28
55 Reverse FIND Formula in Excel - Get Words from the End of a Cell 13:45 2020-05-05
56 IFS() Function Excel - Easy Nested IF Statements in Excel 13:48 2020-05-12
57 IFS() Function Excel - Easy Nested IF Statements in Excel 13:48 2020-05-12
58 Vlookup on Partial Matches in Excel 14:40 2020-05-19
59 Vlookup to Return All Matches in Excel 21:15 2020-05-26
60 Wildcard Vlookup to Return All Partial Matches in Excel 26:34 2020-06-02
61 Data Validation in Excel - A Guide 20:53 2020-06-16
62 Complete Excel Regular Expression Formula System (No VBA) - Regex System Part 2 21:10 2020-06-30
63 Guide to Making Drop Down List Menus in Excel 14:11 2020-07-07
64 6 Ways to Remove Extra Spaces from Text in Excel 14:47 2020-07-14
65 Power Sorting in Excel with SORTBY() - New Excel 365 Function to Sort Data 17:13 2020-08-04
66 FILTER Function in Excel - The Power Lookup for the Future! 20:40 2020-08-11
67 UNIQUE() Function for Excel 365 - Remove Duplicates Using Formulas 15:34 2020-08-25
68 Advanced Excel Analysis Tip: Highlight Sort and Group the Top / Bottom Performers in a List in Excel 20:24 2020-09-01
69 Delete Duplicate Values in All Versions of Excel 13:14 2020-09-15
70 CLEAN() Function in Excel - Excel Quickie 63 5:40 2020-09-17
71 Remove Hidden CHAR(160) Spaces from Excel 10:34 2020-09-22
72 Easily Tab/Enter Through Input Forms in Excel - Faster/Better Forms in Excel 13:43 2020-09-29
73 Apply Conditional Formatting to Multiple Cells with a Single Formula in Excel 16:28 2020-10-06
74 4 Ways to Combine Values from Multiple Cells in Excel 14:58 2020-10-27
75 How to Use Dates in Excel - 10 Things You Must Know 14:58 2020-11-03
76 ULTIMATE Data Cleaning Formula for Excel - File Included 17:19 2020-12-08
77 Elegant Date and Location Filtering in Excel - A Must See! 14:39 2020-12-15
78 Generate a Unique List of Random Numbers in Excel With a Simple Formula 12:51 2021-01-26
79 5 Powerful Techniques for Building Advanced Formulas in Excel 22:59 2021-02-02
80 Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers 21:19 2021-02-23
81 Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface 26:47 2021-03-16
82 Excel Web Import Data Copy/Paste + Easy Analysis 17:41 2021-03-23
83 3 Slicer Tricks for Pivot Tables in Excel 10:30 2021-03-30
84 FILTER in Excel - Limit, Sort, & Rank 11:04 2021-05-25
85 Custom Data Views Controlled by a Drop Down Menu in Excel 16:13 2021-06-01
86 Reuse Pivot Table Filters in Row, Column, & Value Fields 9:14 2021-06-15
87 Ignore Blanks in Data Validation Lists in Excel 10:39 2021-08-03
88 4 Simple Tricks to Make Data Easy to Understand Visually 9:22 2022-11-08
89 Simple Data Input Form for Tables in Excel - No VBA Required 14:37 2022-11-15
90 Highlightable Tables in Excel (EASY) 3:30 2023-02-28
91 Split & Combine Text Using Flash Fill in Excel 1:50 2023-05-02
92 Quickly Consolidate and Compare Data in Excel Using a Pivot Chart & Pivot Table 0:58 2023-05-09
93 Join Parts of a List With a Single Formula in Excel - (1 Minute Tutorials) 1:11 2023-05-16
94 Stop Excel Transformations of Imported Data (2 Simple Tips) 2:41 2023-06-27
95 Connect to MySQL from Excel (Complete Guide) 4:49 2023-07-11
96 Custom Threshold Highlighting Trick in Excel 10:04 2023-09-12
97 Advanced Duplicate Delete in Excel 6:43 2023-09-19
98 How to Build a Simple Navigation Dashboard in Excel 8:35 2023-09-26
99 Monitor Data in Excel without VBA/Macros 14:57 2023-10-03
100 Make Threshold Alert Popups in Excel - Easy Version 4:29 2023-10-10
101 5 Pro Tips for Tables in Excel 6:59 2023-10-24
102 Helper Slicer Visual Analysis Trick for Excel 6:02 2023-10-31
103 Custom Sort in Excel (The Easy Way) 2:47 2023-12-05
104 Streamline Repetitive Tasks in Excel with AI - The 10 Minute Guide #chatgpt 10:43 2024-12-18
105 Automate Data Entry in Excel with AI and VBA 12:12 2025-01-21
106 Excel Heatmap (Advanced Version) - Big Data Analysis 9:14 2025-02-26
107 Heatmap in #Excel with this #ExcelTips Tutorial #teachexcel 1:26 2025-03-04
108 Make Dynamic Visually Appealing Data Analysis in Excel 10:50 2025-03-05
109 Advanced Filtering in Excel Made Easy (Real World Examples) 8:47 2025-04-09
110 5 Simple Ways to Remove Duplicates in Excel (Complete Guide) 8:03 2025-05-08
111 How to Combine Multiple Tables of Data in Excel Dynamically (Easy Way) 4:38 2025-05-14
112 4 Simple Ways to Translate Excel Workbooks (Complete Guide) 9:57 2025-06-05
113 Your Simple AI Prompt for Data Analysis and Chart Creation in Excel 7:03 2025-08-14
114 Excel's Hidden CALC Trick 6:04 2026-02-10
115 Excel’s Hidden Ctrl + J Trick (Almost Nobody Knows This) 14:39 2026-03-03
116 Excel’s Secret Watch Window (Most Users Don’t Know This) 13:04 2026-03-10
117 Is VBA Dead… or More Important Than Ever (Because of AI)? 10:22 2026-04-07
118 Excel’s Secret Search Feature (Almost Nobody Knows This) 11:41 2026-04-21
119 Excel's Hidden Input Form (Almost Nobody Knows About This) 10:49 2026-04-28
120 Just Drop a File... Excel Does the Rest 18:55 2026-05-05
121 After This, You’ll Never Clean Excel Data Manually Again 23:07 2026-05-12
122 I don't create dashboards by hand anymore in Excel, I do this instead 15:52 2026-06-02
123 I don't use Pivot Tables in Excel anymore, I do this instead 21:11 2026-06-16
124 I don't use VLOOKUP or XLOOKUP in Excel anymore, I do this instead 16:41 2026-06-23
125 This might be the best new function in Excel 8:59 2026-07-28
126 This Might Be the Coolest Excel Trick I’ve Found 14:47 2026-08-04
127 I Didn’t Know Excel Could Do This 8:39 2026-08-11
128 I Didn’t Know Excel Could Do This 10:44 2026-08-18
129 This Hidden Excel Trick Blew My mind 18:00 2026-09-01
130 A New Kind of Worksheet in Excel? 12:51 2026-09-15

Embed a badge

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

Watch time: 1d 6h 26m · 130 videos

Markdown
[![Watch time: 1d 6h 26m · 130 videos](https://playlistduration.com/badge/playlist/PLF826F5FD5EF54B45.svg)](https://playlistduration.com/playlist/PLF826F5FD5EF54B45)
HTML
<a href="https://playlistduration.com/playlist/PLF826F5FD5EF54B45"><img src="https://playlistduration.com/badge/playlist/PLF826F5FD5EF54B45.svg" alt="Watch time: 1d 6h 26m · 130 videos" width="228" 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/PLF826F5FD5EF54B45 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.