Excel 2010 all-in-one for dummies : [8 books in 1: Excel basics - Worksheet design - Formulas and functions - Worksheet collaboration and review - Charts and graphics - Data management - Data analysis - Excel and VBA

A comprehensive, up-to-date, user-friendly guide to Excel 2010 Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface For Dummies books are the bestselling guides to Excel, with more than three million copies sold Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA. Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know. Excel® 2010 All-in-One For Dummies®......Page 5 About the Author......Page 7 Author’s Acknowledgments......Page 9 Contents at a Glance......Page 11 Table of Contents......Page 13 About This Book......Page 25 How This Book Is Organized......Page 26 Conventions Used in This Book......Page 30 Icons Used in This Book......Page 32 Where to Go from Here......Page 33 Book I: Excel Basics......Page 35 Contents at a Glance......Page 36 Chapter 1: The Excel 2010 User Experience......Page 37 Meet Excel’s Ribbon User Interface......Page 38 Launching and Quitting Excel......Page 53 Migrating to Excel 2010 from Earlier Versions Relying on Pull-Down Menus......Page 56 Browsing Excel 2010 Help......Page 73 Using the Table of Contents......Page 75 Searching Office Online for Help......Page 76 Tailoring the Quick Access Toolbar to Your Tastes......Page 81 Exercising Your Options......Page 84 Add-in Mania......Page 101 Book II: Worksheet Design......Page 105 Contents at a Glance......Page 106 Designer Spreadsheets......Page 107 It Takes All Kinds (Of Cell Entries)......Page 119 Data Entry 101......Page 125 Saving the Data......Page 142 Document Recovery to the Rescue......Page 148 Chapter 2: Formatting Worksheets......Page 151 Making Cell Selections......Page 152 Adjusting Columns and Rows......Page 160 Formatting Ranges as Tables with Table Styles......Page 164 Formatting Cells from the Home Tab......Page 168 Formatting the Cell Selection with the Mini Toolbar......Page 173 Using the Format Cells Dialog Box......Page 174 Hiring Out the Format Painter......Page 193 Using Cell Styles......Page 194 Conditional Formatting......Page 199 Opening a Workbook......Page 209 Cell Editing 101......Page 217 A Spreadsheet with a View......Page 224 Copying and Moving Stuff Around......Page 232 Find and Replace This Disgrace!......Page 242 Spell Checking Heaven......Page 247 Looking Up and Translating Stuff......Page 250 Marking Invalid Data......Page 252 Eliminating Errors with Text to Speech......Page 253 Reorganizing the Worksheet......Page 257 Reorganizing the Workbook......Page 272 Working with Multiple Workbooks......Page 282 Consolidating Worksheets......Page 286 Chapter 5: Printing Worksheets......Page 293 Printing from the Excel Backstage View......Page 294 Quick Printing the Worksheet......Page 300 Working with the Page Setup Options......Page 301 Headers and Footers......Page 308 Solving Page Break Problems......Page 314 Printing the Formulas in a Report......Page 317 Book III: Formulas and Functions......Page 319 Contents at a Glance......Page 320 Formulas 101......Page 321 Copying Formulas......Page 333 Adding Array Formulas......Page 340 Range Names in Formulas......Page 344 Adding Linking Formulas......Page 354 Controlling Formula Recalculation......Page 355 Circular References......Page 357 Understanding Error Values......Page 359 Using Logical Functions......Page 361 Error-Trapping Formulas......Page 362 Formula Auditing......Page 366 Removing Errors from the Printout......Page 378 Understanding Dates and Times......Page 379 Using Date Functions......Page 382 Using Time Functions......Page 390 Financial Functions 101......Page 393 Math & Trig Functions......Page 407 Statistical Functions......Page 415 Lookup and Reference......Page 425 Information, Please .........Page 436 Much Ado about Text......Page 440 Book IV: Worksheet Collaboration and Review......Page 445 Contents at a Glance......Page 446 Password-Protecting the File......Page 447 Protecting the Spreadsheet......Page 453 Hyperlinks 101......Page 467 Using the HYPERLINK Function......Page 473 Preparing a Workbook for Distribution......Page 475 Workbook Sharing 101......Page 483 Workbooks on Review......Page 495 Chapter 4: Sharing Worksheets and Worksheet Data......Page 501 Office 2010 Data Sharing Basics......Page 502 Using Smart Tags......Page 513 Saving Workbooks in Other Usable File Formats......Page 517 Publishing Workbooks to Shared Spaces......Page 522 Book V: Charts and Graphics......Page 527 Contents at a Glance......Page 528 Chapter 1: Charting Worksheet Data......Page 529 Worksheet Charting 101......Page 530 Selecting the Perfect Chart Type......Page 557 Adding Sparkline Graphics to a Worksheet......Page 563 Printing Charts......Page 565 Graphic Objects 101......Page 567 Importing Graphics......Page 575 Drawing Graphics......Page 580 Using Themes......Page 591 Book VI: Data Management......Page 593 Contents at a Glance......Page 594 Data List Basics......Page 595 Sorting Data......Page 607 Subtotaling Data......Page 616 Chapter 2: Filtering and Querying a Data List......Page 619 Filtering Data......Page 620 Using the Database Functions......Page 637 External Data Query......Page 640 Book VII: Data Analysis......Page 659 Contents at a Glance......Page 660 Chapter 1: Performing What-If Scenarios......Page 661 Using Data Tables......Page 662 Exploring Different Scenarios......Page 668 Hide and Goal Seeking......Page 673 Using the Solver......Page 675 Creating Pivot Tables......Page 685 Formatting a Pivot Table......Page 689 Sorting and Filtering the Pivot Table Data......Page 694 Modifying the Pivot Table......Page 699 Creating Pivot Charts......Page 704 Book VIII: Excel and VBA......Page 709 Contents at a Glance......Page 710 Chapter 1: Building and Running Macros......Page 711 Macro Basics......Page 712 Macro Security......Page 718 Assigning Macros to the Ribbon and the Quick Access Toolbar......Page 719 Chapter 2: VBA Programming......Page 723 Using the Visual Basic Editor......Page 724 Creating Custom Excel Functions......Page 738 Appendix: Using XML File Formats......Page 749 Index......Page 751 A reference guide explains how to use the diverse features of the spreadsheet program, discussing such topics as Excel basics, worksheet design, formulas and functions, charts and graphics, data management, VBA, Web applications, and data analysis.