From the course: Excel: Tips and Tricks (2023)
Join today to access over 24,700 courses taught by industry experts.
Create formulas rapidly
From the course: Excel: Tips and Tricks (2023)
Create formulas rapidly
- [Instructor] Writing formulas in Excel, a critical task, but there are some shortcuts that make it easier. I've got a worksheet here called HR List that's in our Chapter 7 file. Now, I'm interested in the total here for compensation. So, I'll click Column J, and at the bottom of the screen in the status bar, I've got a total. So, I might not even need a formula there. And by the way, this status bar at the bottom of the screen can be enhanced. Anytime you highlight two or more cells, you will see values there. If you right-click down the status bar here, you'll notice there's a set of check marks right here. And you might as well check them all. And that means from now on, anytime you're highlighting data, you've got totals at your fingertips. And that's kind of handy. So in a certain sense, we're saying you don't even need formulas in some cases if you want to know the information on the fly, so to speak.…
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.