Mr. Spreadsheet's Excel 2007 Library [Paperback]

John Walkenbach (Author)

Book Description

ISBN-10: 0470176547 | ISBN-13: 978-0470176542 | Publication Date: July 30, 2007

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!

Editorial Reviews

From the Back Cover

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!

Product Details

• Paperback: 3384 pages
• Publisher: Wiley (July 30, 2007)
• Language: English
• ISBN-10: 0470176547
• ISBN-13: 978-0470176542
• Product Dimensions: 9.6 x 7.6 x 7.2 inches
• Shipping Weight: 10.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #1,008,981 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

13 of 16 people found the following review helpful:

5.0 out of 5 stars Mr. Spreadsheet's Excel 2007 Library, March 26, 2008

By 

WMG (Chicago, IL) - See all my reviews

Amazon Verified Purchase

This review is from: Mr. Spreadsheet's Excel 2007 Library (Paperback)

I've used Mr Walkenbach's books for the last 6 years and have never been disappointed.

This set covers most anything you want to know or do in Excel 2007.

I also recommend buying his PUP program with source code, if learning how to create VBA code is your objective. It's a great add-in and a great learning tool.

4.0 out of 5 stars It takes time but is helpful, April 14, 2011

By 

CEE 101 - See all my reviews

Amazon Verified Purchase

This review is from: Mr. Spreadsheet's Excel 2007 Library (Paperback)

It gives some helpful tips and examples which seem to focus more on accounting. It not self-explaining for making selective searches and calculations.