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