101 Excel 2013 Tips,Tricks and Timesavers

101 Excel 2013 Tips,Tricks and Timesavers
Authors: John Walkenbach
ISBN-10: 111864218X
ISBN-13: 9781118642184
Edition 版本:‏ 1
Released: 2013-07-01
Print Length 页数: 320 pages
Get the most out of Excel 2013 with this exceptional advicefrom Mr. Spreadsheet himself!
Excel 2013 is excellent,but there’s lots to learn to trulyexcel at Excel! In this latest addition to his popular Mr.Spreadsheet’s Bookshelf series,John Walkenbach,aka “Mr.Spreadsheet,” shares new and exciting ways to accomplish and masterall of your spreadsheet tasks. From taming the Ribbon bar totesting and tables,creating custom functions,and overcoming”impossible” charts,mixing nesting limits,and more,101 Excel2013 Tips,Tricks,& Timesavers will save you time and helpyou avoid common spreadsheet stumbling blocks.
Reveals ways to maximize the power of Excel to create robustapplications
Draws on John Walkenbach’s years of experience using Excel andwriting more than 50 books
Shares tips and tricks for dealing with function arguments,creating add-ins,using UserForms,working with dynamic chart data,and changing data entry orientation
Provides shortcuts and helpful techniques for sorting more thanthree columns,entering fake data for testing purposes,and settingup powerful pivot tables
101 Excel 2013 Tips,Tricks,& Timesavers is packedwith information that you need to know in order to confidently andseamlessly master the challenges that come with using Excel!