Resources

Greg's Favorite Excel Websites

Here is a listing of the websites I find the most helpful when I have an Excel question that needs answering:

screenshot of MrExcel.com MrExcel.com is the best Excel forum I know.  A huge number of very talented Excel users are always there ready and willing to answer your questions - for free!

screenshot of Chip Pearson's site Chip Pearson is one of the most brilliant coders I have ever met and the library of web pages about VBA found on his site is very extensive.  It is a terrific resource for all aspects of VBA, but it's especially good for learning how to use WinAPI calls from Excel.

screenshot of Jon Peltier's website. Jon Peltier has forgotten more about charting in Excel than most of us will ever know.  His library of articles on charting in Excel is unequaled.

screenshot of Dick's blog Dick Kusleika's blog, Daily Dose of Excel, has a tremendous variety of great articles and frequently gets comments from some of the best Excel gurus around.

screenshot of Contextures.com Deb Dagleish's website, Contextures, has a good library of articles and is especially strong on pivot tables.

screenshot of Ron de Bruin's website Ron de Bruin is a Microsoft Excel MVP from Belgium.  His site contains a good number of excellent articles.  One of his best-known is on how to automate Outlook and send e-mails from within an Excel macro.

screenshot of Jan Karel's website Jan Karel Peterse is a Dutch Microsoft MVP in Excel.  In addition to a number of great articles, Jan Karel offers two very good Excel Add-Ins: Name Manger and RefTree Analyzer.

screenshot of Andy Pope's website Andy Pope's website has a lot of interesting and quirky Excel articles and tools.  And it has one amazing tool - Andy's RibbonX Visual Designer has saved me untold hours creating customized ribbons for Excel Add-Ins that I have designed for customers.

screenshot of Ken Puls' website Ken Puls has a great website with a lot of good articles.

screenshot of JWalk's website No listing of Excel websites would be complete without John Walkenbach's site.  If you have ever shopped for a book on Excel then you know that John was the premier author of Excel how-to books for many years and there are still a large number of great articles on his website.

screenshot of Domenic's website Domenic is a Microsoft Excel MVP and his website has good articles on both formulas and VBA.

screenshot of Tushar's website Tushar is a very good VBA developer.  While his site might be a little tougher to navigate than other, he does have several excellent tutorials.

screenshot of Ozgrid Likewise, any listing of leading Excel websites has to include Ozgrid.  The founder, Dave Hawley, passed away recently.  But he leaves the Excel community a tremendous resource in the form of the Ozgrid forums.

Greg's Bookshelf

photo of Greg in yellow shirt
As you can see, I've always had plenty of Excel (and Access) books on my bookshelf.

Here is a selection of Excel titles that are on my own bookshelf and that I would recommend to anyone looking to improve his or her Excel skill set.

don't fear the spreadsheet cover  This is a newer title from Bill Jelen (MrExcel) that is targeted for beginners. It does a nice job of covering the very basics of Excel and would be a good resource for someone that knows very little about Excel and needs to learn basic skills on formulas & formatting.

unlocking the secrets of excel  unlocking the secrets of excel 2  These are not books. They are software on CD ROM (it's also available on a flash drive) from Fred Pryor. As a learner I prefer books to software, so I do not own a lot of this kind of software. The software from FP is developed to work on computers with pretty ancient resolutions. But it does do a very nice job of walking someone through the basics of using Excel and covers a nice variety of basic topics. If you are looking for a resource for your business (it's kind of pricey for your personal library) I would recommend Pryor's Unlocking the Secrets of… software.

VBA step-by-step  If you are new to object oriented programming or to programming in VBA in Excel this is an excellent book for learning the ropes. I came to VBA & Excel from a more procedural programming background and was struggling to grasp some of the fundamental concepts of object oriented and event-driven programming and this book (albeit the Excel '97 version) was a huge help to me and made me comfortable writing macros.   However it does look like the paper version of this might be getting scarce.  You could end up having to buy a Kindle or Nook edition.

Learn Excel from Mr Excel A very nice compendium of all sorts of tips and trick for use in Excel. While it would help beginners somewhat it would be more useful in the hands of an intermediate to advanced user. While an advanced user might know a decent number of tricks shown in this book I would be amazed if anybody but Bill Jelen (or perhaps Bob Umlas) would know all of them.

Excel Formulas 2010 Just like the title implies, this book covers formulas in Excel from Soup to Nuts. It is very thorough and a must for advanced Excel users.

guerilla data analysis  pivot table data crunching  Taken in tandem these two books would be quite useful for anyone whose job description involved doing a lot of number crunching and analysis. Guerilla Data Analysis has more of a "boots on the ground" kind of perspective while the book on the right is a little more comprehensive look at all aspects of using pivot tables. If you are pondering trying to build pivot tables using Calculated Fields &/or Calculated Items, I would highly recommend picking up the book on the right.  Using Calc'd Fields & Items is a bit tricky and can result is severe errors if you don't know what you're doing.

power programming with VBA  vba and macros  Taken together these two books do a very good job of covering VBA programming in Excel. Using the information in these two books an Excel Power User can develop very powerful macros and automate a huge variety of routine tasks, improving productivity dramatically.

dashboards & reports In 2003 John Walkenbach published a book entitled Excel Charts. This collaboration with Mike Alexander is the successor to that book and does a very nice job of building on what was in John's earlier book. And, as the title implies, it does include a lot of really good information on building dashboards in Excel.

professional excel development This is the definitive book on programming in Excel.  You do NOT want to cut your VBA teeth with this book. This is the book you read after you've already read Walkenbach's Power Programming and Jelen and Syrstad's VBA & Macros. And after you have done a decent number of Excel VBA projects and you feel you are ready to take your Excel programming to the highest levels. This book shows you how to build a professional grade application using Excel as your platform.

slaying excel dragons This book goes from very basic to a nice level of intermediate topics on Excel. It would be a very good fit for someone that has a bit of Excel experience and is wanting to improve their Excel skills and make getting things done in Excel easier and more efficient.

excel gurus gone wild excel outside the box this isn't Excel, it's magic! These last three are a bit quirky and more of a "just for fun" group of books. Nonetheless, they do contain a number of interesting little tricks that are useful to know and that you are unlikely to come across anywhere else.


Top