John Walkenbach's Favorite Excel® 2010 Tips & Tricks

John Walkenbach's Favorite Excel® 2010 Tips & Tricks

Author(s): John Walkenbach

Published Online: 11 NOV 2011 03:51PM EST

Print ISBN: 9780470475379

Online ISBN: 9781118257647

DOI: 10.1002/9781118257647

About this Book

Build robust Excel 2010 apps quickly and efficiently

Known as "Mr. Spreadsheet," John Walkenbach's name is synonymous with excellence in computer books that explain the complexities of various topics. With this collection of favorite Excel tips and tricks, you get a unique look at ways to make Excel 2010 more efficient than you ever imagined.

Packed with easy-to-understand advice regarding all aspects of Excel, this book shares improved ways of speeding up application development with Excel and maximizing the power of Excel to create robust applications.

  • Addresses the extensive changes to the 2010 version of Excel and shares tricks and shortcuts for making your Excel experience as successful and efficient as possible
  • Reveals ways to deal with function arguments, create "impossible" charts, and tame the Ribbon bar
  • Discusses absolute vs. relative references, change data entry orientation, and sort more than three columns
  • Demonstrates ways to enter fake data for testing purposes

With John Walkenbach's Favorite Excel 2010 Tips and Tricks, you'll get a jump start on mastering the extensive changes to the 2010 version of Excel.

Table of contents

    1. You have free access to this content
  1. Part I: Basic Excel Usage

  2. Part II: Data Entry

  3. Part III: Formatting

  4. Part IV: Basic Formulas and Functions

  5. Part V: Useful Formula Examples

  6. Part VI: Conversions and Mathematical Calculations

  7. Part VII: Charts and Graphics

  8. Part VIII: Data Analysis and Lists

  9. Part IX: Working with Files

  10. Part X: Printing

  11. Part XI: Spotting, Fixing, and Preventing Errors

  12. Part XII: Basic VBA and Macros

    1. You have free access to this content
    1. You have free access to this content

SEARCH