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.
Format:Paperback
Language:English
ISBN:1615470107
ISBN13:9781615470105
Release Date:April 2012
Publisher:Holy Macro! Books
Length:192 Pages
Weight:0.74 lbs.
Dimensions:0.5" x 7.3" x 9.1"
Recommended
Format: Paperback
Condition: New
$23.58
Save $1.37!
List Price $24.95
On Backorder
If the item is not restocked at the end of 90 days, we will cancel your backorder and issue you a refund.
ThriftBooks sells millions of used books at the lowest
everyday prices. We personally assess every book's quality and offer rare, out-of-print treasures. We
deliver the joy of reading in recyclable packaging with free standard shipping on US orders over $15.
ThriftBooks.com. Read more. Spend less.