These are all links to information sites that I've found very useful.
Forums & Usergroups
- VBAeXpress.com [1]:
- VBA specific help for all office applications
- JMT Excel Q&A Board [2]:
- 100% Excel and Excel specific VBA
- OfficeArticles Forum [3]:
- A sub forum dedicated to every office application!
- Excel User Group [4]:
- A site dedicated strictly to all things Excel.
- MrExcel.com [5]:
- Mainly Excel and Excel specific VBA, some Access as well.
- Tech Support Guy [6]:
- The business applications forum support virtually all business applications.
- Tek-Tips [7]:
- There is a help forum here for virtually everything
- UtterAccess.com [8]:
- Mainly Access focussed, but some other applications as well.
Excel Blogs
- The Ken Puls Blog [9]
- Okay, it's a shameless plug, but this is my own blog, which serves as my testing ground for Excel related material, among other things.
- Andrew's Excel Tips [10]
- Andrew Engwirda's Excel Blog
- Daily Dose of Excel [11]
- Dick Kusleika's Excel Blog
- .Net & Excel Blog [12]
- This is Dennis Wallentin's new blog with a very specific focus on .Net and Excel
- Methods In Excel [13]
- Ross McLean's Excel Blog
- Smurf on Spreadsheets [14]
- Simon Murphy's Excel developer's blog
Reference Sites I Use
- Anne Troy's Office Articles [15]
- Anne has over 230 articles and tutorials available for the MS Office suite! Well worth the read!
- Andy Pope's "AJP Excel Information" [16]
- Andy's site is very heavy on Charts, with lots of great pictures and examples. He's also got a collection of Excel based games as well.
- Bob Phillips xlDynamic [17]
- Bob's site contains very comprehensive papers on Excel formulas and VBA. My personal favourite is his explanation of Multiple Condition tests using Sumproduct.
- Chip Pearson's Excel Information [18]
- Chip has an incredible amount of information on his site, including using the Windows API to get at things not accessible through VBA alone.
- Colo's Junk Room [19]
- Colo has all kinds of neat things at his site, including a Class Module tutorial, and tips for teaching VBA programmers how to program in javascript.
- Dennis Wallentin's ExcelKB [20]
- Dennis's site covers pretty much every flavour of VB that you can think of, Excel, Lotus Notes and databases. He has a great variety of KB articles and is well worth the visit.
- Ivan F Moala's Xcel Files [21]
- If it can't be done in Excel, Ivan will have an example of how it can... A site full of truly amazing information and undoubtedly bookmarked by every Excel developer.
- Jan Karel Pieterse's JKP-Ads [22]
- Jan Karel Pieterse is the author of the Name Manager and a MS Excel MVP.
- John Walkenbach's Excel Information [23]
- Author of the Excel VBA Power Programming series... a MUST have book for any aspiring VBA programmer!
- Jon Peltier's Site [24]
- Jon's site is the first place I look if I need to know how to do somthing with Charts in Excel.
- Mark Rowlinson's Code Net [25]
- Mark has some great articles including coverage of Visual Basic, Office and Web programming. My particular favourite is his tutorial on Passing arrays to and from functions [26]
- MVPs Excel sites [27]
- The above is the direct link to the MVPs.org Excel site listing. It lists all of the Excel MS MVPs and alumni sites
- Ron de Bruin's Excel Pages [28]
- If you need to know something about sending email from Excel, this is the place to go. If you're looking for Outlook, Outlook Express or CDO, Ron has examples.
- Russell Proctor's Better Solutions [29]
- Russell has an ever growing site with a host of information for Word, Excel and powerpoint.
- Stephen Bullen's Office Automation [30]
- Stephen Bullen is one of the true Guru's of Excel, and co-author of Professional Excel Development, among other things. His site has some great utilities available for download.
Recommended Addins and Tools(all free!)
- ASAP Utilities [31]
- ASAP utilities is a standard install procedure for many advanced Excel users. Another addin full of great stuff!
- Dave Brett's Duplicate Master [32]
- Dave's addin contains tools to quickly highlight, or delete duplicate data from lists, and can also extract unique items as well.
- HTML Maker [33]
- Colo and Ivan's HTML maker has been used throughout this site to post interactive examples of Excel sheets. It was orignally designed for posting on messageboards.
- MZ Tools [34]
- If you do any VBA developing, you need this addin. It is loaded with useful tools such as a code reviewer and much more to speed up your development process.
- Name Manager [35]
- Jan Karel's name Manager is an essential add-in for working with names.
- PDF Creator [36]
- A free PDF writer utility that supports VBA.
- Smart Indenter [37]
- An awesome little add-in that makes indenting all of your code very simple. I find it really helps to know if you have an issue in a Case or If block, among other things.
- JMT Utilities (formerly Andrew's Utilities) [38]
- JMT utilities is just full of items to extend the functionality of Excel.