Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Performing calculations on data
IN THIS CHAPTER, YOU WILL LEARN HOW TO
▪ Name groups of data.
▪ Create formulas to calculate values.
▪ Summarize data that meets specific conditions.
▪ Work with iterative calculation options and automatic workbook calculation.
▪ Use array formulas.
▪ Find and correct errors in calculations.
Microsoft Excel 2013 workbooks give you a handy place to store and organize your data,
but you can also do a lot more with your data in Excel. One important task you can perform
is to calculate totals for the values in a series of related cells. You can also use Excel to
discover other information about the data you select, such as the maximum or minimum value
in a group of cells. By finding the maximum or minimum value in a group, you can identify
your best salesperson, product categories you might need to pay more attention to, or
suppliers that consistently give you the best deal. Regardless of your bookkeeping needs, Excel
gives you the ability to find the information you want. And if you make an error, you can
find the cause and correct it quickly.
Many times, you can’t access the information you want without referencing more than one
cell, and it’s also often true that you’ll use the data in the same group of cells for more than
one calculation. Excel makes it easy to reference a number of cells at once, enabling you to
define your calculations quickly.
In this chapter, you’ll streamline references to groups of data on your worksheets and create
and correct formulas that summarize an organization’s business operations.