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.
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.