Excel 2007 is an entirely new creature. There's a new user interface, new open file formats, a larger worksheet grid, better use of memory and CPUs, new functions, more templates, even options that let you change the look of the entire program. To get the most from it, serious Excel users like you need the expertise only John Walkenbach can provide.
Here, Mr. Spreadsheet shares his secrets for dealing with function arguments, creating "impossible" charts, taming the Ribbon, working with absolute versus relative references, changing data entry orientation, overcoming the 7-level nesting limit, and so much more.
Part I: Basic Excel Usage
Part II: Data Entry
Part III: Formatting
Part IV: Basic Formulas and Functions
Part V: Useful Formula Examples
Part VI: Conversions and Mathematical Calculations
Part VII: Charts and Graphics
Part VIII: Data Analysis and Lists
Part IX: Working With Files
Part X: Printing
Part XI: Spotting, Fixing, and Preventing Errors
Part XII: Basic VBA and Macros
Part XIII: Sources for Excel Information