{ 0 comments }

Excel Links of the Week [Dec 1]

in excel links on December 1st, 2008

Every Monday PHD shares some of the best excel related articles around the web so that you are up to date with discussions and new ways to be productive. Here is a list of links recommended for this week.

Clean up data using magic and copy-paste

Unclean data is probably the most time consuming part of any analytical work. I have spent countless hours cleaning few hundred rows of data only to spend another 5 minutes to get the insights. The cleanupdata.com promises to automate the drudgery. All you have to do is paste the unclean data and tell the website how you want to process it and it would do the dirty work.

Learn Excel 2007 through video

If you are an excel beginner and would like to see some videos to learn basic concepts like writing formulas, using auto-fill, the above site is a great place to start.

Make a chart and win Tufte books

Nathan at FlowingData is giving away 2 Edward Tufte’s books: The Visual Display of Quantitative Information, 2nd edition and Visual Explanations. All you need to do is make a good chart of US Immigration data that is shown in his post.

Filter data by Months using Advanced Filters and VBA

DailydoseofExcel presents a cool and simple vba script that would help you filter data by month. (you can also do this by using advanced filter and setting month start and end date as criteria)

What is a OLAP cube?

XLCubed blog explains the basics of OLAP (online analytical processing) and cubes. This is useful if you have never or rarely used pivot tables and need to understand when to use them.

Subscribe to PHD and stay upto date on all things excel and charting

Have a fantastic week ahead.