Excel 2007: The Missing Manual

by Matthew MacDonald

Overview

Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even if users can find advanced features, they probably won't know what to do with them.

Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It's a 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:	9780596554927
Publisher:	O'Reilly Media, Incorporated
Publication date:	12/27/2006
Series:	Missing Manual Series
Sold by:	Barnes & Noble
Format:	eBook
Pages:	860
File size:	48 MB
Note:	This product may take a few minutes to download.

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; Chapter 6: Smart Formatting Tricks; 6.1 The Format Painter; 6.2 Styles and Themes; 6.3 Conditional Formatting; Chapter 7: Viewing and Printing Worksheets; 7.1 Controlling Your View; 7.2 Printing; 7.3 Controlling Pagination; Part II: Formulas and Functions; Chapter 8: Building Basic Formulas; 8.1 Creating a Basic Formula; 8.2 Formula Shortcuts; 8.3 Copying Formulas; Chapter 9: Math and Statistical Functions; 9.1 Rounding Numbers; 9.2 Groups of Numbers; 9.3 General Math Functions; 9.4 Trigonometry and Advanced Math; 9.5 Advanced Statistics; Chapter 10: Financial Functions; 10.1 The World of Finance; 10.2 Financial Functions; 10.3 Depreciation; 10.4 Other Financial Functions; Chapter 11: Manipulating Dates, Times, and Text; 11.1 Manipulating Text; 11.2 Manipulating Dates and Times; 11.3 Math with Dates and Times; 11.4 Date and Time Functions; Chapter 12: Lookup, Reference, and Information Functions; 12.1 The Basic Lookup; 12.2 Advanced Lookups; 12.3 Information Functions; 12.4 Tutorial: Quickly Generating Invoices from a Product Catalog; Chapter 13: Advanced Formula Writing and Troubleshooting; 13.1 Conditions in Formulas; 13.2 Descriptive Names for Cell References; 13.3 Variable Data Tables; 13.4 Controlling Recalculation; 13.5 Solving Formula Errors; Part III: Organizing Worksheets; Chapter 14: Tables: List Management Made Easy; 14.1 The Basics of Tables; 14.2 Sorting and Filtering a Table; 14.3 Dealing with Duplicate Rows; 14.4 Performing Table Calculations; Chapter 15: Grouping and Outlining Data; 15.1 Basic Data Grouping; 15.2 Grouping Timesavers; Chapter 16: Templates; 16.1 Understanding Templates; 16.2 Creating a New Workbook from a Template; 16.3 Creating Templates; Part IV: Charts and Graphics; Chapter 17: Creating Basic Charts; 17.1 Charting 101; 17.2 Basic Tasks with Charts; 17.3 Practical Charting; 17.4 Chart Types; Chapter 18: Formatting and Perfecting Charts; 18.1 Chart Styles and Layouts; 18.2 Adding Chart Elements; 18.3 Selecting Chart Elements; 18.4 Formatting Chart Elements; 18.5 Improving Your Charts; 18.6 Advanced Charting; Chapter 19: Inserting Graphics; 19.1 Adding Pictures to a Worksheet; 19.2 Excel's Clip Art Library; 19.3 Drawing Shapes; Part V: Advanced Data Analysis; Chapter 20: Scenarios and Goal Seeking; 20.1 Using Scenarios; 20.2 Using Goal Seek; 20.3 Solver; Chapter 21: Pivot Tables; 21.1 Summary Tables Revisited; 21.2 Building Pivot Tables; 21.3 Multi-Layered Pivot Tables; 21.4 Fine-Tuning Pivot Table Calculations; 21.5 Filtering a Pivot Table; 21.6 Pivot Charts; Part VI: Sharing Data with the Rest of the World; Chapter 22: Protecting Your Workbooks; 22.1 Understanding Excel's Safeguards; 22.2 Data Validation; 22.3 Locked and Hidden Cells; Chapter 23: Worksheet Collaboration; 23.1 Preparing Your Workbook; 23.2 Adding Comments; 23.3 Tracking Changes; 23.4 Sharing Your Workbook; Chapter 24: Querying Databases and XML Files; 24.1 Excel and Databases; 24.2 Understanding XML; 24.3 Excel and XML; Chapter 25: Exchanging Data with Other Programs; 25.1 Sharing Information in Windows; 25.2 Embedding and Linking Objects; 25.3 Transferring Data; Chapter 26: Connecting Worksheets to the Web; 26.1 Putting Worksheets on the Web; 26.2 Performing Web Queries; 26.3 Using Hyperlinks; Part VII: Programming Excel; Chapter 27: Automating Tasks with Macros; 27.1 Macros 101; 27.2 The Macro Recorder; 27.3 Macro Security; 27.4 Creating Practical Macros; Chapter 28: Programming Spreadsheets with VBA; 28.1 The Visual Basic Editor; 28.2 Understanding Macro Code; 28.3 Exploring the VBA Language; Part VIII: Appendix; Appendix A: Customizing the Quick Access Toolbar; A.1 The Quick Access Toolbar; Colophon;