Excel Links of the Week [Dec 15]

Posted on December 15th, 2008 in excel links - 0 comments

Finally I got internet connection at home. The folks at Airtel Broadband are very fast and professional. They set up the connection in very few days. So I will be able to blog regularly from now on.

Moving to this week’s excel links you should browse:

Convert Excel Tables to HTML

Excel is very good when it comes to handling tabular data. But what if you need to convert a table in excel to HTML? No worries, use the tool linked above to get web tables from your lists

Back up excel files while you work using VBA

Have you ever worked on same excel file and saved it with a different name to maintain the versions? I do this all the time. Thanks to Debra, who came up with a simple macro to save a backup version of the file in a specified folder by appending current date-time stamp to the filename.

Charts that make you go wtf

Tony at SupportAnalytics shares 11 charts that will shake your head. Check it out for some Monday fun.

Introduction to Error Bars in Charts

My friend Jon explains the error bars in excel 2007 charts, a very useful feature. Until few days ago I had no clue what they do and this post definetly makes understanding them a bit easier for the Excel 2007 users.

Tell about your fav VBA code and win Excel goodies

JP, who is a regular commenter on this blog and author of Code For Outlook and Excel where he shares VBA code snippets has completed 100 posts and celebrating that by giving away free books. All you need to do is just tell him about your favorite code / usage.

Written by Chandoo
Tags: , , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

Leave a Reply