John Walkenbach's Favorite Excel 2007 Tips and Tricks
By John Walkenbach
Publisher: Wiley
Released: December 2008
Pages: 552

Nobody knows Excel 2007 like Mr. Spreadsheet

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.

Mr. Spreahsheet's TOP TIPS

  • Top Tip #18 Taking a picture of a range
  • Top Tip #43 Creating a drop-down list in a cell
  • Top Tip #50 Updating old fonts
  • Top Tip #60 Converting a vertical range to a table
  • Top Tip #107 Displaying a calendar in a range
Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $39.99
Formats:  ePub, Mobi, PDF