John Walkenbach's Favorite Excel 2007 Tips & Tricks

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 rangeWalkenbach, John is the author of 'John Walkenbach's Favorite Excel 2007 Tips & Tricks ', published 2007 under ISBN 9780470137666 and ISBN 0470137665.