John Walkenbach's Favorite Excel 2007 Tips and Tricks
von John WalkenbachJohn Walkenbach comments on the new Excel: "I've been using Excelfor over 15 years, and Excel 2007 is by far the most significantupgrade ever. For starters, we've got a new user interface, newopen file formats, a larger worksheet grid, better use of memoryand CPUs, new functions, and more templates. Dig a bit deeper andyou'll find worksheet tables, 100 levels of undo, easier formulaconstruction, better-looking charts, unlimited color choices, SmartArt, a handy page layout view, new conditional formattingoptions, new collaboration features, a very useful compatibilitychecker, workbook themes--and even 'skins' so you can changethe look of the entire program." John Walkenbach's Favorite Excel 2007 Tips & Tricksconsists of a series of non-trivial tips and tricks that cover allaspects of Excel. Tips are improved ways of maximizing the power ofExcel to create robust applications. Tricks are shortcuts that willspeed up application development with Excel.
John's favorites include tips and tricks on dealing withfunction arguments, creating „impossible“ charts, pivot tables, taming the new Ribbon, why use a UserForm, how to create add-ins inExcel 2007, absolute vs. relative references, changing data entryorientation, overcoming the 7-level nesting limit, dynamic chartdata, sorting on more than three columns, entering fake data fortesting purposes, custom functions, and much more.
John's favorites include tips and tricks on dealing withfunction arguments, creating „impossible“ charts, pivot tables, taming the new Ribbon, why use a UserForm, how to create add-ins inExcel 2007, absolute vs. relative references, changing data entryorientation, overcoming the 7-level nesting limit, dynamic chartdata, sorting on more than three columns, entering fake data fortesting purposes, custom functions, and much more.
