Creating Data Visualization and Infographics in Excel

  EVENT DATE

July 28, 2017

  PRESENTER(s)

Neil Malek

  1:00 PM ET | 12:00 PM CT | 10:00 AM PT | 60 Minutes




DESCRIPTION



Add Power to Data Representation with Visualization & Infographics in Microsoft Excel!

No matter how important the details in your spreadsheet, if you can’t communicate your insights with other (less technical) people, that information won’t change anything. Being able to tell an effective story through the use of charts and other visualization tools is the key to communicating effectively. Join us to learn not only how to create compelling graphics, but how to choose the right one for each situation.

Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on. We are constantly hearing words like data visualization and Infographic. It's time to get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world.

In this session by expert speaker Neil Malek, you will be able to build a compelling and effective visualization for the data sets you see every day. You’ll also learn how to create Sparkline charts (really useful in dashboards), infographic-style charts and how to represent data in a visual way without using the charting features at all.
The training will be delivered using Excel 2016 for Windows although for users of earlier versions, much of the functionality is available in Excel 2010 and 2013.

Session Highlights:
  • Creating Dashboards with Pivot Tables and summaries
  • On-the-fly filtering for compelling storytelling
  • Advanced charting techniques
  • Color-coding charts dynamically
  • Combination charts - line and bar in a single chart
  • Dynamic charts - automate adding new data to a chart
  • Build waffles, maps, and other compelling visuals
  • Creating infographics with Excel
  • Using Conditional Formatting to present data visually
  • Using Excel add-ins to create infographics

Who Should Attend?

  • This training is categorized as basic-to-intermediate. It is aimed at users who have little or no knowledge of how to produce visuals in Excel
  • Attendees should be familiar with how to navigate around an Excel workbook and how to enter and edit data. Knowledge of basic formulas would be beneficial but not essential 
  • The training will be delivered using Excel 2016 for Windows although much of the functionality is available in earlier versions of Excel on both Windows and Mac.

Download Conference Material




RELATED WEBINARS

 


CERTIFICATION PARTNERS

 
HRCI
HRCI
HRCI
HRCI