Why is Easter late this year? Thistalk is for anybody who uses dates and times in their Excel work. We will explore functions, formulas and formats that are under-appreciated, or even hidden.
Learn how to work with dates and times, including calculations that work on dates. Understand how Excel formats dates, and explore some interesting formats. And, after all, find out how to calculate the date when Easter will fall.
Duncan Young has been a member of the University’s Financials Training Team since 2006 and gave his first Excel course in 1993. Since then he has given countless courses in all aspects of Excel, including installation and programming, and was part of the team which wrote and delivered Microsoft’s internal helpdesk training for Excel 2002.
Duncan Young, who gave this talk, says this:
The book I held up was “Excel Formulas” by John Walkenbach. Below is the Excel 2010 version, but obviously people should buy whichever one is appropriate to their version:
Look at the slides from this talk:
Do talk Duncan Young Excel Adventure 2014-03
Try out the workbooks with formulas from this talk:
Do Talk Duncan Young Excel Workbooks Formulas