Excel® 2007 FOR DUMmIES Q U I C K R E F E R E N C E by John Walkenbach and Colin Banfield

Contents at a Glance

Part 1: Getting to Know Excel 2007 ................................................................1

Part 2: Managing Workbooks ........................................................................21

Part 3: Working with Worksheets ................................................................37

Part 4: Entering and Editing Worksheet Data ..............................................49

Part 5: Using Formulas and Functions..........................................................77

Part 6: Creating and Using Names ................................................................87

Part 7: Auditing Your Work ..........................................................................97

Part 8: Formatting Your Data ......................................................................113

Part 9: Printing Your Work..........................................................................135

Part 10: Charting Your Data ........................................................................151

Part 11: Working with Tables......................................................................169

Part 12: Goal Seeking and What-If Analysis ..............................................185

Part 13: Analyzing Data with PivotTables..................................................193

Glossary: Tech Talk......................................................................................207

Index ............................................................................................................215