Recommended books about excel

• Revised and updated to cover changes to all of Office's applications and productivity tools
• Offers beyond-the-basics coverage of Office word processing, spreadsheets, presentations, e-mail, databases, and desktop publishing
• Covers Word, Excel, Access, PowerPoint, Outlook, Publisher, productivity tools such as Microsoft OneNote, and SharePoint
• Thoroughly updated to cover the new Office interface as well as new features in each application

The product has very basic information. I purchased the book to find out how to do many things within Office Outlook and the information was simply not there. I was looking to learn how to manage and update my "Archive Folder" it didn't have the information available. Disappointing based upon the cost.

AWESOME BOOK I couldn't have found a better one. Easy to read and great instructions.
Dennis aka drdenny

Readable, useful, humorous. I knew Word and Excel 2003 and needed to upgrade those to 2007 and learn Access and Outlook from start. This book would get you from no knowledge to being able to use the four programs I read about. It doesn't cover advanced topics - how to duplicate Access entries and make changes in the duplicate, for example - but you'll be ready to understand a more advanced guide.

I have found it to be helpful. I do feel that specific topics are sometimes more difficult to locate than I'd like. But overall, it has proven a good choice.

If you have Office 2007, this book is a MUST for you. Very easy to read and understand. This book will teach you things about Office 2007 you did not know.

One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you�fre not in Kansas anymore. Well, have no fear�| Excel 2007 for Dummies is here!

If you�fve never worked with a computer spreadsheet, or if you�fve had some experience with earlier versions of Excel but need help transitioning, here you�fll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

You�fll discover how to:

• Rearrange, delete and insert new information
• Keep track of and organize data in a single worksheet
• Transfer data between the sheets of different workbooks
• Create a chart using the data in a worksheet
• Add hyperlinks and graphics to worksheets
• And more!

Plus, in keeping with Excel 2007�fs more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you�fll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.

the 2007 programs create major problems in business organizations that have massive files in the 2003 version. the cost to convert is astronomical in comparison with the minor cost of the microsoft product.

I have several of these books on different subjects and although it is a good training or reference book, I would have preferred VISUALS as they are much easier for me to follow. What I like about the DUMMY line, is the reading material is in simple terms and not that WAY OUT THERE technical terms that I doubt the real computer geeks even understand.

The section on financial formulas contains some horribly incorrect information (totally wrong on NPV interpretation) and for some reason skips a description of IRR - one of the most used financial functions. Otherwise a good introduction to Excel 2007.

The Excel 2007 for Dummies was just what I was looking for. It contained everything, plus some, that I needed to work with this version of Excel.

Started a new job and was not used to using the 2007 version of Excel. The book is very informative and helped me greatly. Would recommend this book to anyone needing help with Excel 2007

• This book is a single reference that�fs 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�ft find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld�fs 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.

This book is for Excel 2007 not the earlier versions. I found this book to have clear and complete coverage of Excel 2007. Very easy to follow information and very complete. Written for beginners to advanced users. AS noted by other reviewers though the print quality is somewhat faded but still very readable. Glad I bought this book.

The disc in the back of the book was sliced off (I guess by the printer.)

I need the disc replaced.

thank you.

Carole Bruno

this is not good book. too much literal explanation, and the most importnat is there has no any screen with highlighted instruction , so user can quick understand where and how to do it. With too many small words to explain the operation, it's hard for user to understand and it takes user too much time to search around the location of what the author trying to point out from the screen.
I was trying to learn more skills of Excel, but after reading couple of chapters from this book, now my enthusiasm is gone!

The content might be spot on, but it's hard to tell because the book is printed on low grade, grey-colored paper, using grey print, resulting in low contrast. Maybe its recycled paper? Maybe the printing press ran out of ink? Dear Publisher: Hello!! We readers need white paper with black print!! Please send this book back to the Printer and have them try again!

As with all these "bible" software books. They are really a handy reference. Particularly for the moderate excel user.

More seasoned users could do just as well with the hundreds of online help areas centered around excel. I picked up this book to help me get over the "ribbon" hurdle with excel; but find I simply use online help rather than cracking open this book.

I give it 3 stars b.c it does what it professes to do.

* The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features
* Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss
* The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more
* Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information
* Explores Excel programming for those who want advanced information
* CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak

I am in the middle of getting an MBA, and I have a six month internship at one of the top 3 consulting firms in the world. I used to be a chef, so my excel knowledge stopped at simple formulas. I brought the CD-ROM with me to work, and taught myself pivot tables in about 10 minutes with this book. I was amazed at how simple this book made the process. I recommend this to anyone who doesn't just want to be told how to do something, but needs to refernce and practice a skill to truly master it. This truly is a bible for excel use. halleluiah!!

Highly Recommended for those who desire to develop advanced EXCEL skills. I've essentially taught myself using the "Bible" Series.

This book has been a great resource for me over the past few months. In fact my entire team at work now uses this on a daily basis.

I bought this as a reference book for the office after taking an advanced Excel class. Everyone in my office uses it and the power pack that comes on the CD included with the book adds awesome tools and macros to the program. The only drawback is that most of the add-in programs on the CD are only 30-day trials, so you have to pay for them after a month.

I am an Excel novice, and the "Excel Bible - 2003" was a fantastic ready reference book for me. If you plan on doing ANY sort of analytical work on your PC, I highly reccomend using Microsoft Excel. As such, this book will help you successfully navigate through your first few days, weeks, and years of Excel.

Also, Mr. Walkenbach (the author) is very accessable. I had a few basic questions for him regarding Excel formulas, sent him an e-mail and had a response within 48 hours. Pretty remarkable, in my opinion.

Every time you turn around, you run into Excel. It�fs on your PC at work. It�fs on your PC at home. You get Excel files from your boss. Wouldn�ft you like to understand this powerful Microsoft Office spreadsheet program, once and for all? Now, you can crunch financial data, add sparkle to presentations, convert static lists of numbers into impressive charts, and discover what all the shouting�fs about regarding databases, formulas, and cells. You may even decide that getting organized with a good spreadsheet is downright useful and fun!

Flip open Excel 2003 For Dummies, and you�fll quickly start getting the basics of Excel in plain English. Written for the rest of us, this down-to-earth book gently shows you how to:

• Create a spreadsheet from scratch
• Apply the basics of formatting cells
• Take on database forms�|even add records�|and prevail
• Get organized and stay that way
• Save worksheets as Web pages for your company intranet

In a clear and easy-to-understand style, veteran software trainer and technology writer Greg Harvey explains the basics of worksheets and workbooks, how to enter data and work with formulas, and how to print your masterpieces. When you�fre feeling very bold, he�fll have you adding comments and pictures, saving files with security protection, and learning to zip between multiple worksheets in a workbook with ease. And there�fs much more:

• Clip and save the Top Ten Beginner Basics of Excel 2003
• Pay heed to the Top Ten Commandments of Excel 2003
• Impress your colleagues by creating a company org chart
• Re-open those documents and add or edit new data with aplomb
• Move between these sheets without trouble
• Decipher and take charge of helpful tools and commands such as Sort, Filter, Format Cells, and PivotTable

You�fll finally be able to stop pestering the Excel experts in your office. Become your own expert with the friendly and down-to-earth practical instruction you�fll find in Excel 2003 For Dummies.

It was just what I was looking for, and just as I expected. He assumes you know NOTHING and goes from there. Another good book in the Dummies series.

I have found this book to be very helpful, with easy to find answers to my questions.

I am an accountant. I was extremely disappointed in this book. Not well structured at all. It doesnt seem to know if it wants to be a reference book, a book for beginners or a book for those that have Excel knowledge and want to figure out the different features.
In the end the book is a help to no one.

I was disappointed. Although it is good for very basic beginners, I was hoping it would help with functions that are more difficult. The Dummies Books are so good at explaining things in friendly terms. I was looking for the friendly terms to help me understand complicated functions. I was out of luck. I would only recomment this product for the very basic beginner.

I was very happy with my purchase. It was very easy to order. The item arrived on time and it was in exactly the condition as stated. I would purchase from this buyer again.

Experience learning made easy and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace building and practicing the skills you need, just when you need them! Create formulas, calculate values, and analyze data Present information visually with graphics, charts, and diagrams Build PivotTable dynamic views even easier with new data tables Reuse information from databases and other documents Share spreadsheets for review and manage changes Create macros to automate repetitive tasks and simplify your work Your all-in-one learning experience includes: Files for building skills and practicing the book s lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista Product Guide eReference plus other resources on CD

I would need this book often for all the changes to Excel 2007. The CD was very valuable and am glad it is included. Would like a better process to remove the CD packet from the book so I don't damage the spine. I have ordered all the other Office 2007 books and will use them often.

Microsoft Office Excel 2007 Step by Step (Step By Step (Microsoft))

I have to agree with another reviewer. This book is full of errors including example files that range from already completed or missing pieces. The book is hard to follow because some of the commands are not what is in the actual Excel product. The book lacks symbols or pointers for the keystroke instructions. The book has you making permanent changes and additions to Excel and not removing them. Need I go on.

Yes, I am learning some things the hard and slow way. Maybe this book was printed before the product was released but that is still no excuse for the lack of review before it was printed.

I had purchased the Step-by-Step Powerpoint 2007 book and it was excellent -- great directions, in the left margins small icons for the keys to press, and every example on the CD was correct. And believe it or not the instructions matched the Microsoft product.

I should have read the reviews before I purchased this book. This is my opinion.

Great product for the beginner as well as intermediate. A truly great learning tool

This book looks good on the surface; However, The descriptions do not match the screens that I have on my version of Excel 2007. It is very difficult to follow and I would not recommend it to anyone new to this software.

Being new to Excel 2007, I figured this book would be the best place to start, given that it's published by Microsoft Press.

I'm about halfway through, and though I have garnered some useful information, I found the book to be so full of errors(and bonehead moments) that it has become a form of entertainment just anticipating the next one.

The first little omen was on page xxiv, where under the Creating and Managing Presentations header, the bullet item "Creating Effective Presentations" appears twice. OK, nobody is perfect.

The very first exercise instructs you to open an existing workbook file, "Exception Summary". The very next instruction is to close the file. This wasn't an error, but it was pretty funny.

There are files and folders missing from the companion CD, missing instructions, instructions that lead you down rabbit holes...

To their credit, Microsoft does maintain an error log on their website, but at least one of the listed "fixes" is still wrong, as far as I can tell.

I wonder if Microsoft Press is hiring proofers...

• This book is a single reference that�fs 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�ft find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the world�fs 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.

Walkenbach hasn't lost his touch. Belongs on the desk of anyone using VBA with Excel 2007 .

I was happy to find a product that was exactly what I needed. It shipped quickly and is in excellent condition.

Excellent reference for VBA in an Excel setting. Expect to get many years service from this book.

I am a novice to VBA and this is the first book I have purchased on the subject. It has alot of useful information. However, it skims so briefly over many topics. If you have a good grasp of VBA and what it can do, I think this is a nice reference. For someone like me, who is just starting, there is probably something better out there.

Got the book a couple of weeks ago and am about 350 pages into it. Although I have only scratched the surface, I've been able to put together a couple of macros that did exactly what I was asked to accomplish. Great Book.

Still the top-selling software suite for Mac users, Microsoft Office has been improved and enhanced to take advantage of the latest Mac OS X features. You'll find lots of new features in Office 2008 for Word, Excel, PowerPoint and Entourage, but not a page of printed instructions to guide you through the changes. Office 2008 for Macintosh: The Missing Manual gives you the friendly, thorough introduction you need, whether you're a beginner who can't do more than point and click, or a power user who's ready to tackle a few advanced techniques.

To cover Word, Excel, PowerPoint and Entourage, this guide gives you four superb books in one -- a separate section each for program! You can manage your day and create professional-looking documents, spreadsheets, and presentations in no time. Office 2008 has been redesigned so that the windows, toolbars, and icons blend in better with your other Mac applications. But there are still plenty of oddities. That's why this Missing Manual isn't shy about pointing out which features are gems in the rough -- and which are duds. With it, you'll learn how to:

• Navigate the new user interface with its bigger and more graphic toolbars
• Use Word, Excel, PowerPoint, and Entourage separately or together
• Keep track of appointments and manage daily priorities with the My Day feature
• Create newsletters, flyers, brochures, and more with Word's Publishing Layout View
• Build financial documents like budgets and invoices with Excel's Ledger Sheets
• Get quick access to all document templates and graphics with the Elements Gallery
• Organize all of your Office projects using Entourage's Project Center
• Scan or import digital camera images directly into any of the programs
• Customize each program with power-user techniques

With Office 2008 for Macintosh: The Missing Manual, you get objective and entertaining instruction to help you tap into all of the features of this powerful suite, so you can get more done in less time.

Why Should I Upgrade to Office 2008 for Macintosh?

Author Jim Elferdink talks about what�fs new in Office 2008 for Macintosh. If you�fre still using Office 2004, you�fll find some great reasons to upgrade. Jim also fills you in on some cool features that Office for Windows can�ft match, and why you may not need to invest in iWork!

What are the best new features that will make folks want to upgrade to Office 2008?
Publishing Layout view. If you use Word to create formatted documents like letters and brochures, you�fll find it so much easier to do now in the new Publishing Layout view than in the old Page Layout view. Publishing Layout view is actually quite similar to Pages; both are very usable. It�fs a huge boon for Word people�|if you haven�ft bought Pages, now you won�ft have to!
MyDay. I really enjoy Entourage�fs MyDay feature. Assuming you�fre not working on a laptop that doesn�ft have screen space to spare, I recommend keeping MyDay open in the corner of your screen. That�fs what I do! It helps me keep track of my appointments and schedule. If you�fve got appointments every 20 minutes or just a lot going on in your day, it�fs great to have it all at a glance. It also helps you remember to go pick up the kids. (And you can feel superior to your Windows friends. There�fs nothing resembling MyDay in Office for Windows.) Project Center. Entourage�fs Project Center has been streamlined and beautified for 2008, but it�fs still very underutilized. It takes a little extra effort to learn, but once you�fve got it up and running, if you�fre doing any kind of a project that involves Office documents or even files from other programs, it�fs a great timesaver. It lets you keep shortcuts to all these documents, plus email related to the project, in one window. The Project Center makes it easy to categorize email, contacts, notes, and documents. Things don�ft get lost, and you don�ft have to worry about Mac OS X labels and other ways to categorize things. (Office for Windows also has nothing like the Project Center.)
Formula Builder. In Excel, one of the greatest new features is the formula builder. If you use Excel much for formulas at all, especially more complicated ones, it�fs really a timesaver. It helps you get those things created and working much faster than you could do before.
Elements Gallery. The Elements Gallery concept is really great because it carries over from one program to the other, gives the programs a consistent feel. If you�fre using a lot of templates or AutoShapes, you�fll find it a quick way to get at all that stuff. You could do all these things before, but it was a lot harder to find what you were looking for.

So, are there any disadvantages to upgrading to Office 2008?
Publishing Layout view can be frustratingly slow on G4 Macs, especially when you�fre trying to move layout elements around onscreen. I would only use it on an Intel Mac. The same caveat holds true for PowerPoint; it�fs hard to move things around. But the rest of the suite works great on faster G4 machines.
Office 2008 uses the same new, XML-based file format as Office 2007 for Windows. It�fs great not to have to worry when someone with Office 2007 on a PC sends you something. Office 2008 can open those documents right up. But now when you send documents to Mac folks who haven�ft upgraded, they won�ft be able to open them! Once you upgrade to Office 2008, you�fve got to be aware that not everyone else has, and (unless you have a real need to use the XML format) set your Save options (in Preferences) to the older format so there won�ft be problems with your attachments.
Then there�fs the macro problem. Any macros you wrote in earlier versions of Office use the Visual Basic programming language (VBA), and they won�ft work in Office 2008! If you�fve written a lot of macros for yourself, you�fll have to stick with Office 2004 until you have time to rewrite them in AppleScript.

What do you like best about "Office 2008 for Macintosh: The Missing Manual?"
I�fm happy with the way this book turned out. I think it covers everything you need to use this really powerful suite of programs for all your work. One chapter I�fm particularly fond of, and which I think is missing from every other PowerPoint book I�fve looked at, is Chapter 15�|Planning Great Presentations. It helps you prepare for your presentation and shows you how to use PowerPoint for its true purpose. PowerPoint isn�ft doing the presentation�|you are. You�fre the star of the show! Unfortunately, too many people think it�fs the other way around.

Now open on my desk. Needed the information as I opened the package.
B. J. Comngore, Seguin, Texas

Love the manual. Have used Excel and Word from the beginning, but upgraded to Office 2008 and ordered the manual at the same time. My old manual are dog eared and well used and this one is starting out the same way. Very useful. Would not hesitate to buy again.

A tip: don't buy manuals for your new software until you have used it for a while. Use 'help' functions built in your software as much as possible. Document your big questions in a list and when you've got maybe 4-5 questions, that's the time to check out the manuals.

When shopping, I pull out every manual I can find for the software and sit down and read. The key aspects of a good technical manual are organization and ease of reading.

Ultimately, I buy the book that answers all or most of the questions I still have after working with the software for a while.

This is a good manual. It's got both a book and an online form. Note the online form is available for free for a limited time, then you will need to pay a subscription fee.

It's not a bad idea at all to have an online version as well as the book:

Online is available if you're traveling and don't have the book in hand.
Online searches can be quicker than the book.
An online version will be updated when new versions of the software come out and/or new issues about the software arise.

The downside of this manual--it's got a lot more information than I currently need. It didn't answer the one pressing issue I had about resuming a document at the last edit and both my husband and I searched for that one question.

Still, my very technical husband and I both like the O'Reilly line of software manuals because they tend to be some of the most complete out there. Add in the online versions and you have a book that should last beyond the first blush of software use.

Rebecca Kyle, August 2008

I have been greatly impressed by the writing and knowledge of this author. He is thorough in his descriptions and can lead even the most novice or computer illiterates find their way through the book and get some things done on their computer! This is a MUST have book as a resource and useful "buddy" to help walk you though this software. It is even entertaining and can get you to smile!
Highly recommended!

No doubt at all it should have been in the box!

Covers everything from installation, standard and options, user guide through to trouble shooting. First class manual at a first class price!

Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50�h flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more.

This guide is not for rank Excel amateurs. It�fs for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you�fre an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes:

• An introduction to the VBA language
• A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it
• The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder
• The essential VBA language elements, including comments, variables and constants, and labels
• Working with Range objects and discovering useful Range objective properties and methods
• Using VBA and worksheet functions, including a list and examples
• Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop
• Automatic procedures and Workbook events, including a table and event-handler procedures
• Error-handling and bug extermination techniques, and using the Excel debugging tools
• Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks
• Customizing the Excel toolbars
• Using VBA code to modify the Excel menu system
• Creating worksheet functions and working with various types of arguments
• Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities

Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there�fs no substitute for hands-on learning. The book is complete with:

• A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes
• Information to help you make the most of Excel�fs built-in Help system so you can find out other stuff you may need to know

What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it�fs a Very Big Accomplishment.

I purchased this book as an assist to me - to build upon the knowledge that I have already, regarding Macros and VBA. I know some VB6, and am translating that knowledge through this book. I don't think that I am alone in asserting that any type of "Dummies" book provides good insight/information to those who may even have some existing knowledge of the topic. I will probably purchase another more intermediate book for VBA programming, to extend the experience. The purchase came very quickly as Amazon always does !

The book is poorly written and poorly organized. The book covers very similar types of processes using different syntax without explaining why it used different VB code, so one wonders what why it uses one type of code here and another type of code there. Literally, the book has codes which, when I type verbatim, generates errors. Thoroughly frustrating book. Breezing and useless.

This book is exactly what I needed. I know several program languages so I just needed a good introduction to syntax and the basic functions. This was what I needed. Thanks.

I've purchased other JWalk products in the past and this is another in a line of great JWalk Excel,Access, VBA offerings. This is a very good addition for the user who is not comfy with VBA for Excel. Get this if your delving into Excel VBA for the first time.

I have tried to pick up VBA for Excel a few times, but the pieces just didn't seem to fall together for me. I am in IT, but I don't have a development background. I have solid Excel skills, but still got frustrated with VBA and would put it down. Recently, I had a very specific problem to solve for work and thought I would give it another try.

I decided to get a book with the basics and read it completely first, then try to start coding my project. I was in a hurry so I also got the online upgrade to start reading even before my book got here. I found the book an easy read and occasionally tried a few of the examples as I went along. I got through the book easily in a few days and feel as if I had a good knowledge base to begin.

I am happy to say within 2 weeks, I have completed the project I had first planned and then an even more complex project. I have a third planned now. I used other Excel VBA resources along the way, but have to give credit to this book for getting me started and with the basics so I could even understand where to go next. I see the time and money I invested in this book coming back to me many times over due to the hours and hours of work the macros I have been able to write will save both myself and my team members.

I still have a lot to learn, but I am very satisified with this book. I picked this book because of the other good reviews it has on this Amazon site, so I hope you will find my review helpful to you!!

"Today, no accomplished Excel programmer can afford to be without John's book. The value of Excel 2003 Power Programming with VBA is double most other books-simultaneously the premier reference and best learning tool for Excel VBA."
--Loren Abdulezer, Author of Excel Best Practices for Business

Everything you need to know about:
* Creating stellar UserForms and custom dialog box alternatives
* Working with VBA subprocedures and function procedures
* Incorporating event-handling and interactions with other applications
* Building user-friendly toolbars, menus, and help systems
* Manipulating files and Visual Basic components
* Understanding class modules
* Managing compatibility issues


Feel the power of VBA and Excel

No one can uncover Excel's hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user's guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you're fairly new to Excel programming, here's the foundation you need. If you're already a VBA veteran, you can start mining a rich lode of programming ideas right away.

CD-ROM Includes
* Trial version of the author's award-winning Power Utility Pak
* Over one hundred example Excel workbooks from the book


System Requirements: PC running Windows 2000 SP3 or later, or Windows XP(TM) or later. Microsoft Excel 2003. See the "What's on the CD" Appendix for details and complete system requirements.

I used to write macros by cutting and pasting recorded macros. Many lines of cods made my macros unreadable to others. After using this book with its clear examples I understand what I did wrong in the past and how I can write efficient code in the future. This book is very usefull because of its structure, every chapter is a compleet book.

This book is...I can't find the words. It has helped me tremendously. I have gone further with Excel then I ever dreamed I could on my own. I recommend this book for anyone wanting to get more use out of their spreadsheets.

While I had used this for a course in VBA, and noted that it was an extremely concise text, I found it near useless when I was working on my assignments. This book had the information in it, but oftentimes, I simply could not find this information quickly (if at all), and instead Googled much of my information.

On a positive note, this is a well-written book (note: not well-indexed), and therefore useful if you're learning VBA and exploring each chapter one-at-a-time. If you're looking strictly for a reference book for VBA, however, I would strongly advise against getting this particular text.

Also, this text is not written for beginners (a point that the author makes clear), even though some of the material in this book could only be for beginners (for example, the introductory VBA material).

Excellent book for anyone looking to quickly get up and programming VBA in Excel. Don't have to be familiar specifically with Visual Basic but a reasonable knowledge of programming a help. Would have given it 5 stars if it had a thorough reference section on VBA.

Book was helpful in the setup of various 'maintenance' routines. It gave me a fresh look at the use of properties, allowing me to streamline the coding. Unfortunately, company directives have us converting the work to 'active server pages' with a SQL 2005 database server. Since the source data is Oracle, I have been working on DB to DB utilities.