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

Dueling Excel

Dueling Excel 038

August 26, 2015 0

Weekly Report Formula or Pivot Table? DESCRIPTION See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of formulas. Learn about: 1.Formula for […]

Dueling Excel

Dueling Excel 033

July 22, 2015 0

First Monday For Reporting Period DESCRIPTION See Mr Excel and excelisfun show three formulas for finding first Monday of reporting period: If 1st day of month is Monday, then that day, otherwise the last Monday […]

Excel Is Fun

Excel Magic Trick 1123

April 23, 2015 0

DESCRIPTION See how to… Create a formula To Create A List of Dates For Month. Change the start date and the list updates. See the functions, EOMONTH, DAY, IF, ROWS. WORKBOOKS