Summarize Data in Microsoft Excel
Crunching numbers is the bread and butter of Excel. This course will teach you how to count and summarize values.
What you'll learn
If you've got a table of data and you want to draw conclusions based on it, then the first thing you need to learn is how to summarize values.
In this course, Summarize Data in Microsoft Excel, you'll learn how to use SUM and COUNT in formulas, and how to conditionally include records with SUMIF and COUNTIF.
When you’re finished with this course, you’ll have the skills and knowledge needed to better understand summarizing and counting in Excel.
Table of contents
- Using the SUM Function 2m
- AutoSum for Columns and Rows 3m
- COUNT and COUNTA Functions 3m
- COUNTIF - Price Is above a Threshold 2m
- Adding an Adjustable Threshold and Conditional Formatting 3m
- SUMIF and AVERAGEIF Functions 2m
- Using the SUBTOTAL Function with Filtered Records 3m
- Nested Totals with the Subtotal Button 2m
About the author
Wes Higbee is passionate about helping companies achieve remarkable results with technology and software. He’s had extensive experience developing software and working with teams to improve how software is developed to meet business objectives. Wes launched Full City Tech to leverage his expertise to help companies delight customers. Although his primary focus is on outcomes, implementation often includes technical competency. Wes frequently speaks about impactful aspects of software developm... more