From the course: Excel Essential Training (Microsoft 365)
Join today to access over 23,200 courses taught by industry experts.
Copying a formula into adjacent cells
From the course: Excel Essential Training (Microsoft 365)
Copying a formula into adjacent cells
- [Instructor] On this worksheet called Copy Formulas, we've got a formula in place in Cell B4. One habit you want to develop as you work with Excel is when you see a sea of numbers like this here, as you click on a cell, get in the habit of looking in the formula bar. It's above the column letters right up here. And you want to view this in the same way that you look out your rear view mirror in the car as you're driving around. Is that a formula there in Cell G2? No, that's a value, it's 420. What about this to the right? Oh, that's a function using sum. And how about this one here? Now you don't do that for every single cell, of course, but you quickly realize that many times when you're looking at an Excel worksheet, there are a lot of formulas there. Now, we've written the formula here in the previous movie to subtract these two cells, and in a certain sense, we want to do the same thing here. If we describe it 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.