Excel Links of the Week [Dec 1]
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.
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.
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.
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.
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.
Have a fantastic week ahead.
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
More awesome tips for you:
Leave a Reply
|5 things that helped me run 10k||Best of Pointy Haired Dilbert – Nov 2008|