Excel Dates
CLASS DATE(s):
8/20/2020
9/17/2020
10/15/2020
11/12/2020

COURSE LENGTH: Day

COURSE TIMES: TBD

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

In this half-day course we run through the many powerful date functions in Excel, including anniversaries, forecasting, fiscal years, elapsed time, and more. How much time is left on that Certificate of Deposit, when do you have to pay that traffic ticket, and how old is grandma, really?

AUDIENCE AND PREREQUISITES

Schedulers, planners, managers who deal with personnel, financial planners, anyone who works with time and dates.

PREREQUISITE COURSES   

COURSE TOPICS:


Numbers and Dates in Excel

Date formats

Entering Dates
typing techniques
ambiguous dates
local settings
autofill

Date Math
adding and subtracting dates

Extracting elements of dates
day of the week
fiscal quarters
fiscal years
first and last day of the month
week ending on ...

Holidays
compute any American holiday

Anniversaries
birthdays

Creative Narratives
text formatting
DATEDIFF function