The majority of the questions that I receive from viewers center on how to use and format DATES & TIMES in Excel. So, I have decided to create a series of lessons to show you how to work with dates and times in Excel. This is part one in a continuing series of free Excel Video Training Lessons.
Excel Tips
Learn How to Work with Dates
- Use a Keyboard Shortcut to enter the current date in a cell – to “time stamp” the date.
- Use the TODAY() Function to enter a “dynamic” date function in a cell – so that your date always reflects the current date.
- Distinguish between how Excel “stores” a date – as a serial number – and how Excel formats a date – how you choose to format a date.
- Tell if a date was entered correctly – as a number – or incorrectly – as “text” by seeing how it is aligned in the cell (right or left).
- See why a fraction could be recognized as a date – and how to correct this “got’cha” step!
- How to create a series of dates in your spreadsheet.
In my experience, the majority of “Excel problems” are based around incorrect date and time entries. So, whether you are new to Excel or a veteran who gets frustrated with Time and Date calculations, this lesson is for you.
If nothing else, you will pick up some great Keyboard Shortcuts in this lesson!
Learn how to “Master Excel in Minutes – Not Months!”
Link to this post!
[…] This post was mentioned on Twitter by Mysteriously Unnamed, Danny Rocks. Danny Rocks said: Danny's Latest Post How to Work with Dates in Excel http://goo.gl/fb/JehUr #exceldateandtimefunctions #exceltraining […]