Excel Is Fun

Excel Magic Trick 1255

December 12, 2016 0

DESCRIPTION Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates Learn how to Convert Text Dates With Missing Year & Extra Spaces To Real Dates (Serial Number Dates) with a […]

Excel Is Fun

Excel Magic Trick 1248

November 17, 2016 0

DESCRIPTION Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT Learn how to add with Case Sensitive Contains Criteria EXACT & SUMPRODUCT. This video builds on the last video, Trick 1246: Counting with Case […]

Excel Is Fun

Excel Magic Trick 1244

November 3, 2016 0

DESCRIPTION Transform GDP Data Set: Advanced Filter with Formula Criteria wins! From Bill Szysz at YouTube, see how to use a Formula in Criteria area of Advanced Filter to extract data based on three conditions […]

Excel Is Fun

Excel Magic Trick 1242

October 27, 2016 0

DESCRIPTION Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format Learn how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and filter, delete and […]

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 98

August 31, 2016 0

Extract & Lookup Number When Table Of Numbers Is In A Single Cell DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr […]

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

Dueling Excel

Dueling Excel 87

July 20, 2016 0

Positive Subtotals Only: PivotTable or SUMIFS DESCRIPTION See Mr Excel and excelisfun use two methods to add only the subtotals that are positive (ignore negative Subtotals using PivotTable Pivot Table or SUMIFS or SUMPRODUCT functions. […]