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 speed · exactly 10 hours, 36 minutes, 52 seconds at 1×

10h 36m 52s
1.25×8h 29m 30s
1.5×7h 4m 35s
1.75×6h 3m 55s
5h 18m 26s
Average video12m 29s
Longest25m 10s
Shortest1m 55s
Compare Open on YouTube JSON

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.

Videos to
Watched
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

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-09-22 (cached). Private or deleted videos are excluded from totals.