The Fifth Elephant 2012

Finding the elephant in the data.

Visualization using MS Excel - Hands on Workshop

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

videocam_off

Technical level

Intermediate

Section

Data Visualization

Session type

Workshop

Status

Submitted

Vote on this proposal

Login to vote

Total votes:  +11

Objective

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

Description

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

Login with Twitter or Google to leave a comment