Jump to key moments of ExcelIsFun Excel Magic Tricks 2

Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP
10:45
Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP
38K viewsSep 11, 2015
YouTubeexcelisfun
Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750
3:04
Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750
32.6K viewsAug 24, 2021
YouTubeexcelisfun
Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)
22:32
Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)
96.1K viewsAug 14, 2015
YouTubeexcelisfun
Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH
8:32
Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH
101.6K viewsDec 26, 2010
YouTubeexcelisfun
Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905
2:34
Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905
23.2K views8 months ago
YouTubeexcelisfun
Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629.
10:46
Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629.
24.2K viewsDec 30, 2019
YouTubeexcelisfun
Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
6:20
Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
117.5K viewsMar 6, 2009
YouTubeexcelisfun
7:54
Excel Magic Trick 1409: Build PivotTable From 2 Tables without Power Pivot or VLOOKUP
10.4K viewsApr 29, 2017
YouTubeexcelisfun
4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values
347K viewsOct 8, 2009
YouTubeexcelisfun
7:03
Excel Magic Trick 1425: Convert 2-Way Table to Single Column Table with INDEX & Number Incrementor
51.3K viewsMay 18, 2017
YouTubeexcelisfun
2:35
Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria
17.9K viewsJan 9, 2009
YouTubeexcelisfun
12:11
FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912
21.5K views6 months ago
YouTubeexcelisfun
10:10
Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916
5K views5 months ago
YouTubeexcelisfun
3:53
Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820
32.8K viewsApr 25, 2023
YouTubeexcelisfun
6:56
Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report
201.3K viewsMay 2, 2017
YouTubeexcelisfun
4:21
Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882
2.8K viewsApr 14, 2025
YouTubeexcelisfun
8:26
Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667
28K viewsMay 9, 2020
YouTubeexcelisfun
2:52
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
192.6K viewsSep 22, 2014
YouTubeexcelisfun
8:45
Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911
25.3K views7 months ago
YouTubeexcelisfun
11:05
Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria
108.8K viewsJan 9, 2009
YouTubeexcelisfun
9:49
Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values
18.4K viewsJul 20, 2018
YouTubeexcelisfun
10:04
Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula
235.8K viewsMar 30, 2012
YouTubeexcelisfun
6:27
Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List
40.2K viewsFeb 1, 2016
YouTubeexcelisfun
14:42
Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations
16.4K viewsJan 12, 2010
YouTubeexcelisfun
3:20
Excel Magic Trick 1543: MAXIFS & MINIFS to Lookup Numbers on Either Side of Hurdle
7.5K viewsFeb 16, 2019
YouTubeexcelisfun
2:42
Excel Magic Trick 1389: Average Number of Days Between Two Columns of Dates
27.3K viewsMar 7, 2017
YouTubeexcelisfun
8:04
Excel Magic Trick 255: Data Table 2 Variable What If Analysis
98.3K viewsFeb 12, 2009
YouTubeexcelisfun
5:51
Excel Magic Trick #225: 2 Way Lookup With Duplicates
33.5K viewsJan 23, 2009
YouTubeexcelisfun
10:41
Excel Magic Trick 1243: Transform GDP Data Set: Power Query 2nd Method or Advanced Filter?
9.7K viewsNov 7, 2015
YouTubeexcelisfun
See more