312 страниц. 2013 год. 101 Excel 2013 Tips, Tricks & Timesavers consists of a series of non-trivial tips and tricks that cover all aspects of Excel. Tips are improved ways of maximizing the power of Excel to create robust applications. Tricks are shortcuts that will speed up application development with Excel. John Walkenbach shares his favorites, including tips and tricks dealing with function arguments, creating "impossible" charts, pivot tables, taming the Ribbon bar, using UserForms, creating add-ins, absolute vs. relative references, changing data entry orientation, overcoming the 7-level nesting limit, dynamic chart data, sorting more than three columns, entering fake data for testing purposes, custom functions, and much, much more. This book is packed with information that every user needs in order to become a power user and to master the challenges that come with using Excel!