Microsoft Office 2019 Step by Step, First Edition

6

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

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 you select, such as the maximum or minimum value in a group of cells. And if you make an error, you can find the cause and correct it quickly.

Often, you ...