Hi readers…
I am in Chennai this week, conducting in-house training at Renault Nissan on Advanced Excel. As I am busy teaching Excel & making young graduates awesome in it, I will not be able to write much on the blog. But don’t worry. We have some great articles coming up from Hui & other guest authors.
Coffee & Conversations for Chandoo.org Chennai Clan
If you are in Chennai, love Excel & coffee, you are in for a treat. This Sunday (2nd December), join me for hot coffee in the morning (8-10AM).
RSVP using below links.
Yes I want to join this meet up (alternative link: Facebook Event).
Moving on to Excel links..,
Show sparklines for hidden data too
Debra tells how to setup sparklines for data that is in hidden cells. If you have not tried sparklines, you are missing out on one of the most fun, easy to use charting feature in Excel 2010 / 2013. Check out this tutorial to get started.
Robert shares an elegant mechanism to display rich, interactive tool tips in Excel. Very useful for data heavy dashboards & reports.
Book Recommendation: Power Pivot for Analysts
I just finished reading Bill Jelen’s Power Pivot for Data Analyst, an excellent book for those of us getting started with PowerPivot. It is easy to read with insightful, explanative & humouros commentary of Bill. Make sure you download the example workbooks and practice more.
From our archives, this one shows you how to quickly format charts. Works in Excel 2007 and above.
Have a good week ahead
And oh yeah, if you are in Chennai, don’t forget the meetup. Make sure you RSVP using above links so that I can send you venue & time details.
5 Responses
Welcome to Chennai
For me the thought of good coffee and some interesting new Excel knowedge is a pleasant connotation!
Thanks for the great stuff you keep gently putting in front of us Chandoo.
cheers
John H
Thanks John and Vara…
Hi,
To all the readers and members. I was glad to meet Chandoo yesterday in “The Park” hotel. My mental image about Chandoo was totally smashed after meeting him.I was surprised to meet a humble and simple person who is clear in his vision.
Thanks very much for your invite and All the Best for your efforts to make us awesome in Excel.
I am happy too to have met Chandoo at Chennai. Had a short but interesting conversation. Would have loved to spend some more time; but, I was late due to personal work. Thanks Chandoo for organizing this!