From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Perform calculations without formulas
From the course: Excel 2016: Tips and Tricks
Perform calculations without formulas
- [Voiceover] Sometimes you can perform calculations without writing formulas. On this worksheet called State Totals, we've got some numbers over on the left-hand side for our seven largest states and you're looking at these numbers and recognize that something's a little bit off. And you refer to a couple of sources and you realize, whoever transcribed these or entered these, all the numbers are off by five. You wanna make them all bigger by 5. So how could we approach this? One approach would be to highlight a range of the same size, maybe down here, and write a formula copied into all of these cells that would add five to these numbers. Then we could take those results and Copy-Paste them back up here. But we can do that a lot faster. Go to an empty cell nearby, put in the value that we want to add by, the incremental value is gonna be five. And let's simply Copy that. Ctrl + C, right-click Copy, either way. And then select the data that we want to change. And we want to go to…
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.
Contents
-
-
-
-
-
-
-
-
-
-
Create formulas rapidly6m 26s
-
Select all cells that depend on the active cell5m 9s
-
Select all cells that can affect the active cell4m 9s
-
Use AutoSum shortcuts3m 53s
-
Use rounding shortcuts5m 30s
-
Generate random numbers5m 3s
-
Count the number of unique entries5m 14s
-
Perform calculations without formulas3m 2s
-
-
-
-
-
-
-