Join Dennis Taylor for an in-depth discussion in this video Alter numeric data without formulas, part of Excel Tips Weekly.
- [Voiceover] There are times when you work…with numeric data that you wanna make changes to the data,…but not necessarily use formulas.…And you can do that with the feature called Paste Special.…You might be familiar with that feature…for doing other kinds of things with numbers,…but a special use of it involves incrementing,…decrementing, even dividing and multiplying numbers…by a certain amount without formulas.…I've got some sample data on this worksheet…and as I click column B for Hire Date here…I'm looking at the bottom of the screen, in the status bar,…and I see that the highest entry there is April 4th of 2014.…
Now let's imagine it's mid 2016,…I want my list to appear more up to date,…many of the entries we're seeing already…are pretty far in the past,…but that's OK, because these are hire dates,…but I want some of the entries in there…to be more recent than the latest entry,…which is April, 2014.…I want to add a number to these.…Now if I want to add a year exactly…I'd put in 365 in some nearby cell,…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- 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.