AnyBook4Less.com | Order from a Major Online Bookstore |
![]() |
Home |  Store List |  FAQ |  Contact Us |   | ||
Ultimate Book Price Comparison Engine Save Your Time And Money |
![]() |
Title: Excel 2000 Formulas by John Walkenbach ISBN: 0-7645-4609-0 Publisher: John Wiley & Sons Pub. Date: January, 2000 Format: Paperback Volumes: 1 List Price(USD): $44.99 |
Average Customer Rating: 4.66 (38 reviews)
Rating: 5
Summary: You Must Have This Book.
Comment: If you only buy one book on Excel, this should be the one. If you are a low intermediate user (i.e. not brand new to it, but with a passing familiarity) up through seasoned Excel veteran, this book is a help. There are many hidden secrets in Excel. Do you know how to use Array formulas? Create Custom conditional formatting? Save time with Auto-functions? That Circular References can be a good thing? How to give cells names, then use names instead of cell references in your equations so they are easier to edit / understand (I.E. =(Cost of Goods Sold / Sales) vs. =(A1/C3)? How to use VBA to create the exact function you need? This book has it all, plus all the basics and hidden shortcuts (some not even published) I.E. Using CTRL+Shift+F9 to force recalculation.
This book is extremely lucid and easy to understand. Every piece of information is supported by examples. I am a financial analyst and extremely experienced with Excel, yet this book is still helpful. It is almost a one-stop shop, seemingly lacking little. I also have an MBA. MBA's, buy this book BEFORE you by the MBA's Guide to Excel. I did it the other way around, and knowing what I know now, would not have purchased the Guide. In my opinion, anyone considering an Excel guide purchase, should purchase Excel 2000 Formulas first. It is much more than just a list of formulas. It is truly an excellent book, will save you time, effort, and frustration, and is an excellent value even at twice the price.
Rating: 4
Summary: Great resource for Excel Formulas
Comment: As a mid-high experienced Excel user, I found this book to be a useful resource to round out my Excel knowledge with coherent and concise explanations of Excel formulas and useful examples. While I don't think this book is a great resource for the beginner, I think it is useful for anyone who's job requires them to use Excel anyhwere from 10 hours a week or more OR for experienced Excel users who want to round out their overall Excel knowledge.
I particularly liked the author's ability to solve commonplace Excel logic problems with formula examples (i.e. finding the the number of unique experiences in a data set with a combination of clever formulas put together). His solutions and examples are clearly written and explained, particularly sections on dates and text manipulatios).
Where I think the book has shortcomings is in its struggle to pull these great solutions out from the more basic instructional writings. I have, however, heard many great things about this author and look forward to reading other works by him.
Rating: 5
Summary: =¿An excellent resource guide¿
Comment: As an intermediate user of Microsoft Excel, and new to the 2000 environment, I was fortunate enough to stumble upon John Walkenbach's Excel 2000 Formulas. Unlike many other books on the market filled with minutia , Excel 2000 Formulas is a straightforward no nonsense reference guide. The examples in the book are simple to follow as well as duplicate on your own without having to spend countless hours recreating sample spreadsheets. I am in a financial oriented work environment and have found numerous examples applicable to my everyday tasks that I was unaware of prior to my purchase. Bottom line....... a must have on any Excel 2000 user's desk.
![]() |
Title: Microsoft® Excel 2000 Power Programming with VBA by John Walkenbach ISBN: 0764532634 Publisher: John Wiley & Sons Pub. Date: May, 1999 List Price(USD): $49.99 |
![]() |
Title: Microsoft® Excel 2000 Bible by John Walkenbach ISBN: 0764532596 Publisher: John Wiley & Sons Pub. Date: June, 1999 List Price(USD): $39.99 |
![]() |
Title: Microsoft Excel 2000 Step by Step by Inc. Catapult ISBN: 1572319747 Publisher: Microsoft Press Pub. Date: May, 1999 List Price(USD): $34.99 |
![]() |
Title: Microsoft Excel 2000 Functions in Practice by Patrick Blattner, Laura Stewart ISBN: 0789720450 Publisher: Que Pub. Date: 12 October, 1999 List Price(USD): $29.99 |
![]() |
Title: Excel Charts by John Walkenbach ISBN: 0764517643 Publisher: John Wiley & Sons Pub. Date: 05 November, 2002 List Price(USD): $44.99 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments