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 http://ugateamunited.com/online/ventolin/ Capital Survey”>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, Flash format (7MB)
- Using Microsoft Excel Web Queries Screencast, QuickTime format (15MB) (Added on 2006-08-17)
