You are previewing Excel 2013 Bible.
O'Reilly logo
Excel 2013 Bible

Book Description

Excel at Excel with the help of this bestselling spreadsheet guide

John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.

Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.

  • Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013

  • Provides essential coverage of all the newest features of Excel 2013

  • Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience

  • Features a website that includes downloadable templates and worksheets from the book

Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!

Table of Contents

  1. Cover
  2. Table of Contents
  3. Title Page
  4. Introduction
  5. Part I: Getting Started with Excel
    1. Chapter 1: Introducing Excel
    2. Chapter 2: Entering and Editing Worksheet Data
    3. Chapter 3: Essential Worksheet Operations
    4. Chapter 4: Working with Cells and Ranges
    5. Chapter 5: Introducing Tables
    6. Chapter 6: Worksheet Formatting
    7. Chapter 7: Understanding Excel Files
    8. Chapter 8: Using and Creating Templates
    9. Chapter 9: Printing Your Work
  6. Part II: Working with Formulas and Functions
    1. Chapter 10: Introducing Formulas and Functions
    2. Chapter 11: Creating Formulas That Manipulate Text
    3. Chapter 12: Working with Dates and Times
    4. Chapter 13: Creating Formulas That Count and Sum
    5. Chapter 14: Creating Formulas That Look Up Values
    6. Chapter 15: Creating Formulas for Financial Applications
    7. Chapter 16: Miscellaneous Calculations
    8. Chapter 17: Introducing Array Formulas
    9. Chapter 18: Performing Magic with Array Formulas
  7. Part III: Creating Charts and Graphics
    1. Chapter 19: Getting Started Making Charts
    2. Chapter 20: Learning Advanced Charting
    3. Chapter 21: Visualizing Data Using Conditional Formatting
    4. Chapter 22: Creating Sparkline Graphics
    5. Chapter 23: Enhancing Your Work with Pictures and Drawings
  8. Part IV: Using Advanced Excel Features
    1. Chapter 24: Customizing the Excel User Interface
    2. Chapter 25: Using Custom Number Formats
    3. Chapter 26: Using Data Validation
    4. Chapter 27: Creating and Using Worksheet Outlines
    5. Chapter 28: Linking and Consolidating Worksheets
    6. Chapter 29: Excel and the Internet
    7. Chapter 30: Protecting Your Work
    8. Chapter 31: Making Your Worksheets Error Free
  9. Part V: Analyzing Data with Excel
    1. Chapter 32: Importing and Cleaning Data
    2. Chapter 33: Introducing Pivot Tables
    3. Chapter 34: Analyzing Data with Pivot Tables
    4. Chapter 35: Performing Spreadsheet What-If Analysis
    5. Chapter 36: Analyzing Data Using Goal Seeking and Solver
    6. Chapter 37: Analyzing Data with the Analysis ToolPak
  10. Part VI: Programming Excel with VBA
    1. Chapter 38: Introducing Visual Basic for Applications
    2. Chapter 39: Creating Custom Worksheet Functions
    3. Chapter 40: Creating UserForms
    4. Chapter 41: Using UserForm Controls in a Worksheet
    5. Chapter 42: Working with Excel Events
    6. Chapter 43: VBA Examples
    7. Chapter 44: Creating Custom Excel Add-Ins
  11. Part VII: Appendixes
    1. Appendix A: Worksheet Function Reference
    2. Appendix B: Excel Shortcut Keys