Excel Outside the Box
Proud to be B-Corp
The feel-good place to buy books
Excel Outside the Box by Bob Umlas
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.
"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
Bob Umlas is the original Excel Trickster. He was an Excel MVP for 25 years (1993-2018). He currently leads an online Master Class in Excel which is 12 3-hour sessions and a VBA class which is 2 3-hour sessions. He has presented at various global events (EIEFreshTalk and GlobalExcelSummit) with 9400 and 1750+ participants, respectively!
| SKU | Nicht verfügbar |
| ISBN 13 | 9781615470105 |
| ISBN 10 | 1615470107 |
| Titel | Excel Outside the Box |
| Autor | Bob Umlas |
| Buchzustand | Nicht verfügbar |
| Bindungsart | Paperback |
| Verlag | Holy Macro! Books |
| Erscheinungsjahr | 2012-04-01 |
| Seitenanzahl | 192 |
| Hinweis auf dem Einband | Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden. |
| Hinweis | Nicht verfügbar |