More Excel Outside The Box: Unbelievable Excel Techniques From Excel Mvp Bob Umlas by Bob UmlasMore Excel Outside The Box: Unbelievable Excel Techniques From Excel Mvp Bob Umlas by Bob Umlas

More Excel Outside The Box: Unbelievable Excel Techniques From Excel Mvp Bob Umlas

byBob Umlas

Paperback | July 1, 2015

Pricing and Purchase Info

$29.95

Earn 150 plum® points

Prices and offers may vary in store

Out of stock online

Available in stores

about

A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software’s most challenging problems. Through a series of more than 30 techniques, tables, formulas, and charts, this guide details processes that may be used in any Excel application and across all disciplines. Creative approaches for building formulas within formulas, pivot tables, conditional formatting, and mastering array formulas are just some of the numerous challenges explained. Other higher-level solutions discussed include using VBA macro code to override cell calculations, solve for sums from a text string, and trimming and cleaning all cells on a worksheet. This is the all-encompassing resource for advanced users of Excel wanting to learn more techniques to broaden and empower their knowledge of the program.
Bob Umlas is a Microsoft Excel MVP and the author of Excel Outside the Box and This Isn’t Excel, It’s Magic. He is a contributing editor to Inside Microsoft Excel who has written more than 300 articles on all aspects of the program. He was a coleader of New York City’s PC Excel Special Interest Group for more than a decade. He lives in...
Loading
Title:More Excel Outside The Box: Unbelievable Excel Techniques From Excel Mvp Bob UmlasFormat:PaperbackDimensions:112 pages, 9 × 6 × 0.68 inPublished:July 1, 2015Publisher:Holy Macro! BooksLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:1615470360

ISBN - 13:9781615470365

Reviews