At work I use pivot tables nearly every day. My work does not involve analyzing business or financial data and still I find pivot tables very useful in manipulating data sets, performing on-the-fly calculations, and preparing final reports.
So, what is a pivot table?
A pivot table is a data summarization tool found in data visualization programs [...]

Name Manager, now at Version 4, is a Excel Add-In that I find useful. Many times I have had to deal with workbooks with more than 100 names, many that are no longer valid. Name Manager helps manage such a mess.
If you are in need of a utility to manage defined names in [...]

An Excel file saving utility from Jan Karel Pieterse.
Autosafe.zip (28 February 2007, 150k, Downloaded: 362 times) Version 3.5 of Autosafe enables use in environments with long paths/filenames. The standard Autosave (note the spelling) utility that ships with Excel just saves workbooks at a set interval, overwriting the file on disk. This is not [...]

A new discussion forum on Excel from XL-Dennis : ExcelKB’s discussion forum.
What ExcelKB’s Forum is about:
• Discussions about software based projects and documentation, both in general terms and more specific projects terms – Best Practical Practice.
• Controlling Excel through automation with developing tools like classic VB and VB.NET/VSTO et al.
• Data exchange between databases (MySQL, [...]

New Excel blog by John Walkenbach on Excel 12 – the next version of MS Excel.
Hey, A New Excel Blog!
This is the first entry in a new blog called The Next Version of Excel. The purpose of this blog is to be a useful (and interesting) source for information related to the upcoming version of [...]