|
For information about Excel
1. Microsoft Knowledge Base
This site contains a number of articles on selected topics.
2. John Walkenbach's page
This is one of the best Websites related to Excel. It includes tips, files to download and an extensive list of links.
Sites answering your questions
1. Microsoft Newsgroups offer you the opportunity to post questions and receive answers. You need a special newsreader software to access newsgroups (such as Outlook Express) but you can also access them at the above link.
2. MrExcel is a discussion board that is watched by experts and you usually receive answers in a short period of time. I found it very useful.
Add-ins
1.Google directory - This is an extensive list.
2.ASAP Utilities - This is probably one of the word's most popular free add-ins.
3.Business Functions includes 103 free useful functions. Enhanced versions are available for sale.
4.The Add-ins.com provides over 50 time saving Add-Ins.
Auditing software
1. A comprehensive list of Auditing Add-ins is found in the Mathtools site.
2.Rainbow Analyst. It uses colour to highlight different types of cells and potential problem areas.
3.The Spreadsheet Detective. It provides automated documentation that highlights mistakes.
3. Free software can be found in the following sites:
Xl-logic.com - Explote Add-In
This is a trace precedent / dependent automation tool
Dslimited - UltraSleuth Personal Edition
This is an advanced Auditing program. If you are going to use it for commercial business you have to buy it.
Miricle Solutions - Spreadsheet Professional Free Version
This is an advanced program but the free version can audit spreadsheets with 100 rows or less. The normal version is available for sale.
MeadInKent - SheetMap Worksheet
This is a macro that creates a sheet Map
SpreadsheetStyle - ReferenceBrowser Add-In
This is an Add-In that browse the precedents and dependents of a cell one at a time.
The FORMLIST Add-In
A simple Add-In that lists the formulas of a selected range.
Other links
|
