From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Creating and updating sample data

Creating and updating sample data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Creating and updating sample data

“

- [Instructor] If you need to update sample data, or create sample data there are a number of techniques that are going to make that whole process faster and easier. I've got some sample data in columns A through G. You might have seen some of these names, some of these salaries, higher dates in other movies, I need to update these periodically. As I click column D here in the status bar at the bottom of the screen my eye is drawn to Min and Max. Max on the right December 2nd 2015, presumably in this organization if we're acting as if it's real we're saying the last person that was hired was December of 2015. I want to bump these all into 2019 or 2020 possibly, so what do I need to do? I need to add numbers to these I certainly don't want to retype them. Now if it's somehow important that I keep the same day of the week I will add a number to these that's a multiple of seven. If I'm thinking of a whole year that would be 364.…

Contents