From the course: Excel: Tips and Tricks (2023)
Join today to access over 24,700 courses taught by industry experts.
Perform calculations without formulas
From the course: Excel: Tips and Tricks (2023)
Perform calculations without formulas
- [Instructor] On this worksheet called State Totals, we've got two different sets of numbers, and we need to change both of them, but for different reasons. Imagine that the list over here consists of numbers that are indexed numbers that might refer to some economic conditions in this state for a certain month, it turns out that whoever did the calculations made a mistake and these are all short by five. We want to add five to all of these. Now, one way to do this and it would take a little bit of time, we could set up an area down here that's got the same size as the numbers above, and write formulas to add five to every one of those, then we could copy paste and move them around and so on. But let's do this essentially in one action. Put the number 5 in an empty cell somewhere, and simply copy it, Control + C or right click copy. Then we'll highlight the data, and we need to go to Paste Special in that green panel in the…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
