Mr. Spreadsheet's Excel 2007 Library
Seiten
2007
John Wiley & Sons Ltd (Verlag)
978-0-470-17654-2 (ISBN)
John Wiley & Sons Ltd (Verlag)
978-0-470-17654-2 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
The perennial bestseller, updated for Excel 2007 Equally valuable for beginners and power users, this book is packed with examples, techniques, and tips from Mr. Spreadsheet. Here's how to: * Understand formulas, functions, tables, worksheets, and workbooks * Explore unlimited conditional formatting * Develop custom functions and create UserForms * Analyze data with external database files and pivot tables * Enhance worksheets with SmartArt tools * Customize the Quick Access Toolbar to save time Create killer formulas that let you do more If you know Excel basics, Mr. Spreadsheet can help you create financial formulas, develop custom worksheet functions, and greatly extend Excel's capabilities. You can: * Release the power of array formulas * Master operators, error values, and absolute vs. relative references * Find errors and debug your formulas * Eliminate formulas by using pivot tables * Create single- and multi-cell array formulas * Use VBA to build custom functions Expand Excel with VBA, and feel the power This power-user's guide is packed with procedures, tips, and ideas for expanding Excel with Visual Basic for Applications. Mr.
Spreadsheet helps you: * Create powerful Excel applications * Enhance Excel with VBA macros * Expand Excel's shortcut menus * Customize UserForms and develop new utilities * Write event-driven code * Build user-friendly toolbars, menus, and help systems Get acquainted with Excel 2007's all-new features There's a new user interface, new open file formats, a larger worksheet grid, better use of memory, new functions and templates, and more. Learn to: * Manage the Ribbon * Deal with function arguments * Change data entry orientation * Create a drop-down list in a cell * Convert a vertical range to a table * Change the look of the entire program Nobody knows Excel like Mr. Spreadsheet! Excel 2007 Bible Excel 2007 Formulas Excel 2007 Power Programming with VBA John Walkenbach's Favorite Excel 2007 Tips & Tricks Bonus CD-ROM Award-winning Power Utility Pak on CD-ROM! Mr. Spreadsheet's Excel 2007 Library also includes a full, licensed version of John Walkenbach's famous Power Utility Pak, updated for Excel 2007 and valued at $40 US. It's a valuable collection of add-ins, providing additional functionality that will make your life with Excel easier!
Spreadsheet helps you: * Create powerful Excel applications * Enhance Excel with VBA macros * Expand Excel's shortcut menus * Customize UserForms and develop new utilities * Write event-driven code * Build user-friendly toolbars, menus, and help systems Get acquainted with Excel 2007's all-new features There's a new user interface, new open file formats, a larger worksheet grid, better use of memory, new functions and templates, and more. Learn to: * Manage the Ribbon * Deal with function arguments * Change data entry orientation * Create a drop-down list in a cell * Convert a vertical range to a table * Change the look of the entire program Nobody knows Excel like Mr. Spreadsheet! Excel 2007 Bible Excel 2007 Formulas Excel 2007 Power Programming with VBA John Walkenbach's Favorite Excel 2007 Tips & Tricks Bonus CD-ROM Award-winning Power Utility Pak on CD-ROM! Mr. Spreadsheet's Excel 2007 Library also includes a full, licensed version of John Walkenbach's famous Power Utility Pak, updated for Excel 2007 and valued at $40 US. It's a valuable collection of add-ins, providing additional functionality that will make your life with Excel easier!
Erscheint lt. Verlag | 28.8.2007 |
---|---|
Reihe/Serie | Mr. Spreadsheet's Bookshelf |
Verlagsort | Chichester |
Sprache | englisch |
Maße | 422 x 528 mm |
Gewicht | 5 g |
Themenwelt | Informatik ► Office Programme ► Excel |
ISBN-10 | 0-470-17654-7 / 0470176547 |
ISBN-13 | 978-0-470-17654-2 / 9780470176542 |
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
Komplett in Farbe. Ideal für alle Einsteiger, Umsteiger und auch …
Buch | Softcover (2022)
Markt + Technik Verlag
CHF 18,10
Datenanalyse und Reporting mit Power Query, Power Pivot und Power BI …
Buch (2023)
Carl Hanser (Verlag)
CHF 62,95