Data Visualization in Excel by Using ExTool

Name: Data Visualization in Excel by Using ExTool
Rating: 3.9 (130 reviews)

Now that you've conquered basic Excel functions, it's time to transform your data into beautiful visualizations!

Created byZhenyu Zhu, Jessica Keaton

Last updated 8/2016

English

What you'll learn

At the end of this course, students will be able to master their Excel skills by learning both basic and extended data visualization and business intelligence related functions using the ExTool Application. Through this mastery, work efficiency will increase and result in a more productive, positive work or educational environment.

Course content

4 sections • 27 lectures • 1h 18m total length

Introduction5:41
Ribbon Customization2:53
This lecture will demonstrate how to customize your ribbon in ExTool.

Package #1 Introduction1:44
Force Arrow Chart2:37
This lecture will demonstrate how to generate an interactive force direction chart with arrows describing object relationships.
Scatter Plot2:58
This lecture will demonstrate how to create a scatter plot from user-provided data.
Plot Data on a Google Map3:12
This lecture will demonstrate how to generate a Google map with data from the designated GIS (Geographic Information System) info.
Plot Pins on a Google Map2:43
This lecture will demonstrate how to generate a Google map with pins from the designated GIS (Geographic Information System) info. Locate desired color numbers at colorpicker.com.
3D Surface Plot3:03
This lecture will demonstrate how to generate a 3D interactive .html file from a set of two dimensional data.
Biomedical Batch Data Plot3:05
This lecture will demonstrate how to generate a plot for each set of biomedical data.
Loss Analysis Plot3:00
This lecture will demonstrate how to generate a single analysis plot for several sets of loss analysis data.
Scatter Plot2:58
This lecture will demonstrate how to create a scatter plot from user-provided data.
Multiple Stock Information Plot2:57
This lecture will demonstrate how to generate a ticker-specific stock analysis chart.
Flood Risk Map2:49
This lecture will demonstrate how to create a flood risk map by providing maximum latitudes and longitudes from a square area

Business Intelligence Introduction1:01
This lecture will introduce the second Data Visualization package--Business Intelligence.
Sankey Diagram2:54
This lecture will demonstrate how to plot a product category with a Sankey chart.
Migration Animation Map2:55
This lecture will demonstrate how to plot animated air traffic.
Stepped Waterfall Chart2:42
This lecture will demonstrate how to plot bars with a stepped waterfall configuration.
Basic Radar Chart2:50
This lecture will demonstrate how to plot basic radar chart.
Bar Negative Chart2:50
This lecture will demonstrate how to plot multiple bars with designated positive/negative values.
Air Quality of China Heat Map2:46
This lecture will demonstrate how to plot China's air quality with a heat map
Candlestick Chart2:56
This lecture will demonstrate how to plot Shanghai stock market with a candlestick chart.
Air Quality Map of China -- Color2:48
This lecture will demonstrate how to plot China's air quality with varying color for each city
Aligned Funnel Chart2:53
This lecture will demonstrate how to plot a aligned funnel chart.
Multiple Funnel Chart2:54
This lecture will demonstrate how to plot a multiple funnel chart
Line Area Stack Chart2:48
This lecture will demonstrate how to plot multiple lines with designated, stacked and shaded areas.
Sized Pie Chart2:46
This lecture will demonstrate how to plot a pie chart that varies in size.

Requirements

Students will need the Excel software and will also need to download the ExTool Add-on Application from the ParaTool website. It would be helpful to know the basic Excel functions, but not necessary.

Description

This course will teach students how to master their Excel skills by learning both basic and extended data visualization and business intelligence related functions using the ExTool Application. In the first section of the course, students will learn how to create the following data visualizations: 3D Surface Plot, Force Arrow Chart, Plot Pins on a Google Map, Plot Data on a Google Map, and Biomedical Batch Analysis Chart, Loss Analysis Chart, Scatter Plot, Multiple Stock Analysis Chart, Risk Analysis Map. The second section of the course will demonstrate the following functions: Air Quality Heat Map, Candlestick Chart, Stacked Area Line Chart, Colored China Air Quality Chart, Multiple Funnel Chart, Basic Radar Chart, Bar Negative Chart, Sized Pie Chart, Migration Map, Sankey Diagram, Stepped Waterfall Chart, and Funnel Align Chart. Through the mastery of these functions, users will be able to transform their data into beautiful, animated graphics that are easy to work with and understand.

Who this course is for:

Students that use Excel in their daily work or education should take this course, no matter his or her proficiency.

Data Visualization in Excel by Using ExTool

What you'll learn

Explore related topics

Course content

Data Visualization Introduction2 lectures • 9min

Data Visualization Package #111 lectures • 31min

Data Visualization Package #2 : Business Intelligence13 lectures • 35min

Data Visualization Conclusion1 lecture • 3min

Requirements

Description

Who this course is for: