Excel Outside the Box: Unbelieveable Excel Techniques from Excel MVP Bob Umlas

Excel Outside the Box: Unbelieveable Excel Techniques from Excel MVP Bob Umlas

by Bob Umlas
     
 

View All Available Formats & Editions

Designed with the Excel guru in mind, this handbook introduces advanced and creative solutions and hacks for the software’s most challenging problems. Through a series of more than 50 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

See more details below

Overview

Designed with the Excel guru in mind, this handbook introduces advanced and creative solutions and hacks for the software’s most challenging problems. Through a series of more than 50 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 use of Excel.

Editorial Reviews

From the Publisher

"Seemingly impossible Excel challenges made simple! Another excellent book for the intermediate to advanced Excel addict, by Excel emperor Bob Umlas."  —Jan Karel Pieterse, Excel MVP

Product Details

ISBN-13:
9781615470105
Publisher:
Holy Macro! Books
Publication date:
04/01/2012
Pages:
192
Sales rank:
1,329,303
Product dimensions:
7.20(w) x 9.20(h) x 0.50(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >