Introduction , 1 About This Book 1 Foolish Assumptions 2 How This Book Is Organized 3 Book I: Excel Basics 3 Book II: Worksheet Design 3 Book III: Formulas and Functions 4 Book IV: Worksheet Collaboration and Review 5 Book V: Charts and Graphics 5 Book VI: Data Management 6 Book VII: Data Analysis 6 Book VIII: Macros and VBA 6 Conventions Used in This Book 7 Icons Used in This Book 8 Where to Go from Here 9 Book I: Excel Basics , 11 Chapter 1: The Excel 2013 User Experience , 13 Chapter 2: Customizing Excel 2013 , 41 Book II: Worksheet Design , 73 Chapter 1: Building Worksheets 75 Chapter 2: Formatting Worksheets 125 Chapter 3: Editing and Proofing Worksheets 183 Chapter 4: Managing Worksheets 231 Chapter 5: Printing Worksheets 269 Book III: Formulas and Functions , 297 Chapter 1: Building Basic Formulas 299 Chapter 2: Logical Functions and Error Trapping 339 Chapter 3: Date and Time Formulas 361 Chapter 4: Financial Formulas , , , , 375 Chapter 5: Math and Statistical Formulas 389 Chapter 6: Lookup, Information, and Text Formulas , 409 Book IV: Worksheet Collaboration and Review , 431 Chapter 1: Protecting Workbooks and Worksheet Data , 433 Chapter 2: Using Hyperlinks 455 Chapter 3: Sending Workbooks Out for Review 463 Chapter 4: Sharing Workbooks and Worksheet Data 489 Book V: Charts and Graphics , 513 Chapter 1: Charting Worksheet Data 515 Chapter 2: Adding Graphic Objects , 545 Book VI: Data Management , 575 Chapter 1: Building and Maintaining Data Lists 577 Chapter 2: Filtering and Querying a Data List 601 Book VII: Data Analysis , 643 Chapter 1: Performing What–If Scenarios 645 Chapter 2: Generating Pivot Tables , , , , 667 Book VIII: Macros and VBA , 707 Chapter 1: Building and Running Macros 709 Chapter 2: VBA Programming 721 Index , 745