1
Ctrl + Shift + Enter: Excel Array Formulas 13: Dynamic Ranges: INDEX & OFFSET Functions
1:00:22
2014-01-23
2
Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names
9:45
2010-04-30
3
Excel Dynamic Chart #12: INDEX function as Alternative to OFFSET function for Dynamic Ranges
9:15
2009-12-16
4
Ctrl + Shift + Enter: Excel Array Formulas 13: Dynamic Ranges: INDEX & OFFSET Functions
1:00:22
2014-01-23
5
Highline Excel Class 15: Excel 2007 Tables 7 Examples
10:49
2009-04-14
6
Excel Magic Trick #230: Dynamic Stock Chart Excel Table List
4:57
2009-01-28
7
Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?
10:58
2010-03-12
8
Excel Magic Trick #215: Dynamic Print Range
7:24
2009-01-20
9
Mr Excel & excelisfun Trick 34: Dynamic Range for Adding Three Methods
7:23
2009-10-30
10
Excel Magic Trick 678: SUM only Values After Deadline Dynamic Range using INDEX Function.
6:08
2010-07-28
11
Excel Magic Trick 647: Dynamic Line Chart For Cash Balance using OFFSET function
13:15
2010-07-14
12
Excel Dynamic Chart #9: 4 Week Chart Dynamic Formula & Dynamic Data Validation Formula
10:41
2009-12-11
13
Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function
3:53
2009-10-26
14
Excel Magic Trick #240: Dynamic Range New Data At Top
7:31
2009-02-02
15
Excel Magic Trick #135: Find Last Row & Column Dynamic Range
6:38
2008-10-28
16
YTLE#105: Excel OFFSET for Dynamic Range in Function
8:49
2008-08-30
17
YTLE#58: Data Validation & Excel 2007 Tables
3:15
2008-07-18
18
Excel Magic Trick #200: Excel Table Formula Nomenclature
9:18
2009-01-09
19
Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together
10:29
2011-03-30
20
Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Feature
9:03
2011-04-08
21
Mr Excel & excelisfun Trick 75: Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX?
9:41
2011-04-15
22
Excel Magic Trick 856: Last 5 Values In Column: Formulas For Adding, Averaging and Extracting Data
8:45
2012-01-14
23
Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables
5:39
2011-02-05
24
Mr Excel & excelisfun Trick 124: Dynamic Stacked Line Chart
8:56
2013-05-17
25
Excel Magic Trick 1037: Make Table Reference Absolute by Copying And Pasting Instead Of Dragging
3:16
2013-08-09
26
Excel Magic Trick 1038: Make Table Reference Absolute With Colon and Double Square Brackets
4:26
2013-08-09
27
Excel Magic Trick 1041: Expandable Range In An Excel Table For Running Total (Zack Barresse's Trick)
3:03
2013-08-14
28
Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex.
25:47
2013-10-04
29
Excel Magic Trick 1091: Count Number of Items In Row For First Occurrence of Each Group
9:07
2014-04-01
30
Excel Magic Trick 1117: Calculate Average For Each Sample: AVERAGEIFS, PivotTable, or OFFSET
11:03
2014-05-23
31
Excel Magic Trick 1127: Automatically Track Budget Start, Change & Ending Balances In Excel
18:14
2014-07-04
32
Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?
5:58
2015-04-24
33
Excel Magic Trick 1117: Calculate Average For Each Sample: AVERAGEIFS, PivotTable, or OFFSET
11:03
2014-05-23
34
Excel Magic Trick 1071: Dynamic Range Based on Product and Start & End Month: OFFSET, INDEX or AF?
21:59
2014-02-15
35
Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function
5:38
2015-08-29
36
Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail
25:46
2016-01-05
37
Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Table
14:45
2016-03-13
38
Excel Magic Trick 1370 INDEX Function & Number Incrementor Extract Items & Display In Every 3rd Cell
9:27
2017-01-19
39
Excel Magic Trick 1371: Excel Formula To Add Last Five Values in an Excel Table: INDEX Dynamic Range
7:28
2017-01-22
40
Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function
7:05
2017-01-29
41
Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More
18:52
2017-02-09
42
Excel Magic Trick 1431: XNPV, OFFSET & VLOOKUP to Get Dates & Cash Flows for NPV & IRR Calculations
13:37
2017-05-22
43
Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553
31:16
2019-06-07
44
OFFSET Function Dynamic Range inside COUNTIFS Function - Excel Magic Trick 1573
4:40
2019-07-24
45
INDEX Function To Lookup Column inside COUNTIFS Function - Excel Magic Trick 1574
2:52
2019-07-24
46
Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631.
9:00
2020-01-03
47
Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650.
5:03
2020-03-22
48
Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651
4:17
2020-03-23
49
Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652
5:42
2020-03-24
50
Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653
3:33
2020-03-25
51
INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654
4:31
2020-03-26
52
Excel Music Video: UNSTOPPABLE Office 365 Excel. Old School Formulas v. New School Formulas EMT 1655
3:09
2020-03-27
53
Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661
8:18
2020-04-23
