Excel 2007 for Starters: The Missing Manual: The Missing Manual

by Matthew MacDonald

Overview

Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to:

• Build spreadsheets
• Add and format information
• Print reports
• Create charts and graphics
• Use basic formulas and functions
• and more

The new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For Excel 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate.

Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

Product Details

ISBN-13:	9780596528324
Publisher:	O'Reilly Media, Incorporated
Publication date:	01/01/2007
Series:	Missing Manual Series
Pages:	348
Product dimensions:	7.00(w) x 9.19(h) x 0.84(d)

About the Author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Table of Contents

The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What You Can Do with Excel; Excel's New Face; Excel's New Features; About This Book; Part I: WORKSHEET BASICS; Chapter 1: Creating and Navigating Worksheets; 1.1 Creating a Basic Worksheet; 1.2 Editing Data; 1.3 Navigating in Excel; 1.4 Saving Files; 1.5 Opening Files; Chapter 2: Adding Information to Worksheets; 2.1 Adding Different Types of Data; 2.2 Quick Ways to Add Data; Chapter 3: Moving Data Around a Worksheet; 3.1 Selecting Cells; 3.2 Moving Cells Around; 3.3 Adding and Moving Columns or Rows; Chapter 4: Managing Worksheets and Workbooks; 4.1 Worksheets and Workbooks; 4.2 Find and Replace; 4.3 Spell Check; Chapter 5: Formatting Cells; 5.1 Formatting Cell Values; 5.2 Formatting Cell Appearance; 5.3 Smart Ways to Apply Formatting; Chapter 6: Viewing and Printing Worksheets; 6.1 Controlling Your View; 6.2 Printing; 6.3 Controlling Pagination; Part II: WORKSHEET POWER; Chapter 7: Building Basic Formulas; 7.1 Creating a Basic Formula; 7.2 Formula Shortcuts; 7.3 Copying Formulas; Chapter 8: Tables: List Management Made Easy; 8.1 The Basics of Tables; 8.2 Sorting and Filtering a Table; Chapter 9: Creating Basic Charts; 9.1 Charting 101; 9.2 Basic Tasks with Charts; 9.3 Practical Charting; 9.4 Chart Types; Appendix A: Customizing The Quick Access Toolbar; A.1 The Quick Access Toolbar; Colophon;