Excel Is Fun

Excel Magic Trick 1312

August 10, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 31

April 14, 2017 0

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 Is Fun

Excel Magic Trick 1196

March 14, 2016 0

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 Is Fun

Excel Magic Trick 1195

March 7, 2016 0

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 Is Fun

Excel Magic Trick 1133

June 11, 2015 0

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 Is Fun

Excel Magic Trick 1131

June 4, 2015 0

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 Is Fun

Excel Magic Trick 1130

April 30, 2015 0

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 Is Fun

Excel Magic Trick 1129

April 29, 2015 0

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 Is Fun

Excel Magic Trick 1128

April 28, 2015 0

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