Microsoft Office Tutorials and References
In Depth Information
In this chapter, you will learn how to
✔ Name groups of data.
✔ Create formulas to calculate values.
✔ Summarize data that meets specific conditions.
✔ Find and correct errors in calculations.
Microsoft Excel 2010 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 learn how to streamline references to groups of data on your
worksheets and how to create and correct formulas that summarize an organization’s