Excel Links – Lets meet in Chennai this Sunday edition
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.
Moving on to Excel links..,
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.
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.
|Financial Ratios – Cappuccino or Latte?||Extract data using Advanced Filter and VBA|