Excel Links of the Week – All Downloads at One Place Edition

25+ Excel Templates – Download and Use [plug]

Have you ever wondered what it would be like to get all the excel downloadables in Pointy Haired Dilbert in one simple page? Well, I did and created this simple excel templates – download page. It has 27 templates currently and I will add more as and when we have new blog posts. Also you can find links to related discussions. Enjoy 🙂

Ten Principles for Chart Design

In another excellent post, PTS blog features this guest article by Mike Alexandar on ten things you should keep in mind when designing charts. Very handy checklist before you set out for that big investor presentation or board meeting next week.

Tracking Fed-Ex, UPS Shipments in Excel

Have you ever had to track your fed-ex shipments like crazy? Well, I did, when we ordered macbook early this year, I couldn’t stop checking the tracking site every few hours to see how close it is to our home. Now you can do that using this excel add-in. Quite handy if you use spreadsheets to manage your inventory and orders.

Google Opens up its Visualization API for Data on the Cloud

Good news! Google has opened up its visualization API. This means you can use data stored on the web in forms other than google docs with visualizations gadgets they have.

Sending Excel Data to MS Access

Excel and Access are like two brothers seperated at birth, even though they look and talk same way, it is difficult to make them understand each other. Debra at Contextures blog shows us a way to send excel data to access using a simple macro.

Presenting Market Share Changes

Remember the visualization challenge “how to show market share differences?” we had a while back? Well, Jon Peltier revisits this with a whole set of options. I suggest reading his post if you constantly make charts that show a set of products performed last year vs. this year.

Got a link ?

Please share with us through commentrs or email at chandoo.d at gmail dot com.

Have a fantastic weeke ahead everyone 🙂

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.