Viewers: in countries Watching now:
In Excel 2010: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2010. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course.
For some users they enter the current date throughout the course of a day frequently, and some users even the current time. You could enter this information very quickly with a couple of great keystroke shortcuts. Suppose we want to put the current date in cell B2. As I am recording this in mid-July of 2010, Ctrl+; that's the current date. That's it. This is also handy if you want to put in, say in a different cell, a nearby date. Maybe you want to put in the 21st or the 28th or something like that. Ctrl+; and since I am still editing here change the 0 to 8 and do that, makes it fast.
Current time, the keystroke shortcut Ctrl+Shift+;. This will be the standard display. You can certainly change that. Depending on whether you might have had a date in here previously you might see this kind of a display, and so a simple right-click and Format Cells and a time entry, something like this perhaps, either this variation or the one that shows AM/PM. In both cases here, what you are doing is saving typing. You're not putting in any kind of datat that's going to be dynamic, that's going to change.
It will not change unless you actually change the content of the cell. Some people actually will put this into a worksheet just before they print it because it is accurate at the moment. But it's fast, it's easy, and it saves you a good deal of typing here and there. Particularly with the date, because I think a lot of people will use this frequently.
There are currently no FAQs about Excel 2010: Working with Dates and Times.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.