Excel 2007 Bible | 
enlarge | Author: John Walkenbach Publisher: Wiley Category: Book
List Price: $39.99 Buy New: $21.92 You Save: $18.07 (45%)
New (36) Used (13) from $21.46
Avg. Customer Rating: 9 reviews Sales Rank: 1084
Media: Paperback Edition: Pap/Cdr Number Of Items: 1 Pages: 912 Shipping Weight (lbs): 2.9 Dimensions (in): 8.1 x 6.4 x 1.8
ISBN: 0470044039 Dewey Decimal Number: 005.54 EAN: 9780470044032 ASIN: 0470044039
Publication Date: January 3, 2007 Availability: Usually ships in 1-2 business days Condition: All orders ship same business day via standard shipping (USPS Media Mail) if received by 1 PM CST.
|
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
- 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 liworld’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
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
|
| Customer Reviews: Read 4 more reviews...
Not enough VBA April 8, 2008 1 out of 3 found this review helpful
The VBA examples and explanations were not as in depth as I would have liked.
Excel Book December 30, 2007 2 out of 2 found this review helpful
This is a good intermediate level book for those that use Excel on a regular basis.
Excel 2007 bible December 26, 2007 17 out of 17 found this review helpful
I recently acquired this book for purposes of review and recommendation for Office 2007 literature at work.
John Walkenbach has written many books on the subject of Excel. As such, this book is comprised of summaries of several of his other, more specific publications.
Part 1 of the book goes over spreadsheet basics. This includes working with tables, which is a new Excel feature in 2007. You'll find most information pertinent to basic Excel usage in this section, and will be well on your way.
Part 2 is a summary of J.Walk's Excel 2007 formulas book. It includes the same basic chapters - Text, Date/Time, Count/Sum, Lookup, Financial, and two chapters on Array Formulas. If you already have the formulas book, this is completely useless; if you do not, this is a good overview without the extra details.
Part 3 is a short summary of the Excel 2003 charts and graphs, updated for Excel 2007. It also includes a section on working with graphics and the new conditional formatting features of Excel 2007. The information here is not terribly deep, but gives the basics of working with charts and provides some tips for advanced manipulation that is possible. The chapter on conditional is quite short, considering the number of improvements to this feature that has come about with Excel 2007.
Part 4 is a "miscellaneous" section, encompassing various features such as custom number formats, sharing Excel data, and a number of tips/tricks. Again, many of the features described are given an overview rather than an in-depth treatment, but I found that the essential features are all present and accounted for. There is also some information for working in a networked environment and with the Internet.
Part V deals with data analysis, for operations contained on the Data tab of the Excel 2007 ribbon. Most notably, there is a chapter on using MS Query, and two chapters about pivot tables. Part V also covers Goal Seek and Solver, and provides an overview of the tools included with the Analysis ToolPak. This exposes the reader to the features, but does not provide a whole lot of examples, although J.Walk's examples do tend to showcase just how far you can take some of the Excel features.
Finally, Part VI is a (very brief) summary of Excel 2007 Power Programming. It covers custom user-defined worksheet functions, user forms, and workbook events. There is also a number of examples of code that's readily useable in your own projects and Excel-based solutions. This section is enough to get you started, particularly if you have some programming experience, but if you want to get serious with VBA, this will only get your foot in the door.
Overall, this book is perfect for beginners and intermediate users who do not have a lifetime to devote to Excel. Granted, this book is pretty long, but as I mentioned throughout, it's to the point and not excessively verbose. I think of it as an extended tutorial walkthrough of the different Excel functionality. It does not include case studies or exhaustive spreadsheet solution examples. For advanced users, a vast majority of chapters will be unnecessary.
Grow Into a Power User w.Excel 2007 Bible! November 7, 2007 15 out of 16 found this review helpful
This is one of THE BEST books on Excel 2007! I've compared this book to the following: Excel 2007 the Missing Manual & Excel 2007 Beyond the Manual. I found that the Bible version to be not only a good overview of the changes in Excel 2007, but also a guide that explores the many uses and possibilities of using the program.
It is well organized, detailed and serves as a good resource for new & intermediate. It is not, however for those who are advanced users who are looking for something on advancing their skills in Pivot Tables, VBA or advanced formulas. If you are looking for a book on intricate formulas or a cookbook, then I recommend Formulas and Functions with Microsoft Office Excel 2007 by Paul McFedries. There are also other books out there geared specifically towards VBA and Pivot Tables.
So, to sum it up, it's an outstanding overview and delve into Excel 2007 that will benefit beginners and intermediate users the most and can help this group grow into power users! It also makes a pretty good refresher for advanced users. Either way, you can't go wrong!
Very Informational October 31, 2007 4 out of 5 found this review helpful
Switching over to Excel 2007 has been a wonderful and fun experience, but it has been made so easy with help from John Walkenbauch's Excel 2007 Bible. If you want to take advantage of all the new and wonderful uses that Excel 2007 has to offer, then I recommend using this as a guide. I continue to refer to it on a regular basis to make sure that I am always getting the most out of Excel 2007. Love this Book!!
|
|
|