Dueling Excel

Dueling Excel 122

December 7, 2016 0

DESCRIPTION Entering Credit Card Numbers With More Than 15 Digits See Mr Excel and excelisfun use two methods to: 1. Text Number Formatting 2. Custom Number Formatting 3. Lead Apostrophe WORKBOOKS

Excel Is Fun

Excel Magic Trick 1253

December 5, 2016 0

DESCRIPTION Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH! Learn how to get VLOOKUP to use Column Headers for the col_index-num argument by using the MATCH function. See how to lookup […]

Excel Is Fun

Excel Magic Trick 1252

December 1, 2016 0

DESCRIPTION Power Query To Create Unique List of Invoice Numbers with Balances From An Excel Table that stores Invoice data with line item data for invoices (duplicate invoice numbers in the Invoice Field (Column), learn […]

Dueling Excel

Dueling Excel 121

November 30, 2016 0

DESCRIPTION MIN and MAX Between Two Dates For Each Region See Mr Excel and excelisfun use two methods to calculate MIN and MAX Between Two Dates For Each Region (Minimum value and maximum value with […]

Excel Is Fun

Excel Magic Trick 1251

November 28, 2016 0

DESCRIPTION SUMIFS & Table Formula Nomenclature (Structured References) to Add Invoices Learn how to use SUMIFS function and Table Formula Nomenclature (Structured References) to add amounts for Invoices. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1250

November 24, 2016 0

DESCRIPTION Add Times to Get Total Minutes & Seconds From Downloaded Music Data Learn how to add times to show total minutes and seconds for copy and pasted downloaded music data. Learn about Time Math, […]

Dueling Excel

Dueling Excel 120

November 23, 2016 0

DESCRIPTION Summarize By Week and Month, Monthly Totals, Weekly Totals See Mr Excel and excelisfun use two methods to Summarize By Week and Month: 1. See two methods that use SUMIFS, EOMONTH, WEEKDAY and other […]

Excel Is Fun

Excel Magic Trick 1249

November 21, 2016 0

DESCRIPTION Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail **Note; The word “Database” is used loosely in this video. We use it just to mean we have a dynamic table […]

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