Learn tricks and techniques for optimizing the use of dates and times in Excel 2016.
- [Dennis] Hi, I'm Dennis Taylor, and welcome to this course on using dates and times in Excel. Whether you're using Excel to track order and shipping dates, calculating the age of your inventory, or tabulating hours worked on a project, you need to understand how Excel stores date and time data. I'll show you the best ways to enter dates and times, how to quickly build date/time series, and how to create your own custom date formats for optimum readability. We'll see powerful date functions that determine the day of the week, calculate working days between two dates, and determine future and past target dates.
We'll also look at shortcuts and tips to optimize tricky time calculations, the best techniques for converting dates downloaded from other sources, how to use dates with data validation rules, and use date filtering techniques as well. So, let's get started.
- How Excel records and stores dates
- Using standard date/time entries and acceptable alternatives
- Formatting dates and times
- Creating standard date/time formats
- Working with dates and times in functions
- Calculating with dates and times
- Using dates/times with Excel commands
Skill Level Intermediate
1. Understanding the Excel Date/Time System
2. Creating Date/Time Entries
3. Formatting Dates and Times
4. Working with Dates and Times in Functions
5. Calculating with Dates and Times
6. Using Dates/Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.