Excel 2007 For Dummies

Book Description

One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here!

If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

You’ll discover how to:

• Rearrange, delete and insert new information
• Keep track of and organize data in a single worksheet
• Transfer data between the sheets of different workbooks
• Create a chart using the data in a worksheet
• Add hyperlinks and graphics to worksheets
• And more!

Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.

Table of contents

Part I: Getting In on the Ground Floor
Chapter 1: The Excel 2007 User Experience
Chapter 2: Creating a Spreadsheet from Scratch

Part II: Editing Without Tears
Chapter 3: Making It All Look Pretty
Chapter 4: Going through Changes
Chapter 5: Printing the Masterpiece

Part III: Getting Organized and Staying That Way
Chapter 6: Maintaining the Worksheet
Chapter 7: Maintaining Multiple Worksheets

Part IV: Digging Data Analysis
Chapter 8: Doing What-If Analysis
Chapter 9: Playing with Pivot Tables

Part V: Life Beyond the Spreadsheet
Chapter 10: Charming Charts and Gorgeous Graphics
Chapter 11: Getting on the Data List
Chapter 12: Hyperlinks and Macros

Part VI: The Part of Tens
Chapter 13: Top Ten New Features in Excel 2007
Chapter 14: Top Ten Beginner Basics
Chapter 15: The Ten Commandments of Excel 2007

About The Author

Greg Harvey

Greg Harvey is a veteran computer trainer, consultant, and the author of more than 50 books. He also owns and manages a multimedia publishing venture, Mind Over Media.