Join Dennis Taylor for an in-depth discussion in this video Using instant date/time entry, part of Excel 2007: Working with Dates and Times.
There are two quick and efficient ways for entering dates and times in Excel,…and many times throughout the course of a day you might be putting in the current date.…So at the date I'm recording this particular movie - I am going to click right here -…I want to put in today's date, but rather than typing it, I'm going to use a…great keystroke shortcut - not so obvious but very fast: Ctrl+semicolon to put…in the current date.…This date will not change unless you or I happen to actually change it.…So, it's going to stay there indefinitely.…
I also use this too when I'm putting in dates say nearby. Maybe I need to put in…July 29th, or July 18th, or whatever. Ctrl+semicolon…and then just a quick edit here to change whatever entry I need to make a change…to, and we're all set. It makes it fast and easy for putting in the current date.…For the current time, it's going to be Ctrl+Shift+semicolon…and it'll put in the entry this way.…Here too, this will not change no matter what you do, unless you type something…
- Understanding how Excel records and stores dates and times
- Looking at standard date/time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Exploring keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Rounding calculations
- Working with holidays
- Validating with dates
- Converting formatted dates to usable data
Skill Level Intermediate
Excel 2007: Creating Business Budgetswith Curt Frye1h 3m Intermediate
Excel 2007: Introduction to Formulas and Functionswith Curt Frye2h 26m Intermediate
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Excel's Date/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.