From the course: Getting Started with Microsoft 365
Join today to access over 25,300 courses taught by industry experts.
Using the SUM function
From the course: Getting Started with Microsoft 365
Using the SUM function
- [Instructor] When you're keeping track of numbers in a spreadsheet, Excel can save you time by doing the math quickly and accurately for you, with something as important and detailed as your monthly expenses, having everything added up automatically, helps you make sense of all that information. With the sum function you can easily add large amounts of data together. In this lesson, I'll show you how to use this powerful tool to transform an extended list of numbers into a simple sum total. To get started, download the exercise file and pull up the sample budget in Excel. The sample budget contains a list of expenses and each expense has a cost next to it. If you want to know how much you'll need to pay for all these expenses you'll need to know the total cost in one single value, that's where the sum function can help. First consider where you want the total amount to be displayed, I'll choose cell E 2 as the home…
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.