Excel Formulas - Basics and Beyond

by excelisfun · 48 videos (1 unavailable)

Total watch time

15h 45m

at speed · exactly 15 hours, 44 minutes, 41 seconds at 1×

15h 44m 41s
1.25×12h 35m 45s
1.5×10h 29m 47s
1.75×8h 59m 49s
7h 52m 21s
Average video19m 41s
Longest1h 23m 2s
Shortest59s
Compare Open on YouTube JSON

Plan to finish

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

Videos (49)

15h 45m in total · tick what you've watched

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

Videos to
Watched
1 Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples 43:24 2017-11-02
2 Excel & Business Math 03: Excel's Golden Rule: Formula Inputs, What If Analysis and Excel Models 30:10 2017-12-29
3 Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!! 54:08 2017-11-05
4 Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier! 40:08 2017-11-08
5 Excel & Business Math 06: All About Excel Formulas (17 Examples) for Business Math Class 47:07 2018-01-06
6 Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!! 45:08 2017-11-12
7 Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria 35:16 2017-11-16
8 Highline Excel 2016 Class 02: Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) 55:03 2016-04-09
9 Highline Excel 2013 Class Video 02: Comprehensive Excel Formula Types & Elements Video 12 Examples 33:55 2013-10-02
10 Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel 15:23 2013-10-02
11 Highline Excel 2013 Class Video 07: Worksheet & Workbook References, 3-D Cell References 11:21 2013-10-04
12 Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models 17:17 2015-10-02
13 Highline Excel 2013 Class Video 09: Defined Names & Aggregate Functions 13:15 2013-10-17
14 Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex. 25:47 2013-10-04
15 Highline Excel 2013 Class Video 14: AND, OR, IF Functions For AR Dept (Multiple Logical Tests) 13:37 2013-10-12
16 Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs 26:17 2013-10-12
17 Highline Excel 2013 Class Video 16: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more... 8:34 2013-10-12
18 Highline Excel 2013 Class Video 17: Introduction To SUMPRODUCT Function 10:02 2013-10-12
19 Highline Excel 2013 Class Video 18: VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP 42:00 2013-10-19
20 Office 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/Conditions 24:31 2013-11-04
21 Highline Excel 2013 Class Video 32: Introduction To Array Formulas and Array Functions 34:06 2013-11-09
22 Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples) 37:12 2013-10-03
23 Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons 1:23:02 2016-05-07
24 Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more! 36:47 2017-11-09
25 Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629. 10:46 2019-12-30
26 Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636 5:32 2020-01-14
27 Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634 17:24 2020-01-23
28 OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645 6:35 2020-03-11
29 Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683. 7:59 2020-08-17
30 Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708. 5:15 2020-12-14
31 Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715 2:02 2021-01-11
32 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716 4:52 2021-01-13
33 Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722 5:06 2021-02-08
34 Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727. 5:34 2021-03-01
35 Private video
36 Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731 6:10 2021-03-30
37 Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741 2:43 2021-06-22
38 Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742 11:38 2021-06-29
39 OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743 10:33 2021-07-06
40 Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751 4:43 2021-08-31
41 Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753 1:58 2021-09-13
42 VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758 5:26 2021-10-05
43 Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764 10:14 2021-11-01
44 Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800 3:52 2022-10-13
45 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805 8:06 2022-11-29
46 Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810 4:00 2023-01-05
47 Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts 3:38 2023-01-19
48 Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts 0:59 2023-01-26
49 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819 16:06 2023-02-26

Embed a badge

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

Watch time: 15h 45m · 48 videos

Markdown
[![Watch time: 15h 45m · 48 videos](https://playlistduration.com/badge/playlist/PL39FDB9CDC5760C6A.svg)](https://playlistduration.com/playlist/PL39FDB9CDC5760C6A)
HTML
<a href="https://playlistduration.com/playlist/PL39FDB9CDC5760C6A"><img src="https://playlistduration.com/badge/playlist/PL39FDB9CDC5760C6A.svg" alt="Watch time: 15h 45m · 48 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/PL39FDB9CDC5760C6A 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.