Excel Is Fun

Excel Magic Trick 1321

September 25, 2017 0

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER […]

Dueling Excel

Dueling Excel 149

July 5, 2017 0

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

Excel Is Fun

Excel Magic Trick 1285

April 6, 2017 0

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

Excel Is Fun

Highline Excel 2013 Class Video 26

March 10, 2017 0

DESCRIPTION Topics in this video: 1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list. 2. Sort Dialog […]

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