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.
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|Financial Ratios – Cappuccino or Latte?||Extract data using Advanced Filter and VBA|