## Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too

About this tutorial: Video duration: 11:39 Download Files: Start Excel File: Entire page with all Excel Files for All Videos: about how to 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. 1) (00:01) […]

## Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array).

About this tutorial: Video duration: 5:46 Download Excel Start Files: Entire page with all Excel Files for All Videos: In this video learn how to extract sales records based by day with a formula. Learn about the New Office 365 Dynamic Array Functions: FILTER, SORT and UNIQUE. Compare and contrast this new method to the […]

## How to Add Text to Excel numerical value – Combine text with number

About this tutorial: Video duration: 1:26 If we have a cell with the result of a function or a formula, it would be useful sometimes to add an explanatory text besides the value. In this Lecture we discuss an easy trick to add text to a number. Subscribe to my Channel ► ────────────────────────────────────────────────────────── Check Out […]

## Excel Magic Trick 1504: Lookup Cell Address: 4 Examples: MATCH, ADDRESS, CELL function?

About this tutorial: Video duration: 6:23 Download Excel File: Entire page with all Excel Files for All Videos: In this video see 4 different formulas to lookup a cell reference. Topics: 1. (00:06) Introduction 2. (00:33) Formula #1: MATCH Function 3. (01:55) Formula #2: ADDRESS Function with MATCH & COLUMN Functions 4. (03:08) Formula #3: […]

## Excel For Noobs Part 56: Insert Function & Function Arguments Dialog Box Excel 2016 2013

About this tutorial: Video duration: 4:48 In this Excel tutorial for beginners I show you how to use the insert functions dialog box and the function arguments dialog box. Microsoft Excel 2016, Excel 2016, Excel 2016 Tutorial, Microsoft Excel 2016 Tutorial

## Excel Union Operator For Aggregate, Statistical & Finance Functions – Excel Magic Trick 1569

About this tutorial: Video duration: 2:40 Download Excel File: In this video learn about how to use the Union Operator in standard Aggregate functions, like SUM and AVERAGE and how to use it inside of parentheses inside Statistical and Finance Functions. Related Videos: Excel Union Operator For Aggregate, Statistical & Finance Functions – Excel Magic […]

## Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula?

About this tutorial: Video duration: 5:26 Download Excel File: Entire page with all Excel Files for All Videos: In this video see how to count values that are greater than a hurdle when the values in in noncontiguous cells (cells not next to each other). See an Array Formula that uses SUMPRODUCT and CHOOSE and […]

## Dynamic Array & Old Array Formulas to Create Student Classes Report – Excel Magic Trick 1608

About this tutorial: Video duration: 7:48 Download Excel File: Learn how to create a report that shows each student by quarter with a list of classes in a single cell. See many of the new Excel 365 Functions like: SORTBY, UNIQUE, FILTER, TEXTJOIN and the ROWS Function. See how we can combine Spilled Arrays formulas […]

## Excel Magic Trick 1069: Displaying Decimal and Fractional Inches in Excel: 1/3" or 2.5" or 2 1/3"

About this tutorial: Video duration: 4:6 Download Excel File: Back Slash in Custom Number Formatting to Insert a character into the Custom Number Formatting. See how to use Custom Number Formatting to display inches in Excel: 1. =1/3 with CNF: ?/?” shows: 1/3″ 2. =1/3 with CNF: ?/?” ‘ ‘ ” shows: 1/3″ 3. =1/3 […]

## Excel Magic Trick 1279: New Running Count Formula After Each Zero Value (Cumulative Count)

About this tutorial: Video duration: 2:15 Download File: Learn how to create a New Running Count (Cumulative Count) Formula After Each Zero Value using the IF and SUM functions. Trick from Bill Szysz at YouTube. See that the SUM Function ignores Text Values.

## Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values

About this tutorial: Video duration: 9:49 Download Files: Entire page with all Excel Files for All Videos: In this video see how to color a row with conditional formatting using an Array Formula & the MATCH Function that will lookup Two Lookup Values in a corresponding Table.

## Excel Tricks : Easy Technique To Replace Vlookup With Index and Match Functions || dptutorials

About this tutorial: Video duration: 4:2 Are you still using Vlookup? This Microsoft Excel tutorial will teach you how to use the INDEX and MATCH functions, which can provide a better solution. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs […]

## Create an Excel Burndown Chart in Simple Steps

About this tutorial: Video duration: 5:44 \$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for \$10 !! Click the link: ****************************************************************** Hello Excel Funs, in this video tutorial we are going to build a Burndown Chart in Excel. Until now we learned how to create a Gantt Chart, helpful for a project progress. […]

## DAX Measure & Data Model PivotTable – List Student Classes in Single Cell –- Excel Magic Trick 1607

About this tutorial: Video duration: 4:22 Download Excel Start File: Download Excel Finished File: Learn how to create a report that shows each student by quarter with a list of classes in a single cell. Learn how to create a Data Model PivotTable and a DAX Measure that uses the DAX Function CONCATENATEX using the […]

## Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions

About this tutorial: Video duration: 3:11 See how to transpose a range (switch rows and columns) using INDEX, COLUMNS and ROWS function. If you dont want to use TRANSPOSE function, this is a good substitute.