Excel Magic Trick 1403

DESCRIPTION Learn about the difference between Explicit and Implicit DAX Measures: (00:10) Introduction to Explicit and Implicit DAX Measures (01:33) Create Implicit Measures and see these six problems: 1) Number Field will use SUM Function, [Read More >>>]

Excel Magic Trick 1396

DESCRIPTION See how to: (00:13) Introduction. What is a Running Total or Cumulative Frequency. What is a % Running Total (03:10) Example 1: Grouping Integer Values for # of Transactions with a Quantity between an [Read More >>>]

Excel Magic Trick 1390

DESCRIPTION See how to calculate Average Number of Days Between Dates in a Single Column: 1. Introduction 2. Helper Column and AVERAGE Function 3. AVERAGE Function Array Formula. Requires Ctrl + Shift + Enter 4. [Read More >>>]

Excel Magic Trick 1388

DESCRIPTION See how to calculate the Average Number of Days Between Order Date & Ship Date with three different methods: (00:10) Introduction (00:25) Helper Column Method & AVERAGE Function (02:22) Array Formula #1: AVERAGE Function [Read More >>>]

Highline Excel 2016 Class 03

DESCRIPTION In this video learn about the fundamentals of Data Analysis and Business Intelligence in Excel 2016: Sort, Filter, PivotTables, Power Query, Power Pivot Data Model: (00:00:05) Introduction (00:01:39) Sort (00:03:02) Sorting one column (00:03:23) [Read More >>>]

Excel Magic Trick 1345

DESCRIPTION See how to use a Logical Formula and Conditional Formatting to highlight Product Name when no items are entered in the row. See 4 methods: (00:11) Introduction to Using Logical Formulas to Apply Conditional [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 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 1201

Conditional Format Product With No Sales (5 Examples) DESCRIPTION See how to: (00:08) Problem Setup (00:43) Format Product with NO Sales: COUNT & =0 (02:46) Format Product with NO Sales: COUNT & NOT (Any non-zero [Read More >>>]

Dueling Excel 70

Lookup & Return Last 5 Numbers in a List DESCRIPTION See Mr Excel and excelisfun create formulas that Lookup & Return Last 5 Items in a List using INDEX and COUNT functions. See a retractable [Read More >>>]