### Excel Magic Trick 1394

DESCRIPTION See how to use formulas to calculate “PivotTable Show Values As: Calculations: (00:14) Introduction to unusual formulas for standard PivotTable Show Values As Calculations (01:29) Total Revenue Formula for either Product or Manufacturer in [Read More >>>]

### Highline Excel 2016 Class 18

DESCRIPTION In this video learn about: (00:13) Introduction (01:08) Find & Replace feature (Clean Data) (03:49) Flash Fill: Clean Data (10 Examples) (11:14) Text To Columns (TTC) (12:16) Text To Columns (TTC) to split data [Read More >>>]

### Excel Magic Trick 1289

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn 6 methods to remove “USD” from a column of values such as \$ 1.23 USD, \$ 56.34 USD, etc. that resulted from multiple downloaded CSV Files, including Replace feature, [Read More >>>]

### Dueling Excel 135

DESCRIPTION From Text to Math: VBA or Excel 4 Macro Function: EVALUATION See Mr Excel and excelisfun use two methods to convert a text string to a match expression that can calculate the correct answer: [Read More >>>]

### Dueling Excel 102

Remove Duplicate Records Based On Partial Text in a Cell DESCRIPTION See Mr Excel and excelisfun use two methods to Remove Duplicate Records Based On Partial Text in a Cell using: 1. Formula with SUBSTITUTE, [Read More >>>]

### Excel Magic Trick 1224

Which Similar Array Formula? Compare Number of Array Operations DESCRIPTION Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient: (00:08) Problem [Read More >>>]

### Excel Magic Trick 1222

Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format? DESCRIPTION Learn how to Create a Formula to Add Column Filled With Weights Like: 10kg, 33kg, 19kg: (00:10) Problem Setup (01:12) Customer Number [Read More >>>]

### Dueling Excel 94

Lookup Data In Text String & Extract Data From Text String DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Lookup Data In Text String & Extract Data From Text String in order [Read More >>>]

WORKBOOKS

### Excel Magic Trick 1199

Formula to Extract Everything After Last Space: Two Formula Solutions DESCRIPTION See how to use Formula to Extract Everything After Last Space: (00:08) Problem Setup (01:05) Formula with TRIM, RIGHT, SUBSTITUTE, REPT, LEN and LEN [Read More >>>]