The Fifth Elephant 2012

Finding the elephant in the data.

Visualization using MS Excel - Hands on Workshop

Submitted by Purnachandra Rao Duggirala (@chandoo) on Apr 27, 2012

Section: Data Visualization Technical level: Intermediate Session type: Workshop Status: Submitted


This is a half-day workshop to teach how to visualize data using Excel


We will be covering below topics: 1. Scatter Plots & Bubble Charts 2. Heat Maps (using Conditional Formatting) 3. Bending Excel Rules a. Adding 2 axes b. Making smart labels c. Formatting & Highlighting data 4. Adding interactivity to charts with form controls 5. Creating & Optimizing charts when you have lots of data


A laptop with Excel 2007 or above Familiarity with MS Excel

Speaker bio

Anand is a data scientist at Gramener, a data visualisation company.

For more about Anand, visit

Chandoo (Purna Duggirala) has been writing & training people on Microsoft Excel, effective visual communication since 2009. He has received prestigious MVP award from Microsoft for years 2009, 2010, 2011 & 2012. He runs one of the most popular Excel websites at with more than 40,000 active members.

Chandoo has an MBA from IIM Indore & Computer Science B. Tech from Andhra University.



{{ gettext('Login to leave a comment') }}

{{ gettext('You need to be a participant to comment.') }}

{{ formTitle }}
{{ gettext('Post a comment...') }}
{{ gettext('New comment') }}

{{ errorMsg }}