Event Title

Creating Effective Data Visualizations in Excel 2016: Some Basics

Location

NMOCA 217

Start Date

3-8-2017 3:30 PM

End Date

3-8-2017 3:30 PM

Description

One of the mainstays of a modern software toolkit is Microsoft Excel 2016. By reputation, Excel is considered a beginner’s tool data analysts would bypass, but Excel is fairly high-powered, can take up to 1.06 million rows of data per set, contains complex statistical analysis capabilities (without the need for scripting), and enables rich data visualizations. It has a number of add-ons to empower analytical and data visualization functionalities.
This session walks participants through some basic built-in data visualizations in Excel 2016, including pie charts and doughnuts, bar charts, tree maps and sunburst diagrams, cluster diagrams, spider (radar) charts, scattergraphs, and others. This session will cover how data structures and desired emphases will determine the options for particular data visualizations.

 
Aug 3rd, 3:30 PM Aug 3rd, 3:30 PM

Creating Effective Data Visualizations in Excel 2016: Some Basics

NMOCA 217

One of the mainstays of a modern software toolkit is Microsoft Excel 2016. By reputation, Excel is considered a beginner’s tool data analysts would bypass, but Excel is fairly high-powered, can take up to 1.06 million rows of data per set, contains complex statistical analysis capabilities (without the need for scripting), and enables rich data visualizations. It has a number of add-ons to empower analytical and data visualization functionalities.
This session walks participants through some basic built-in data visualizations in Excel 2016, including pie charts and doughnuts, bar charts, tree maps and sunburst diagrams, cluster diagrams, spider (radar) charts, scattergraphs, and others. This session will cover how data structures and desired emphases will determine the options for particular data visualizations.