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.
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)
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. 🙂
![Chandoo](https://chandoo.org/wp/wp-content/uploads/2018/05/chandoo-profile-pic.png)
Hello Awesome...
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.
Thank you and see you around.
Related articles:
|
Leave a Reply
« 5 things that helped me run 10k | Best of Pointy Haired Dilbert – Nov 2008 » |