Mr. Spreadsheet's Excel 2007 Library by John Walkenbach
Look inside with Google Book Preview
Mr. Spreadsheet's Excel 2007 Library
By John Walkenbach

Mr. Spreadsheet's Excel 2007 Library

By (author) See other recent books by John Walkenbach
Format: Paperback

Checking availability...



Mr. Spreadsheet's Excel 2007 Library by John Walkenbach

Book Description

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!

Buy Mr. Spreadsheet's Excel 2007 Library book by John Walkenbach from Australia's Online Bookstore, Boomerang Books.


Book Details

ISBN: 9780470176542
ISBN-10: 0470176547
Format: Paperback
(250mm x 190mm x 190mm)
Pages: 3384
Imprint: John Wiley & Sons Ltd
Publisher: John Wiley and Sons Ltd
Publish Date: 28-Aug-2007
Country of Publication: United Kingdom

Books By Author John Walkenbach

Excel 2016 Power Programming with VBA by John Walkenbach Excel 2016 Power Programming with VBA, Paperback (March 2016)

Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016.

Excel 2016 Formulas by John Walkenbach Excel 2016 Formulas, Paperback (February 2016)

Leverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas.

Excel 2016 Bible by John Walkenbach Excel 2016 Bible, Paperback (November 2015)

The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs.

Excel VBA Programming For Dummies by John Walkenbach Excel VBA Programming For Dummies, Paperback (October 2015)

Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA).

» View all books by John Walkenbach

Reviews

» Have you read this book? We'd like to know what you think about it - write a review about Mr. Spreadsheet's Excel 2007 Library book by John Walkenbach and you'll earn 50c in Boomerang Bucks loyalty dollars (you must be a member - it's free to sign up!)

Write a book review


Boomerang Bucks close

For every $20 you spend on books, you will receive $1 in Boomerang Bucks loyalty dollars. You can use your Boomerang Bucks as a credit towards a future purchase from Boomerang Books. Note that you must be a Member (free to sign up) and that conditions do apply.

Recent books by John Walkenbach close
Excel 2016 Power Programming with VBA by John Walkenbach
Excel 2016 Formulas by John Walkenbach
Excel 2016 Bible by John Walkenbach
Excel VBA Programming For Dummies by John Walkenbach
101 Excel 2013 Tips, Tricks and Timesavers by John Walkenbach
Excel Dashboards & Reports by John Walkenbach
Excel 2013 Formulas by John Walkenbach
Excel 2013 Power Programming with VBA by John Walkenbach
Excel 2013 by John Walkenbach
Excel VBA Programming For Dummies by John Walkenbach
101 Ready-to-use Excel Macros by John Walkenbach
Office 2010 Library by John Walkenbach
Excel Dashboards and Reports by John Walkenbach
Office 2010 Bible by John Walkenbach
John Walkenbach's Favorite Excel 2010 Tips and Tricks by John Walkenbach
Excel 2010 For Dummies Quick Reference by John Walkenbach
Excel 2010 Formulas by John Walkenbach
Excel 2010 Power Programming with VBA by John Walkenbach
Excel 2010 Bible by John Walkenbach
Excel 2007 Charts by John Walkenbach
»
BoomerangBooks.com.au close