Excel 2010 Tips and Tricks pdf

约翰·沃肯巴赫 (John Walkenbach) 是一位多产且畅销的 Microsoft Excel 作家，写作风格清晰直接。 他撰写了 50 多本有关 Excel 的书籍，包括有关 VBA、公式和畅销 Excel 圣经系列的书籍。 John 过去还维护电子表格页面.com 网站，但它不再在线。

Excel 2010 Tips and Tricks pdf 约翰沃肯巴赫

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.