Excel Magic Trick 1312

August 10, 2017

DESCRIPTION Learn: (00:08) Problem introduction. (00:33) How to use NETWORKDAYS.INTL to count the number of working days between a start and end date. NETWORKDAYS.INTL is in Excel 2010 or later versions. (01:46) Formula to count […]

Highline Excel 2013 Class Video 31

April 14, 2017

Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More DESCRIPTION Topics in this video: 1. TODAY function to put in today’s date so that it updates each day. 2. NOW to put in today’s date […]

Excel Magic Trick 1196

March 14, 2016

YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tipsâ€¦ DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then […]

Excel Magic Trick 1195

March 7, 2016

Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? DESCRIPTION See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some […]

Excel Magic Trick 1133

June 11, 2015

Aging Accounts Receivable Reports: PivotTable & Unique Identifier DESCRIPTION See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable where or not there are duplicate records: (01:49) Days Late Helper Column Formula: […]

Excel Magic Trick 1131

June 4, 2015

Ageing Accounts Receivable Reports On Multiple Sheets With PivotTable DESCRIPTION TRICK ONLY WORKS IF THERE ARE NO DUPLICATES!!!!! See how to create Ageing Accounts Receivable Reports On Multiple Sheets With PivotTable when there are no […]

Excel Magic Trick 1130

April 30, 2015

DESCRIPTION See how to create an Ageing Accounts Receivable Reports Using Advanced Filter: (00:27) Helper Column. The correct formula for Days Late is: =TODAY()-D8 (00:49) Sort to bring largest to top (01:10) Criteria Area (01:40) […]

Excel Magic Trick 1129

April 29, 2015

DESCRIPTION See how to create Ageing Accounts Receivable Reports using Slicer, Excel Table Feature and formulas: (00:09) Overview (01:05) Text Formula For Reporting Categories in Lookup Table (01:59) Days Late Formula. The correct formula for […]

Excel Magic Trick 1128

April 28, 2015

DESCRIPTION See how to create an automated Accounting Ageing Accounts Receivable Reports On Multiple Sheets With Array Formula, Excel Table Feature and Formula Table Nomenclature (Structured References): (00:16) Overview of end result: Automatic Ageing Reports […]