Chapter 5: Performing Calculations and Graphing Excel Data

Overview

You covered a lot of important ground in Chapter 4, and you now have a feel for Excel s potential power. In this chapter, we introduce you to more Excel techniques, such as how to work with multiple workbooks and how to create a link between two worksheets. We discuss conditional formulas that carry out tasks based on one or more critera. We also give you lessons in consolidating and graphing.

When you have finished this chapter, you will know how to:

• Work with multiple workbooks

• Create formulas that make decisions

• Consolidate data

• Plot graphs

• Preview and print graphs