Excel® 2013 All-in-One For Dummies® -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- How This Book Is Organized -- Conventions Used in This Book -- Icons Used in This Book -- Where to Go from Here -- Contents at a Glance -- Book I: Excel Basics -- Contents at a Glance -- Chapter 1: The Excel 2013 User Experience -- Excel 2013's New Look and Feel -- Excel's Start Screen -- Excel's Ribbon User Interface -- Getting Help -- Launching and Quitting Excel -- Chapter 2: Customizing Excel 2013 -- Tailoring the Quick Access Toolbar to Your Tastes -- Exercising Your Options -- Using Office Apps -- Add-In Mania -- Book II: Worksheet Design -- Contents at a Glance -- Chapter 1: Building Worksheets -- Designer Spreadsheets -- It Takes All Kinds (Of Cell Entries) -- Data Entry 101 -- Saving the Data -- Document Recovery to the Rescue -- Chapter 2: Formatting Worksheets -- Making Cell Selections -- Adjusting Columns and Rows -- Formatting Tables from the Ribbon -- Formatting Tables with the Quick Analysis Tool -- Formatting Cells from the Ribbon -- Formatting Cell Ranges with the Mini-Toolbar -- Using the Format Cells Dialog Box -- Hiring Out the Format Painter -- Using Cell Styles -- Conditional Formatting -- Chapter 3: Editing and Proofing Worksheets -- Opening a Workbook -- Cell Editing 101 -- A Spreadsheet with a View -- Copying and Moving Stuff Around -- Find and Replace This Disgrace! -- Spell Checking Heaven -- Looking Up and Translating Stuff -- Marking Invalid Data -- Eliminating Errors with Text to Speech -- Chapter 4: Managing Worksheets -- Reorganizing the Worksheet -- Reorganizing the Workbook -- Working with Multiple Workbooks -- Consolidating Worksheets -- Chapter 5: Printing Worksheets -- Printing from the Excel 2013 Backstage View -- Quick Printing the Worksheet -- Working with the Page Setup Options.

Headers and Footers -- Solving Page Break Problems -- Printing the Formulas in a Report -- Book III: Formulas and Functions -- Contents at a Glance -- Chapter 1: Building Basic Formulas -- Formulas 101 -- Copying Formulas -- Adding Array Formulas -- Range Names in Formulas -- Adding Linking Formulas -- Controlling Formula Recalculation -- Circular References -- Chapter 2: Logical Functions and Error Trapping -- Understanding Error Values -- Using Logical Functions -- Error-Trapping Formulas -- Whiting-Out Errors with Conditional Formatting -- Formula Auditing -- Removing Errors from the Printout -- Chapter 3: Date and Time Formulas -- Understanding Dates and Times -- Using Date Functions -- Using Time Functions -- Chapter 4: Financial Formulas -- Financial Functions 101 -- The PV, NPV, and FV Functions -- The PMT Function -- Depreciation Functions -- Analysis ToolPak Financial Functions -- Chapter 5: Math and Statistical Formulas -- Math & Trig Functions -- Statistical Functions -- Chapter 6: Lookup, Information, and Text Formulas -- Lookup and Reference -- Information, Please . . . -- Much Ado about Text -- Book IV: Worksheet Collaboration and Review -- Contents at a Glance -- Chapter 1: Protecting Workbooks and Worksheet Data -- Password-Protecting the File -- Protecting the Spreadsheet -- Chapter 2: Using Hyperlinks -- Hyperlinks 101 -- Using the HYPERLINK Function -- Chapter 3: Sending Workbooks Out for Review -- Preparing a Workbook for Distribution -- Workbook Sharing 101 -- Workbooks on Review -- Chapter 4: Sharing Workbooks and Worksheet Data -- Sharing Your Workbooks Online -- Excel 2013 Data Sharing Basics -- Exporting Workbooks to Other Usable File Formats -- Book V: Charts and Graphics -- Contents at a Glance -- Chapter 1: Charting Worksheet Data -- Worksheet Charting 101 -- Adding Sparkline Graphics to a Worksheet -- Printing Charts.

Chapter 2: Adding Graphic Objects -- Graphic Objects 101 -- Inserting Different Types of Graphics -- Drawing Graphics -- Adding Screenshots of the Windows Desktop -- Using Themes -- Book VI: Data Management -- Contents at a Glance -- Chapter 1: Building and Maintaining Data Lists -- Data List Basics -- Sorting Data -- Subtotaling Data -- Chapter 2: Filtering and Querying a Data List -- Data List Filtering 101 -- Filtering Data -- Using the Database Functions -- External Data Query -- Book VII: Data Analysis -- Contents at a Glance -- Chapter 1: Performing What-If Scenarios -- Using Data Tables -- Exploring Different Scenarios -- Hide and Goal Seeking -- Using the Solver -- Chapter 2: Generating Pivot Tables -- Creating Pivot Tables -- Formatting a Pivot Table -- Sorting and Filtering the Pivot Table Data -- Modifying the Pivot Table -- Creating Pivot Charts -- Using the PowerPivot and Power View Add-Ins -- Book VIII: Macros and VBA -- Contents at a Glance -- Chapter 1: Building and Running Macros -- Macro Basics -- Macro Security -- Assigning Macros to the Ribbon and the Quick Access Toolbar -- Chapter 2: VBA Programming -- Using the Visual Basic Editor -- Creating Custom Excel Functions -- Index.