About This Chapter
Summarize Data with Functions in Excel: Chapter Summary
In this collection of lessons, you can learn to add, average, and count numbers in specific Excel cells or cell ranges. In addition, you can also find out the steps for finding the minimum or maximum value in chosen ranges or cells.
Experienced Excel instructors will lead you through all the necessary steps in these instructional videos. Each lesson has a brief quiz for feedback on your progress. Watch as many times as you like, or read the accompanying transcripts, until you're comfortable with these functions.
Lessons include the following:
- Using the SUM Excel function
- Trying the MAX and MIN functions
- Using the COUNT function
- Understanding the AVERAGE function
(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools, or displays may be different in other versions.)
Excel is a trademark of the Microsoft Corporation, which is not affiliated with Study.com.
1. Using the SUM Function in Excel
When you need to perform calculations to add, subtract, divide and multiply, the SUM function is perfect for helping to carry out those tasks. This lesson will introduce you to the SUM function and explain how to use SUM in your formulas.
2. Using the MIN and MAX Functions in Excel
Looking in a cell range of numbers to find the smallest number, or the largest, can be time consuming and inefficient. This lesson will introduce you to the MIN and MAX functions in Excel and demonstrate how to use them in formulas.
3. Using the COUNT Function in Excel
The COUNT function is one of the most common functions used in Excel. This lesson will introduce you to the function and explain how to use it in formulas.
4. Using the AVERAGE Function in Excel
Average is calculated by adding numbers together, then dividing the total by the number of numbers. This lesson will explain how to use the AVERAGE function in Excel.
Earning College Credit
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.
Other chapters within the Intro to Excel: Essential Training & Tutorials course
- Creating Worksheets & Workbooks in Excel
- Formatting Worksheets & Workbooks in Excel
- Customizing Options & Views in Excel
- Configure to Print & Save in Excel
- Format Cells & Ranges in Excel
- Insert Data in Cells and Ranges in Excel
- Filter and Sort a Table in Excel
- Order & Group Cells & Ranges in Excel
- Create a Table in Excel
- Modify a Table in Excel
- Use Cell Ranges & References for Formulas & Functions in Excel
- Functions with Conditional Logic in Excel
- Format & Modify Text with Functions in Excel
- Create a Chart in Excel