Excel Links of the Week – All Downloads at One Place Edition
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
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.
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.
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.
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.
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
|5 Visualizations for your Inspiration [Nov 07]||Excel Formula for Finding Repeated Words in a Cell|