Category Archives: Screencast

Microsoft Excel Web Queries (Screencast)

Today I took some free time and created another screencast, this time covering a really cool feature of Microsoft Excel: Web Queries. Web queries let you import data directly from a web site. This is a great tool for importing table-based data for your own analysis or sorting.

In the example recorded today, I use Excel to fetch the Q2 Venture Capital Survey data from the San Jose Mercury News website. You might be interested in this data if you were looking for a job or selling Aeron chairs.

Using Microsoft Excel Web Queries - Screencast -

Screencast: Aardvark Firefox Extension

I recently discovered the Aardvark Firefox extension and have found it quite helpful for printing web sites that don’t already offer “printer friendly” versions. Aardvark lets you remove page elements like navigation bars or ads. Whether you’re printing out a longer article or just trying to read something online, this is really a helpful tool.

To demonstrate this extension, I’ve made my first screencast with Camtasia Studio. I’m still trying to figure out the best combination of image/sound quality versus file size. I’ve published a couple different combinations to try:

Update 2006-08-16: I re-created the Flash version to improve the audio. File size is up a little, now 20MB, but the screencast sounds much better now.