### Excel Magic Trick 1481

DESCRIPTION In this video learn how to how to perform lookup from multiple tables. Learn two methods: 1) VLOOKUP and SWITCH Function or 2) VLOOKUP and INDIRECT Function with Defined Names. (00:01) Introduction (01:30) VLOOKUP [Read More >>>]

### Excel Magic Trick 1458

DESCRIPTION Learn how to lookup the price for PVC Pipe in three different tables using VLOOKUP and INDIRECT Function and Defines Names. Defined Names allow us to assign a Named Reference to a lookup table. [Read More >>>]

### Excel Magic Trick 1424

DESCRIPTION See how to calculate Average, Moving Average at Different Granularity in both DAX and Excel Formulas: (00:14) Introduction (00:27) What is Granularity? (02:15) Look at Data Model and Hide Columns from Client Tool (03:29) [Read More >>>]

### Highline Excel 2016 Class 10

DESCRIPTION In this video learn about: (00:16) Introduction (00:46) Data Validation to allow only whole numbers between an upper and lower limit (02:12) Create an Input Message for your Data Validation (02:31) Error Message with [Read More >>>]

### Excel Magic Trick 1316

DESCRIPTION See how to use VLOOKUP when there are multiple Lookup Tables with these methods: (00:15) Problem Set up (01:48) IF Function (05:57) IFS Function (Excel 2016 Insider Program) (Formula from XLarium at YouTube) (08:47) [Read More >>>]

### Excel Magic Trick 1313

DESCRIPTION Learn how to create an Array Formula to Create Sorted Unique List in Cell. This is a huge complicated formula that requires the Excel 2016 function TEXTJOIN. There are many interesting formula elements in [Read More >>>]

### Excel Magic Trick 1312

DESCRIPTION Learn: (00:08) Problem introduction. (00:33) How to use NETWORKDAYS.INTL to count the number of working days between a start and end date. NETWORKDAYS.INTL is in Excel 2010 or later versions. (01:46) Formula to count [Read More >>>]

### Excel Magic Trick 1301

DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. See the Functions: TEXTJOIN, INDEX, SMALL, MODE.MULT, COUNT, ROW, INDIRECT. Learn about difference (and history) between [Read More >>>]

### Excel Magic Trick 1288

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn the formula =ROW(1:LEN(A1)) does not work. See that the INDIRECT Function comes to the rescue to create a formula that does work: =ROW(INDIRECT(“1:”&LEN(A1))) Work. Alos learn about the robust [Read More >>>]

### Dueling Excel 133

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with [Read More >>>]