The Fifth Elephant 2012

Finding the elephant in the data.

Up next

Visualization using MS Excel - Hands on Workshop

PD

Purnachandra Rao Duggirala

@chandoo

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

Comments