Sunday, March 21, 2010

Excel 2007 Formulae and Classic Menu for Office 2007

Posted by Software4Tricks at 12:48 AM


* This book is a single reference that?s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere.



* Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won?t find anywhere else.

* John Walkenbach, aka "Mr. Spreadsheet," is one of the world?s leading authorities on Excel.

* Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features.

* Includes a valuable CD-ROM with templates and worksheets from the book.


Create killer formulas---Mr. Spreadsheet shows you how

Excel master John Walkenbach has shared his expertise in two previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007. If you already know your way around the newest Excel and want to concentrate on using formulas to extend its capabilities even further, you've come to the right place.

It's estimated that only about ten percent of Excel users really understand how to get the most out of worksheet formulas. If you're ready to join that elite group, here's your membership kit.


CD-ROM INCLUDES:

Sample files for tutorials

See the CD appendix for details and complete system requirements.


Mr. Spreadsheet's Success Techniques

Technique # 1 Master operators, error values, and absolute vs. relative references

Technique # 2 Find errors and debug formulas

Technique # 3 Use pivot tables to eliminate formulas

Technique # 4 Create single- and multi-cell array formulas

Technique # 5 Build custom functions with VBA


About the Author

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 40-plus books include Excel 2003 Power Programming with VBA, Excel Charts, and John Walkenbach's Favorite Excel Tips & Tricks, all published by Wiley.



If you enjoyed this post and wish to be informed whenever a new post is published, then make sure you subscribe to my regular Email Updates. Subscribe Now!


Kindly Bookmark and Share it:

YOUR ADSENSE CODE GOES HERE

Blog Archive

Related Posts Plugin for WordPress, Blogger...
 

Subscribe Now

Followers

© 2012. All Rights Reserved | Free Software and Every thing 100% Softwaretricks | Template by Blogger Widgets

Home | About | Top