Excel 2013 All-in-One For Dummies

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