playlistduration

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×

1×5h 3m 18s
1.25×4h 2m 38s
1.5×3h 22m 12s
1.75×2h 53m 19s
2×2h 31m 39s
Average video17m 50s
Longest1h 4m 44s
Shortest7m 46s
Compare Open on YouTube JSON

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.

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

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