Playlist Duration

Playlist · excelisfun

How To Create Excel Invoices: Many Awesome Tricks

by excelisfun · 17 videos

Total watch time

5h 3m

at 1× speed · exactly 5 hours, 3 minutes, 18 seconds at 1×

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

The shape of the course

Each column is one video, to scale

1:04:44

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

Videos (17)

5h 3m 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 Excel & Business Math 37: Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost 36:30 2018-03-09
2 Excel & Business Math 38: Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions 1:04:44 2018-03-11
3 Excel & Business Math 39: Create Excel Invoices, Data Validation Drop-down, VLOOKUP & IF Functions 30:32 2018-03-14
4 Excel & Business Math 40: Partial Payment on Invoice with Cash Discount, Credit to Account Balance? 11:31 2018-03-15
5 Excel & Business Math 41: Markup On Cost or Markup On Sell Price? Calculate & How They Are Different 24:37 2018-03-16
6 Excel & Business Math 41: Markup On Cost or Markup On Sell Price? Calculate & How They Are Different 24:37 2018-03-16
7 Excel Magic Trick 1479: Lookup Bulk Quantity Discount Prices Using VLOOKUP Function 10:54 2018-03-16
8 Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date 13:35 2018-04-18
9 Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date 8:45 2018-04-20
10 Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date 9:32 2018-04-22
11 Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date 8:09 2018-04-26
12 Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date 8:09 2018-04-26
13 Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date 13:03 2018-04-27
14 Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date 13:03 2018-04-27
15 Excel Magic Trick 1489: 2 VLOOKUP in 1 Formula: Lookup Correct Volume Discount Product Price 8:56 2018-05-02
16 Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND 7:46 2019-05-19
17 Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643 8:55 2020-02-28
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: 5h 3m · 17 videos

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

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