The Fifth Elephant 2012

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

Outline

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

Requirements

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 http://s-anand.net

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 Chandoo.org with more than 40,000 active members.

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

Links

• http://s-anand.net/
• http://chandoo.org/wp/