Excel 2013 Bible

Front Cover
John Wiley & Sons, Feb 5, 2013 - Computers - 1056 pages
1 Review

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!


What people are saying - Write a review

User Review - Flag as inappropriate

i love the Excel 2013 Bible


Table of Contents
Creating Charts and Graphics
Identifying What Excel Is Good
Entering and Editing Worksheet Data
Essential Worksheet Operations
working with Cells and Ranges
Using Names to Work with Ranges
Selecting comments
Getting Started Making Charts
Enhancing Your Work with Pictures and Drawings
Using SmartArt
Working with Other Graphic Types
Using Adyanced Excel Features
Using Custom Number Formats
Using Data Validation
Creating and Using Worksheet Outlines

Worksheet Formatting
Understanding Excel Files
Using and Creating Templates
Printing Your Work
Working with Formulas and Functions
Creating Formulas That Manipulate Text
Summing Formulas
Creating Formulas That Look Up Values
Specia ized Lookup Formulas
Creating Formulas for Financial Applications
Miscellaneous Calculations
Introducing Array Formulas
Linking and Consolidating worksheets
Excel and the Internet
Protecting Your Work
Analyzing Data with Excel
Creating a calculated field
Performing Spreadsheet WhatIf Analysis
Analyzing Data Using Goal Seeking and Solver
Analyzing Data with the Analysis ToolPak
Part VI Programming Excel with
Declaring variable types
Adding descriptive information

Other editions - View all

Common terms and phrases

About the author (2013)

John Walkenbach (aka "Mr. Spreadsheet") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.

Bibliographic information