Excel Outside the Box
Excel Outside the Box

Excel Outside the Box

Unbelieveable Excel Techniques from Excel MVP Bob Umlas

COMPUTERS

256 Pages, 7.5 x 9.25

Formats: ebook: EPUB, ebook: PDF, Mobipocket

ebook: PDF, $17.95 (US $17.95) (CA $18.95)

Publication Date: April 2012

ISBN 9781615472031

eBook

eBook Editions Available

Will it work on my eReader?
Price: $17.95
NOTE: You are attempting to order an e-book. Please see will it work on my eReader? for directions on how to enjoy this book on your eReader device.
 
add ebook to cart
 

Overview

Wildly advanced applications for non-traditional solutions

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.

Reviews

"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

Author Biography

Bob Umlas is an Excel maven who has been awarded the title of Microsoft Excel MVP in recognition of his ongoing contributions to various online news groups. He is the author of This Isn’t Excel, It’s Magic and 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 Palisades, New York.

Need Help with
Your Order?

Contact IPG:

1-800-888-4741

[email protected]

Need Help with
Your Order?

Contact IPG:

1-800-888-4741

[email protected]