An introductory video (youtube) by bytebodger describing the use and creation of pivot tables in Excel 2007.

Here is a video from freetutorials (youtube) on using Excel to manage simple databases.

The REPT function repeats text a given number of times. For example, =REPT(”*”,10) repeats * 10 times in a cell.
You can use this function to create a simple bar for values in multiple cells.  Here is a short video on YouTube:

Personally, I use Excel 2003 at work and Excel 2007 at home. I am constantly (as in 3 or 4 times a weeks) using Excel 2003 files in Excel 2007.
I found this tip at vista4beginners.com showing how to have Office 2007 automatically have files in the Office 2003 format: Configure Microsoft Office 2007 to save [...]

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, [...]

I read an article in the Denver Post this week regarding Sudoku Puzzles.  I then completed several puzzles at websudoku.com.
You can create and solve sudoku puzzles using an MS Excel work book from Andy Pope: AJP Excel Information – Su Doku puzzle.
I also found a Sudoku puzzle solver at Office Online via Daily Dose of [...]

An interesting idea. But how, beyond the neato factor, would one use an Excel sheet with an embedded Google map?
Here’s my first attempt at using google maps in excel (download below). Currently I can input an address and have a google map of the address displayed in Excel, with most of the cool google functionality.
Source [...]

I wonder what the performance is like for the spreadsheet control that allows you to create a spreadsheet object with 262,144 Rows and 18,278 Columns.
Want more rows, more columns?
Think Excel is too small; Only 65,536 rows and 256 columns?
Try the Spreadsheet control; a Microsoft ActiveX control.
Source – Office Tips and Hints Blog

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 [...]

The Excel 2003 VBA Language Reference has been updated.
Welcome to the Microsoft Excel 2003 Language Reference. This reference contains conceptual overviews, programming tasks, samples, and references to guide you in developing solutions based on Microsoft Excel.
Publish date of this reference: July 2005 (version 2003)
Download the Microsoft Excel 2003 Language Reference
The reference contains the following sections:
What’s [...]

Microsoft Visual Basic for Applications (VBA) is the programming environment and language for Microsoft Office that has been available for several years. Microsoft Office 2003 Editions have a new environment for building applications, called Visual Studio Tools for Office, which is based on the Microsoft .NET Framework.
Microsoft Visual Studio Tools for Office, Version 2003, offered [...]

Along with Pivot Tables, AutoFilter is one the Excel features I find most useful. I have always found that it a little hard sometimes to see which columns I am filtering on. Many times I have turned off the AutoFilter and then turned it back on in order to start from scratch.
Summary: When [...]