From the course: Excel 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using SUM and AVERAGE
- [Instructor] Whenever you're trying to add up numbers in a column or a row, or come up with an average of those numbers, you rely on two of Excels most commonly used functions; sum and average. Now there's a menu button, there's a keystroke shortcut, and also some different selection techniques that are gonna make these functions easier to use. We're looking at the worksheet Sum, average in the workbook O3, creating formulas and functions. First, as a reminder, on the formulas tab in the ribbon, in the menu system, you will see ultimately all Excel functions. There are over 450 of them. And no body needs to know them all, that's for sure. If you're looking for a particular function, you're not always sure where to begin, is it math and trig? Well maybe, maybe not. Slide over a function, you'll see a description. Nobody quite approaches looking for functions in that way. Most of the time we do it based on context. We want to add up data right here in cell G2, on this worksheet called…
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.