Scroll below to find my favorite Excel book for various user levels. I have cut through the hundreds of books out there to bring you quality books that you will really get some use out of. Rest assured that I have held each of these books in my hand and tried to see how I could use the book to solve real problems.
In association with Amazon.com, you can buy these books directly over the Internet. By clicking on a link below and buying the book from Amazon.com, MrExcel receives a generous referral fee. Those fees help offset the cost of this site. Consider buying through the links on this page to help keep the message board free.
VBA and Macros for Microsoft Excel by Tracy Syrstad and Bill Jelen. This book is designed to get 400 million Excellers up the VBA learning curve to enable them to save hundreds of hours per year. Have you ever tried to record a macro, only to find it does not work the next day? The authors show you WHY the Macro Recorder doesn't work with real-life data. They will teach you how to look at and really understand the bizarre syntax of VBA. Then, in Chapter after Chapter, you will learn how to use VBA to automate all of Excel's power features. Includes contributions by many of the MrExcel MVP's.
Excel 2003 Power Programming with VBA
- John Walkenbach trained a generation of Excel programmers. This book is the standard. After you get up to speed with the above book, you should have this book on your shelf.
Excel 2002 VBA Programmers Reference - by Ron Bovey, Stephen Bullen, John Green, Robert Rosenberg. These guys are royalty in the Excel MVP program, and any book by this cast has got to be great. Once you have read all of Walkenbach and think you know everything there is to know about VBA, get this book. The is the third book that is a must for serious VBA coder. $27.99 from Amazon.com.
My 2nd favorite non-VBA book for power users - Excel Annoyances - is out of print, See Below for information.
Excel Hacks - 100 Industrial Strength Tips - by Dave & Raina Hawley. A follow-up to the wildly successful Google Hacks book, this book by MrExcel MVP Dave Hawley is sure to be a great book.
Excel 2003 Bible - John Walkenback is the man when it comes to Microsoft Excel. This HUGE book (897 pages) is a comprehensive guide for every Excel user. Not to be read cover-to-cover, but a great book to open up if you are having a problem. It has hundreds of solutions to real life problems on basic through advanced Excel topics. Some sections on VBA, but not designed to be a comprehensive VBA reference.
Excel 2003 Simplified - This is a very visual introduction to Micosoft Excel. If you have never used a spreadsheet before and want to crawl before you can run, this is the book to get started with. Also available:
Excel 2003 for Windows for Dummies - You can curl up with this book and read it cover to cover. Greg Harvey uses a light, humourous style to teach many topics about spreadsheets. Beginning users will learn how to build and format worksheets quickly. Experienced or self-taught users will find many useful tips. Also available:
Excel 2002 Formulas - One of my clients gave me this book and I love it. It includes a great section on array (CSE) formulas. This is another book where you can turn to any of the 760 pages and learn something new. Also available:
Excel Charts - 552 pages of everything you ever wanted to know about Charts and Graphs in Excel. From John Walkenbach.
Running Microsoft Excel 2000 - This book covers all of the features of Excel 2000 in detail. The chapter on VB applications is a great tutorial for someone who wants to get started with VBA. From Microsoft Press. Weighing in at 994 pages, this book covers features that other books don't, such as Scenario Manager.
Excel 97 Annoyances - Whether you are using Excel 2000 or Excel 97, you need this book to achieve full guruhood. It is not a rehash of the users manual. It is not an overall introduction. It is for experienced Excel users. To quote from the authors; "For the group of Excel users who have been working with Excel long enough to be steamed at the software for its stupidity and inadequacy. Those users who grit their teeth at the problems and convoluted features and grind their way through, knowing their must be a better way but not having the time or the patience to ferrit it out." This book will have you taking charge of Microsoft Excel in no time. You can still buy the companion book Office 97 Annoyances
Excel is a registered trademark
of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
All contents Copyright 1998-2008 by MrExcel Consulting.