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.
* 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.
* 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
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!
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His forty-plus books include Excel "2007 Power Programming with VBA," "Excel 2007 Formulas," and the bestselling "Excel 2007 Bible," all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pak. Visit John's popular Spreadsheet Page at www.j-walk.com/ss.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Descrizione libro John Wiley & Sons Inc, 2007. Paperback. Condizione libro: Brand New. paperback/cd-rom edition. 3384 pages. 9.50x7.50x7.00 inches. In Stock. Codice libro della libreria zk0470176547
Descrizione libro Wiley, 2007. Paperback. Condizione libro: New. book. Codice libro della libreria 0470176547
Descrizione libro Wiley, 2007. Paperback. Condizione libro: New. PAP/CDR. Codice libro della libreria DADAX0470176547