Excel Links - Information Sources

Mailing Lists, Newsgroups and Books

There are several mailing lists and newsgroups that provide a valuable source of information and answers to specific questions.
The Excel community is very friendly and helpful and many experts spend considerable time answering questions.
The two "most advanced" sources are probably the EXCEL-L mailing list and the Microsoft.public.excel.programming newsgroup

Mailing Lists

• MS Excel General Q&A List
  The EXCEL-G mailing list for general questions about Excel. Follow the link to subscribe.
• Microsoft Excel Developers List
  The EXCEL-L mailing list for VBA and advanced questions about Excel.
• Excel-vb-Discuss
  A mailing list discussion group about developing applications using Excel VBA.

Selected Newsgroups

To subscribe to these newsgroups you need access to a news server. Most ISP's provide one carrying the newsgroups below.

• Comp.Apps.Spreadsheets
  General spreadsheet group, useful for non-Excel questions.
• Microsoft.Public.Excel.Misc
  General Excel newsgroup.
• Microsoft.Public.Excel.Programming
  Newsgroup about Excel and VBA Programming.
• Microsoft.Public.Excel.Worksheet.Functions
  Newsgroup for questions and answers on the Excel function library.

Books

There are a lot of excellent books published about Excel and VBA. Here is my personal shortlist:

• Microsoft Excel Worksheet Function Reference - Microsoft Press
  The complete reference to the Excel function library. I use this more than any other book.
• Microsoft Excel 2002 Bible - John Walkenbach
  An excellent general reference for Excel.
• Microsoft Excel 2002 Power Programming with VBA - John Walkenbach
  Probably the best book on Excel and VBA. Get this one first.
• Excel 2002 VBA Programmer's Reference - John Green and Stephen Bullen
  Get this one next!
• VBA Developer's Handbook - Ken Getz and Mike Gilbert
  If you want to progress your VBA programming skills this book is for you.