Microsoft Excel 2019 Step by Step, First Edition

3 Perform calculations on data

In this chapter

• Name groups of data

• Create formulas to calculate values

• Summarize data that meets specific conditions

• Set iterative calculation options and enable or disable automatic calculation

• Use array formulas

• Find and correct errors in calculations

Practice files

For this chapter, use the practice files from the Excel2019SBS\Ch03 folder. For practice file download instructions, see the introduction.

Excel 2019 workbooks give you a handy place to store and organize your data, but you can do a lot more with your data in Excel than just store it. One important task you can perform is to calculate totals for values in a series of related cells. You can also use Excel to discover other information about data ...