More Excel Outside the Box
Unbelievable Excel Techniques from Excel MVP Bob Umlas
Seiten
2015
Holy Macro! Books (Verlag)
978-1-61547-036-5 (ISBN)
Holy Macro! Books (Verlag)
978-1-61547-036-5 (ISBN)
A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software’s most challenging problems. Through a series of more than 30 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 knowledge of the program.
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!
Erscheint lt. Verlag | 1.7.2015 |
---|---|
Zusatzinfo | Illustrations |
Verlagsort | Uniontown |
Sprache | englisch |
Maße | 152 x 228 mm |
Gewicht | 185 g |
Themenwelt | Mathematik / Informatik ► Informatik ► Grafik / Design |
Informatik ► Office Programme ► Excel | |
ISBN-10 | 1-61547-036-0 / 1615470360 |
ISBN-13 | 978-1-61547-036-5 / 9781615470365 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
raffinierte Zaubereien für Excel-Kenner
Buch | Softcover (2024)
Markt + Technik (Verlag)
CHF 34,90
Datenanalyse und Reporting mit Power Query, Power Pivot und Power BI …
Buch (2023)
Carl Hanser (Verlag)
CHF 62,95
Das umfassende Handbuch für Einsteiger und fortgeschrittene Anwender
Buch | Hardcover (2022)
Rheinwerk (Verlag)
CHF 69,85