playlistduration

Ctrl+Shift+Enter: Mastering Excel Array Formulas (35+ Videos in Series)

by excelisfun · 65 videos

Total watch time

18h 39m

at 1× speed · exactly 18 hours, 38 minutes, 32 seconds at 1×

1×18h 38m 32s
1.25×14h 54m 50s
1.5×12h 25m 41s
1.75×10h 39m 10s
2×9h 19m 16s
Average video17m 12s
Longest1h 20m 51s
Shortest2m 2s
Compare Open on YouTube JSON

Plan to finish

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

Videos (65)

18h 39m in total · tick what you've watched

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

Videos to
Watched
1 Ctrl + Shift + Enter: Excel Array Formulas #00: Intro To DVD and Video Series 7:34 2013-12-30
2 Ctrl + Shift + Enter: Excel Array Formulas #04: Join Array Operation & Alternatives Such as DGET 14:43 2014-01-05
3 Ctrl + Shift + Enter: Excel Array Formulas #05: Function Argument Array Operations 8:21 2014-01-09
4 Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples) 59:26 2013-12-30
5 Ctrl + Shift + Enter: Excel Array Formulas #02: Introduction Array Formulas & Math Array Operation 19:18 2014-01-01
6 Ctrl + Shift + Enter: Excel Array Formulas #03: Comparative Array Operations, & Alternatives 14:50 2014-01-04
7 Ctrl + Shift + Enter: Excel Array Formulas #04.5: Join Array Operation or SUMIFS Function? 4:18 2014-01-08
8 Ctrl + Shift + Enter: Excel Array Formulas #06: Array Constants in Top 3 Formula, VLOOKUP, more 16:54 2014-01-11
9 Ctrl + Shift + Enter: Excel Array Formulas #07: Introduction To Array Functions. TRANSPOSE Function 9:10 2014-01-12
10 Ctrl + Shift + Enter: Excel Array Formulas 08: Array Formula: Multiple Values To Multiple Cells 6:47 2014-01-15
11 Ctrl + Shift + Enter: Excel Array Formulas 09: SUMPRODUCT Function: 21 Examples, Including Timing 45:17 2014-01-16
12 Ctrl + Shift + Enter: Excel Array Formulas 10: LOOKUP Function: Array Operations wOut CtrlShiftEnter 17:02 2014-01-18
13 Ctrl + Shift + Enter: Excel Array Formulas 11: AGGREGATE, INDEX, LOOKUP, SUMPRODUCT 19:46 2014-01-19
14 Ctrl + Shift + Enter: Excel Array Formulas 12: SUMIFS, COUNTIFS, SUMIF, COUNTIF, AVERAGEIF 12:27 2014-01-21
15 Ctrl + Shift + Enter: Excel Array Formulas 13: Dynamic Ranges: INDEX & OFFSET Functions 1:00:22 2014-01-23
16 Ctrl + Shift + Enter: Excel Array Formulas 14: Boolean Logic, AND & OR criteria, Convert TRUE FALSE 27:16 2014-01-28
17 Excel Magic Trick 1015: Counting With OR Criteria: SUMPRODUCT & COUNTIF Formula from pmsocho 5:55 2013-07-13
18 Ctrl + Shift + Enter: Excel Array Formulas 15: General Guidelines For Array Formulas 2:02 2014-01-29
19 Ctrl + Shift + Enter: Excel Array Formulas 16: Formulas To Extract Records With Criteria 23 examples 1:14:12 2014-01-29
20 Ctrl + Shift + Enter: Excel Array Formulas 17: FREQUENCY Array Function Basics 11:50 2014-02-04
21 Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function? 41:18 2014-02-04
22 Ctrl + Shift + Enter: Excel Array Formulas 19: Array Function: MMULT 24:18 2014-02-10
23 Ctrl + Shift + Enter: Excel Array Formulas 20: Extract Unique Lists & Sorting Formulas 54:46 2014-02-13
24 Excel Magic Trick 1071: Dynamic Range Based on Product and Start & End Month: OFFSET, INDEX or AF? 21:59 2014-02-15
25 Ctrl + Shift + Enter: Excel Array Formulas 21: Conditional Formatting with Array Formulas 16:02 2014-02-19
26 Ctrl + Shift + Enter: Excel Array Formulas 22: Excel 2010 Array Function: MODE.MULT 9:31 2014-02-21
27 Ctrl + Shift + Enter: Excel Array Formulas 23: LINEST Array Function 12:32 2014-02-23
28 Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL 22:03 2014-02-23
29 Ctrl + Shift + Enter: Excel Array Formulas Video # 24: 26 Amazing Array Formulas 1:20:51 2014-03-04
30 Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text) 12:53 2014-03-16
31 Excel Magic Trick 1100: Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication? 14:11 2014-04-17
32 Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together 9:49 2014-07-30
33 Excel Magic Trick 1042 Array Functions Housed In Other Functions Usually Don't Need Ctrl Shift Enter 7:37 2013-08-14
34 Excel 2013 PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data 8:21 2014-11-15
35 Excel Magic Trick 1153: Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… 10:25 2014-11-20
36 Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function 8:53 2015-07-24
37 Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) 22:32 2015-08-14
38 Excel Magic Trick 1254: Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula? 8:55 2016-01-13
39 Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score 6:24 2016-03-18
40 Excel Magic Trick 1294: Single Cell "Lookup Adding" w Improper Data Set to Score Myers-Briggs Test 7:10 2016-03-19
41 Excel Magic Trick 1304: List Text Modes in Single Cell TEXTJOIN, INDEX, N, IF, MATCH & MODE.MULT 6:14 2016-07-15
42 Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trick 7:12 2016-07-17
43 Excel Magic Trick 1306: Simulate VLOOKUP Helper Column In Array Formula using T(IF({1},Array) Trick 10:40 2016-07-17
44 Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups 18:09 2017-07-02
45 Excel Magic Trick 1452: Max Monthly Customer Total for Year: Array Formula or PivotTable? 16:56 2017-08-06
46 Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month 13:46 2017-08-09
47 Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month 10:30 2017-08-11
48 Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month 10:30 2017-08-11
49 Excel Magic Trick 1482: SUMPRODUCT, DCOUNTA or SUM & IF for Counting with OR Logical Test 20:12 2018-04-04
50 Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) 39:40 2018-10-20
51 Excel Dynamic Arrays: Backward Compatibility? Forward Compatibility? What Happens? EMT 1519 6:18 2018-10-23
52 Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518 7:44 2018-10-23
53 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520 9:16 2018-10-24
54 Excel Dynamic Array UNIQUE with INDIRECT To Extract Unique Lists for Each Column (EMT 1522) 4:05 2018-10-26
55 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528 13:02 2018-10-28
56 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
57 Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523 4:46 2018-11-01
58 Dynamic Spilled Arrays: Show All Formulas For All Columns in Cells as Auditing Trail EMT 1524 4:51 2018-11-02
59 Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526) 7:29 2018-11-05
60 Excel Dynamic Arrays & Charts: Spilled Arrays in Charts with Defined Names (Excel Magic Trick 1527) 5:12 2018-11-06
61 Excel Dynamic Arrays & Charts: Spilled Arrays in Charts with Defined Names (Excel Magic Trick 1527) 5:12 2018-11-06
62 Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529) 17:03 2018-11-07
63 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530) 12:31 2018-11-09
64 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530) 12:31 2018-11-09
65 Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531) 6:46 2018-11-11

Embed a badge

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

Watch time: 18h 39m · 65 videos

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