Another Excel Feature I Missed...

I've just found a really cool feature in Excel
2003
that I didn't know existed. To be fair, I don't for a moment consider myself
an Office expert, so it's probably been around for years, but nevertheless I'm still
impressed.

I often find myself browsing a website, coming across a useful piece of (usually tabular)
information and wanting to save it somewhere for further analysis or later retrieval.
But I had no idea how good Excel was at extracting the data out of some HTML. I was
browsing yesterday through the list of most popular baby names,
which is published each year by the UK Statistics Office. I wanted to print it out
but the bit I wanted kept getting cropped of the edge of the margin. I went into Excel
and somehow found the Data / Import External Data / New Web Query menu option. This
pops up a mini-browser window and allows you to select the table containing the information
you want.

From here, you just click the Import button and it dumps the raw data into a spreadsheet
of your choice, where you can then manipulate it to your heart's content. There are
a few options you can modify if you need extra customisation too, so you're not just
limited to the defaults. Best of all, if the data changes, you can refresh the web
query just with a click of a button, allowing you to keep track of stock
price information
or other dynamically changing data even more easily. If only
I'd come across this feature earlier - can anyone tell me if this works on earlier
versions too?

Now we've just got to choose a name for our next child - the hard part!