The Leading eBooks Store Online
for Kindle Fire, Apple, Android, Nook, Kobo, PC, Mac, BlackBerry ...
Excel Outside the Box
Unbelieveable Excel Techniques from Excel MVP Bob Umlas
Designed with the Excel guru in mind, this handbook introduces advanced and creative solutions, and hacks to 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, 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.
256 pages; ISBN 9781615473038
, or download in or
Visual Basic in Easy Steps 2011 US$ 14.99 193 pages
Using Google Maps and Google Earth 2011 US$ 19.99 360 pages
A Practical Guide to Linux Commands, Editors, and Shell Programming, 3e 2012 US$ 39.99 1224 pages
HTML and CSS 2011 US$ 29.99 514 pages