Join Dennis Taylor for an in-depth discussion in this video Using special date filters with date data: Advanced data filter applications, part of Excel 2013: Working with Dates and Times.
…In this worksheet called date filter, we've got some…data in columns A, B and C representing various contracts.…Most of them are in the past but some are…in the future and as we look at this list, a…substantial list, we may want to view only certain portions of…the data and that's where Excel's filtering capability comes into play.…So, on the Data tab, recognize that there's…a Filter button, there's also an Advanced Filter.…For many, many people, filter covers most of what you need here.…Let's activate the filter.…As long as the active cells are within the data, and we've scoped it…out, there are no empty rows within the data, we can click this button.…
It activates drop arrows for each of our field names here.…And sometimes, all you need to do is see the…options and you're off to the races, so to speak.…Date filters.…Excel recognizes that this column has date entries in it.…So, we might want to view all the…contracts that started last week, are there any?…yes.…I am in early February of 2014, therefore these are last week, and you can begin…
- Understanding how Excel records and stores dates and times
- Looking at standard date and time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Using keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Calculating the day of the week
- Working with holidays
- Validating dates
- Converting formatted dates to usable data
Skill Level Intermediate
1. The Excel Date and Time Systems
2. Creating Date and Time Entries
Instant date and time entry1m 28s
3. Date and Time Formatting
4. Date and Time Functions
5. Calculating with Dates and Times
6. Using Dates and 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.