cellmatrix.net

The Spreadsheet Page Revisited

Due to work I've been away for approximately one month. Upon my return, I discovered that John Walkenbach's Spreadsheet Page has been completely redesigned. All I can say is - what a nice format! In addition to the high quality of information provided, the new site is easy to navigate and very professional looking.

John has also started a blog called The Spreadsheet Page Blog, which can also be found at the new site.

Technical Articles and Reports by David A. Heiser

David A. Heiser writes a very comprehensive essay titled Errors, Faults, and Fixes for Statistical Functions and Routines in Excel.

Concerning charts in Excel 2007, David writes "Building charts has completely changed, and their appearances also completely different. There is an increased ability to put in chartjunk’, lighting effects, shading, 3D renderings, flashy, distracting figures, silly variations, insertion of icons, visual distractions, etc. This is what the business world wants, the ability to insert effects to obscure, bias or just to add variety to frequent presentations."

Interesting. Something that I deal with all the time at work is the need to use 3D renderings and other worthless visual effects for presentations. When I object most people look at me like I've got two heads. Am I just wrong? Thoughts?

Charting Add-Ins Updated

The following chart-related add-ins were recently updated:

Each of these add-ins is available as a free download via the links above.

Updates to selected sites with RSS feeds are available via the RSS Updates page of this site.


Microsoft Knowledge Base

The Microsoft Knowledge Base is a great resource for Excel support. Below are a couple of useful links: