Microsoft Office Step by Step (Office 2021 and Microsoft 365)

6

Perform calculations on data

In this chapter

• Name data ranges

• Create formulas to calculate values

• Summarize data that meets specific conditions

• Copy and move formulas

• Create array formulas

• Find and correct errors in calculations

• Configure automatic and iterative calculation options

Excel workbooks provide an easy interface for storing and organizing data, but Excel can do so much more than that. Using the built-in functions, you can easily perform a variety of calculations—from simple tasks such as calculating totals to complex financial calculations. Excel can report information such as the current date and time, the maximum value or number of blank cells in a data set, and the cells that meet specific conditions, and it can use this information ...