arrow_back Data analysis with Pydata
How to select right charts for your data? arrow_forward
Visualization using MS Excel - Hands on Workshop
Submitted by Purnachandra Rao Duggirala (@chandoo) on Friday, 27 April 2012
Section: Data Visualization Technical level: Intermediate Session type: Workshop
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
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.