We had a long weekend in India due to Republic Day on 26th January and that means, I have enough time to fiddle with some of the things on the blog design / code front. There are few minor changes in the blog sidebar layout and RSS Feeds.
» The sidebar on the home page features some of the most frequently searched excel and charting topics like top 5 formulas, howtos, charting tutorials. To checkout the featured topics, visit the homepage.
» We now have a page dedicated to people who want to advertise on PHD. Write to me if you want to advertise your products / company on this site.
» The RSS feed address is now http://feeds2.feedburner.com/PointyHairedDilbert not http://feeds.feedburner.com/PointyHairedDilbert. Don’t worry about the change as Google will take care of redirecting your feeds, but just in case.
» If you are one of the 500 e-mail subscribers of PHD, going forward you will receive e-mails from excelandcharting @ gmail.com and not chandoo.d @ gmail.com. Please redefine any rules you might have defined in outlook / mail software to handle the new mail id.
Ok, enough self-promotion, let us take a look at this week’s excel links and articles from around web.
In this excellent tutorial, Jon explains stock charts in excel and how you can use them. Read it if you have never used a stock chart or don’t know what they are.
This flow chart is very useful for deciding on the right type of chart for your data and visualization needs. Also checkout Juice Analytics’ Chart Chooser
Debra suggests using F4 key to creating named ranges in a snap. Very useful.
Often you have a large workbook with several sheets and you want to print one consolidated worksheet with all the relevant areas from other sheets. You can create a consolidated sheet and use paste special to paste links to source ranges.
You might need this trick if you use excel to manage lists of files (I do this all the time, when I am uploading a bunch of images to my site and need to create IMG tags)
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.
Thank you and see you around.
Leave a Reply
|« Do you know how to KISS, Wall Street Journal Does!||100 Excel Tips & Resources »|