Excel All-in-One For Dummies

Table of contents

1. Cover
2. Title Page
3. Copyright
4. Introduction
   1. About This Book
   2. Foolish Assumptions
   3. Conventions Used in This Book
   4. Icons Used in This Book
   5. Beyond the Book
   6. Where to Go from Here
5. Book 1: Excel Basics
   1. Chapter 1: Excel: The 50-Cent Tour
      1. A Bird's-Eye View of Excel
      2. Checking Out Excel’s Start Screen
      3. Getting Comfy with the Excel User Interface
      4. Getting Help
      5. Launching and Quitting Excel
   2. Chapter 2: Customizing Excel
      1. Tailoring the Quick Access Toolbar to Your Tastes
      2. Exercising Your Options
      3. Using Office Add-ins
      4. Using Excel’s Own Add-ins
6. Book 2: Worksheet Design
   1. Chapter 1: Building Worksheets
      1. Creating Fresh Workbooks
      2. Getting to Know Excel's Data Types
      3. Data Entry 101
      4. Linking to Other Documents
      5. Saving the Data
      6. Document Recovery to the Rescue
   2. Chapter 2: Formatting Worksheets
      1. Selecting Cells and Ranges
      2. Adjusting Columns and Rows
      3. Formatting Tables from the Ribbon
      4. Formatting Tables with the Quick Analysis Tool
      5. Formatting Cells from the Ribbon
      6. Formatting Cell Ranges with the Mini-Toolbar
      7. Using the Format Cells Dialog Box
      8. Hiring Out the Format Painter
      9. Easier Formatting with Cell Styles
      10. Analyzing Data with Conditional Formatting
   3. Chapter 3: Editing and Proofing Worksheets
      1. Opening a Workbook
      2. Editing a Cell
      3. A Worksheet with a View
      4. Copying and Moving Stuff Around
      5. Finding and Replacing Worksheet Data
      6. Getting It Right: Spell Checking Your Worksheets
      7. Looking Up and Translating Stuff
      8. Marking Invalid Data
   4. Chapter 4: Managing Worksheets
      1. Reorganizing the Worksheet
      2. Reorganizing the Workbook
      3. Working with Multiple Workbooks
      4. Consolidating Worksheets
   5. Chapter 5: Printing Worksheets
      1. Printing from the Backstage View
      2. Quick Printing the Worksheet
      3. Working with the Page Setup Options
      4. Headers and Footers
      5. Solving Page Break Problems
      6. Printing the Formulas in a Report
7. Book 3: Formulas and Functions
   1. Chapter 1: Building Basic Formulas
      1. Getting Started with Formulas
      2. Augmenting Formulas with Worksheet Functions
      3. Copying Formulas
      4. Adding Array Formulas
      5. Naming Cells and Ranges
      6. Adding Linking Formulas
      7. Controlling Formula Recalculation
      8. Circular References
   2. Chapter 2: Logical Functions and Error Trapping
      1. Understanding Error Values
      2. Using Logical Functions
      3. Error-Trapping Formulas
      4. Whiting-Out Errors with Conditional Formatting
      5. Checking It Twice: Auditing Your Formulas
      6. Removing Errors from the Printout
   3. Chapter 3: Date and Time Formulas
      1. Understanding Dates and Times
      2. Using Date Functions
      3. Using Time Functions
   4. Chapter 4: Finagling Financial Formulas
      1. Some Financial Function Basics Before You Begin
      2. The PV, NPV, and FV Functions
      3. The PMT Function
      4. Depreciation Functions
      5. Excel's Advanced Financial Functions
   5. Chapter 5: Math and Statistical Formulas
      1. Math & Trig Functions
      2. Statistical Functions
   6. Chapter 6: Lookup, Information, and Text Formulas
      1. Looking Up Stuff with the Lookup Functions
      2. Getting Cell Reference Info with the Reference Functions
      3. Interrogating Excel
      4. Working with Text Functions and Formulas
8. Book 4: Worksheet Collaboration and Review
   1. Chapter 1: Protecting Workbooks and Worksheet Data
      1. Password-Protecting the Workbook
      2. Setting Up Worksheet Data Protection
      3. Protecting the Workbook Structure
   2. Chapter 2: Preparing a Workbook for Distribution
      1. Getting Your Workbook Ready for Review
      2. Annotating Workbooks
   3. Chapter 3: Sharing Workbooks and Worksheet Data
      1. Sharing Your Workbooks Online
      2. Sharing Your Workbooks via Email
      3. Sharing Excel Data with Office Programs
      4. Making Shared Workbooks Accessible
      5. Exporting Workbooks to Other Usable File Formats
      6. Collaborating Conversationally with Comments
9. Book 5: Charts and Graphics
   1. Chapter 1: Charting Worksheet Data
      1. Worksheet Charting 101
      2. Adding Sparkline Graphics to a Worksheet
      3. Adding Infographics to a Worksheet
      4. Printing Charts
   2. Chapter 2: Adding Graphic Objects
      1. Going Graphical: The Basics of Working with Graphic Objects
      2. Inserting Different Types of Graphics
      3. Making Changes to Graphics
      4. Drawing Graphics
      5. Adding Screenshots of the Windows Desktop
      6. Using Themes
10. Book 6: Data Management
    1. Chapter 1: Building and Maintaining Tables
       1. Table Basics
       2. Sorting Table Data
       3. Subtotaling Table Data
    2. Chapter 2: Filtering and Querying a Table
       1. Filtering Data
       2. Using the Database Functions
       3. Querying External Data
11. Book 7: Data Analysis
    1. Chapter 1: Performing What-If Analysis
       1. Using Data Tables
       2. Exploring Different Scenarios
       3. Hide and Goal Seeking
       4. Using Solver
    2. Chapter 2: Performing Large-Scale Data Analysis
       1. Creating PivotTables
       2. Formatting a PivotTable
       3. Sorting and Filtering the PivotTable Data
       4. Modifying the PivotTable
       5. Creating PivotCharts
       6. Using the Power Pivot Add-in
       7. Using the 3D Maps Feature
       8. Creating Forecast Worksheets
12. Book 8: Macros and VBA
    1. Chapter 1: Recording and Running Macros
       1. Macro Basics
       2. Assigning Macros to the Ribbon and the Quick Access Toolbar
       3. Macro Security
    2. Chapter 2: VBA Programming
       1. Using the Visual Basic Editor
       2. Creating Custom Excel Functions
13. Index
14. About the Authors
15. Connect with Dummies
16. End User License Agreement