The Unofficial Guide to Microsoft Office Excel 2007

The inside scoop...for when you want more than the official line! Microsoft Office Excel 2007 may be just what you need to crunch numbers, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the secrets of pro users? Are there shortcuts for repetitive tasks? From writing formulas to using charts, first get the official way, then the best way from two experts. Unbiased coverage of how to get the most out of Excel 2007, from creating workbooks and writing formulas to comparing data Savvy, real-world advice to help you set up, enter, format, and organize your data Time-saving techniques and practical guidance on creating custom macros with VBA and using PivotTables and PivotCharts Tips and hacks with practical ways to save time, avoid pitfalls, and increase your output Sidebars, tables, and illustrations featuring toolbar buttons and more ways to be productive in Excel Watch for these graphic icons in every chapter to guide you to specific practicalinformation. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid commonpitfalls. And finally, check out Inside Scoops for practical insights from the author. It's like having your own expert at your side!

Table of Contents:
I Starting Out with Excel 2007. 1 Getting In and Out. Starting Excel. The Excel environment. Getting help. Opening workbook files. Using hyperlinks. Saving workbook files. Creating and using templates. Closing workbook files. Quitting Excel. Just the facts. 2 All About Worksheets. Worksheet basics. Selecting worksheets. Naming worksheets. Color-coding workbook contents. Rearranging worksheets. Adding and deleting worksheets. Moving around in a worksheet. Multiple windows. Zooming your view. Just the facts. II Crunching Numbers. 3 Entering and Editing Data. Entering data directly. Using data entry techniques. Creating a dynamic list/table. Validating data during entry. Editing cell entries. Finding and replacing data. Moving and copying data. Inserting, deleting, and rearranging. Breaking a column into multiple columns. Adding worksheet comments. Checking your spelling. Just the facts. 4 Working Data Magic with Calculations. Simple calculations, quick answers. About cell references. Writing formulas. Moving and copying formulas. Linking worksheets and workbooks. Using cell names. Editing formulas. Tracing a formula. Locating worksheet errors. Just the facts. 5 Excel Functions. Using functions. Common and useful functions. Combining functions for more power. Just the facts. III Dressing Up Your Data. 6 Formatting Cells. The Font and Alignment Ribbon groups. Formatting the font. Working with borders. Adding colors. Fitting the text in the cell. Copying formatting with Format Painter. Just the facts. 7 Formatting Numbers and Using Styles. Applying number formats to cells. Ribbon buttons for formats. The Format Cells dialog box. Formatting dates and times. Formatting text entries. Creating custom formats. Applying conditional number formats. Converting actual values to displayed values. Hiding zeroes. Using styles to streamline formatting. Just the facts. IV Organizing Data. 8 Organizing Data. Sorting lists. Filtering records. Calculating filtered records. The Query Wizard — A better filter. Query a Web page. Just the facts. 9 Finding and Comparing Answers. Consolidating a table. Subtotaling a table. Scenarios. Compare answers with data tables. Goal seeking for simple answers. Answering complex questions with Solver. Just the facts. 10 Summarizing Data Dynamically with PivotTables. Using PivotTables. PivotTable terms. Creating a PivotTable. The PivotTable Tools tab. Changing PivotTable arrangement. Changing PivotTable calculations. Showing underlying details. Formatting numbers. Just the facts. 11 Displaying PivotTables Graphically with PivotCharts. PivotCharts versus normal charts. Creating PivotCharts. Rearranging PivotCharts. Formatting PivotCharts. Embedding a PivotChart on a worksheet. Just the facts. V Presenting Your Data. 12 Presenting Data Visually with Charts. Creating a chart. The Charts group. Types of charts. Changing chart data. Quickly changing chart layout. Moving and resizing an embedded chart. Changing the chart location. Just the facts. 13 Formatting Charts. Chart formatting possibilities. Formatting chart elements. Changing axis scale. Reordering the series. Enlarging and exploding a pie chart. Changing 3-D perspective. Adding a trendline. Adding a secondary axis. Working with data labels. Creating picture markers. Saving and reusing your custom chart format. Just the facts. 14 Adding Pictures and Graphic Objects. Using the Shapes group. Drawing basic shapes. Formatting for all graphic objects. Creating AutoShapes. Drawing text boxes. Creating WordArt. Inserting pictures and clip art. Creating SmartArt. Pasting pictures of cells. Just the facts. VI Sharing Excel Data. 15 Printing Just What You Need. Previewing printed pages. Printing a quick copy of a worksheet. Printing part of a worksheet. Printing a chart. Printing several worksheets. Just the facts. 16 Formatting the Printed Page. Setting page breaks. Changing the page layout. Printing a specific number of pages. Printing row/column labels on every page. Creating a header or footer. Printing worksheet gridlines. Printing in black and white. Formatting printed charts. Just the facts. 17 Sharing a Workbook with Other Users. Sharing a workbook. Reviewing changes in a shared workbook. Sending and routing workbooks. Protecting workbooks and worksheets. Just the facts. 18 Sharing a Workbook Between Programs. Shared-data terminology. Sending data between Excel and Word. Sending data between Excel and Access. Pasting Excel data into PowerPoint. Dragging a hyperlink into Excel. Saving a worksheet as a Web page. Just the facts. VII Making Excel Your Own. 19 Customizing Your Workspace. Changing your screen display. Minimizing the Ribbon. Customizing the Quick Access toolbar. Personalizing features. Proofing options. Setting Advanced options. Just the facts. 20 Adding Controls to a Worksheet. What can worksheet controls do? Forms Controls. All worksheet controls. List boxes and combo boxes. Option buttons and group boxes. Scroll bars and spinners. Check boxes. Button controls. Labels. Just the facts. 21 Using Macros to Automate Repetitive Work. Introducing macros. Recording a macro. Running a macro. Exploring the Visual Basic Editor. Editing a macro. Deleting a macro. Setting macro virus protection. Just the facts. VIII Appendixes. Appendix A: Build Creative Worksheets. Appendix B: Recommended Resources. Glossary. Index.

About the Author :
Julia Kelly lives in rural north Idaho with horses, cats, small garden dogs, assorted wild animals, free-range chickens, and bird dogs who’ve finally learned not to “retrieve” the free-range chickens. Curt Simmons lives in Saint Jo, Texas, with his wife and two daughters. The author of more than 50 computing books on a wide range of topics, he primarily writes about Microsoft products. When he is not writing, Curt enjoys gardening and working on his 107-year-old home. Julia Kelly lives in rural north Idaho with horses, cats, small garden dogs, assorted wild animals, free-range chickens, and bird dogs who’ve finally learned not to “retrieve” the free-range chickens. Curt Simmons lives in Saint Jo, Texas, with his wife and two daughters. The author of more than 50 computing books on a wide range of topics, he primarily writes about Microsoft products. When he is not writing, Curt enjoys gardening and working on his 107-year-old home.