Playlist · TeachExcel

Excel Functions and Formulas

by TeachExcel · 51 videos

Listed in Best free Excel courses on YouTube, ranked by total hours

Total watch time

10h 37m

at 1× speed · exactly 10 hours, 36 minutes, 52 seconds at 1×

At an hour a day you'd finish in 11 days

The shape of the course

51 videos in blocks of 10 · each column is a block's total, to scale

1h 16m
2h 37m
2h 10m
2h 34m
1h 45m
14m 47s

WatchedTo watch

Compare Open on YouTube JSON

Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.

Your plan

Plan to finish

About 11 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 11 days. Turn on JavaScript to plan around your week.

Videos (51)

10h 37m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
1 Functions/Formulas in Excel 5 - Combine Text and Formulas in a Cell 6:13 2009-11-06
2 Functions/Formulas in Excel 6 - Use Round & Rand to return Random Numbers with 2 Decimal Places 1:55 2009-11-06
3 Formulas in Excel 2 - Round Numbers to Next Lowest Integer in Excel Using the INT Function 2:15 2009-11-04
4 Formulas in Excel 1 - Round Numbers in Excel with Round Function to the Nearest Decimal or Integer 5:45 2009-11-04
5 Functions/Formulas in Excel 8 - Find The Most Common/Repeated Value in a List in Excel 2:35 2009-11-09
6 Functions/Formulas in Excel 7 - Learn the IF Statement in Excel & Output Numbers, Text, and Formulas 7:43 2009-11-09
7 Functions Formulas in Excel 10 - Formula Auditing - Find Out Which Cells are Used in Your Formulas 6:59 2009-12-03
8 Functions-Formulas in Excel 9 - Highlight Cells With Formulas Without a Macro in Excel 3:53 2009-12-03
9 15 Expert SUMIFS Function Examples in Excel - Simple to Advanced - Workbook Included 16:30 2018-02-14
10 15 IF Statement Examples in Excel - Simple to Advanced - Workbook Included 21:57 2018-02-21
11 6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Included 25:10 2018-02-28
12 10 Excel Tricks to Improve Performance - Workbook Included 21:37 2018-03-07
13 5 Helpful Text Extraction Tips for Excel 23:54 2018-03-14
14 Excel Formulas Based on Cell Color - Files Included 11:35 2018-05-16
15 Count Occurrences of Unique Values in a List in Excel 11:43 2018-05-23
16 6 Must Know Text Manipulation Extraction Functions in Excel - With Examples 13:52 2020-01-21
17 Amazing 3D Formulas in Excel & How to Use Them 11:57 2020-01-28
18 Deconstruct Complex Formulas in Excel 11:05 2020-02-11
19 Calculate Work Days Between Dates Excluding Weekends and Holidays 11:59 2020-02-25
20 Delete the First/Last Word or Part from a Cell in Excel 14:13 2020-03-10
21 Vlookup on Partial Matches in Excel 14:40 2020-05-19
22 Vlookup to Return All Matches in Excel 21:15 2020-05-26
23 Regular Expression Match Formula in Excel (No VBA) - Regex System Part 1 20:00 2020-06-23
24 TEXTJOIN() Function to Combine Text in Excel - Excel Quickie 51 5:12 2020-06-25
25 Complete Excel Regular Expression Formula System (No VBA) - Regex System Part 2 21:10 2020-06-30
26 Fix Formula Errors in Excel - Old and New Method - Excel Quickie 52 3:57 2020-07-02
27 Fix Formula Errors in Excel - Old and New Method - Excel Quickie 52 3:57 2020-07-02
28 6 Ways to Remove Extra Spaces from Text in Excel 14:47 2020-07-14
29 Make Better IF Statements in Excel - Learn to Convert Complex Formulas into True False Values 13:47 2020-07-21
30 FIND() vs SEARCH() Function in Excel 11:41 2020-07-28
31 Power Sorting in Excel with SORTBY() - New Excel 365 Function to Sort Data 17:13 2020-08-04
32 FILTER Function in Excel - The Power Lookup for the Future! 20:40 2020-08-11
33 UNIQUE() Function for Excel 365 - Remove Duplicates Using Formulas 15:34 2020-08-25
34 NOT() Function in Excel - Reversing True/False - Excel Quickie 61 3:04 2020-09-03
35 IF() Statement in Excel 24:03 2020-09-08
36 Excel Formula Formatting Trick to Make Life Much Easier - Excel Quickie 62 5:01 2020-09-10
37 How to Use Dates in Excel - 10 Things You Must Know 14:58 2020-11-03
38 ULTIMATE Data Cleaning Formula for Excel - File Included 17:19 2020-12-08
39 Generate a Unique List of Random Numbers in Excel With a Simple Formula 12:51 2021-01-26
40 5 Powerful Techniques for Building Advanced Formulas in Excel 22:59 2021-02-02
41 VLOOKUP() Using Macros in Excel - Worksheet Functions for VBA 9:45 2021-02-09
42 SWITCH() Function in Excel and 3 Alternatives 9:04 2021-04-13
43 ARRAYTOTEXT() Function Excel - 5 Practical Examples 10:23 2021-04-27
44 Compare Values in Excel (5 Ways) - Beginner to Advanced 14:30 2021-05-04
45 How to use the CONVERT Function in Excel 11:45 2021-07-27
46 Count Visible Rows in a Filtered List in Excel - EQ 99 3:04 2021-10-07
47 Dynamic Excel Formulas Made Easy - 2 Methods 8:03 2021-12-14
48 Clickable Email Links & Buttons in Excel 14:50 2022-03-08
49 Make Custom Excel Functions Using AI (Everyone can do it now) 7:02 2025-09-03
50 I don't use VLOOKUP or XLOOKUP in Excel anymore, I do this instead 16:41 2026-06-23
51 This Might Be the Coolest Excel Trick I’ve Found 14:47 2026-08-04
For your README

Embed a badge

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

Watch time: 10h 37m · 51 videos

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

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