Ads 468x60px

Monday, November 26, 2012

Excel Links – Lets meet in Chennai this Sunday edition

Excel Links – Lets meet in Chennai this Sunday edition:
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.
Interactive tooltips in Excel

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.
Format Charts Quickly

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.



0 comments:

Post a Comment