From the course: Excel: Avoiding Common Mistakes (Microsoft 365)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Reduce data entry and typing errors
From the course: Excel: Avoiding Common Mistakes (Microsoft 365)
Reduce data entry and typing errors
- [Instructor] Excel has any number of different techniques for reducing the amount of time required for data entry. I've got a sheet of paper in front of me with some city names here, also some sales, eventually we'll put this on a different worksheet. It turns out that the city names are recurring. I need to put in Boston in cells A2 and A3, also in A6, A7, A10 and we'll have other repeating cities as well. Rather than typing this once and copying it multiples times, we can select the cells ahead of time and simply type the entry once. I've highlighted these two cells, I've let go of the left mouse button, with the Control key now, I'll highlight cells A6 and A7, once again let go of that left mouse button, Control key is held down, I'll click on cell A10. And as I type Boston, it looks as if this entry is only going into that cell, but I won't press enter, I'll press Control + Enter. Same entry goes in all of those. We…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.