Excel Links of the Week [Dec 15]
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
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.
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.
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.
Leave a Reply
|Interview with Charley Kyd on Everyday Excel||Formula Debugging in Excel – Tip [spreadcheats]|