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:
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.
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.
