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
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)
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. 🙂
