Dueling Excel

Dueling Excel 101

September 9, 2016 0

Sum Numbers from Cells That Contain Both Text & Numbers DESCRIPTION See Mr Excel and excelisfun use two methods to add the numbers from cells that have both numbers and text. See these tricks: 1. […]

Excel Is Fun

Excel Magic Trick 1227

September 5, 2016 0

DESCRIPTION Conditional Format: Min, Max & Min Value Greater Than Zero Learn how to: (00:12) Problem Introduction (00:38) Conditionally Format the Maximum value in a set of numbers with built in Top 1 Rule (01:32) […]

Excel Is Fun

Excel Magic Trick 1226

September 1, 2016 0

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) […]

Dueling Excel

Dueling Excel 94

August 17, 2016 0

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 […]

Excel Is Fun

Excel Magic Trick 1221

August 15, 2016 0

Dynamic Chart to Plot Daily Changes in Meter Readings DESCRIPTION Learn how to create a dynamic chart that updates when daily meter readings are entered into a table (00:10) Problem Setup (00:50) IF function and […]

Excel Is Fun

Excel Magic Trick 1220

August 11, 2016 0

How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP DESCRIPTION Learn how to either use IF function and Extra Double Quotes or VLOOKUP to put the text 5’6” or 6’ into […]

Dueling Excel

Dueling Excel 89

July 29, 2016 0

PivotTables Grand Totals To Left: LOOKUP or GETPIVOTDATA function? DESCRIPTION See Mr Excel and excelisfun use two methods to shows PivotTable Grand Totals to the left of the PivotTable (Since there is no way to […]

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

Dueling Excel

Dueling Excel 86

July 13, 2016 0

MODE or MEDIAN From Frequency Table Formula or VBA? DESCRIPTION See Mr Excel and excelisfun use two methods calculate MODE or MEDIAN From Frequency Table – Formula or VBA. See the functions, AND, COUNTIF, MAX, […]

Dueling Excel

Dueling Excel 78

May 18, 2016 0

Extract Top Two Customers In Each Industry with Formula (2 Examples) DESCRIPTION See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, […]