Data Visualization in Excel by Using ExTool
3.8 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,702 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Visualization in Excel by Using ExTool to your Wishlist.

Add to Wishlist

Data Visualization in Excel by Using ExTool

Now that you've conquered basic Excel functions, it's time to transform your data into beautiful visualizations!
3.8 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,702 students enrolled
Last updated 8/2016
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • Students that use Excel in their daily work or education should take this course, no matter his or her proficiency.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
01:18:04
+
Data Visualization Introduction
2 Lectures 08:34
Introduction
05:41

This lecture will demonstrate how to customize your ribbon in ExTool.

Ribbon Customization
02:53
+
Data Visualization Package #1
11 Lectures 31:06
Package #1 Introduction
01:44

This lecture will demonstrate how to generate an interactive force direction chart with arrows describing object relationships.

Force Arrow Chart
02:37

This lecture will demonstrate how to create a scatter plot from user-provided data.

Scatter Plot
02:58

This lecture will demonstrate how to generate a Google map with data from the designated GIS (Geographic Information System) info.

Plot Data on a Google Map
03:12

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.

Plot Pins on a Google Map
02:43

This lecture will demonstrate how to generate a 3D interactive .html file from a set of two dimensional data.

3D Surface Plot
03:03

This lecture will demonstrate how to generate a plot for each set of biomedical data.

Biomedical Batch Data Plot
03:05

This lecture will demonstrate how to generate a single analysis plot for several sets of loss analysis data.

Loss Analysis Plot
03:00

This lecture will demonstrate how to create a scatter plot from user-provided data.

Scatter Plot
02:58

This lecture will demonstrate how to generate a ticker-specific stock analysis chart.

Multiple Stock Information Plot
02:57

This lecture will demonstrate how to create a flood risk map by providing maximum latitudes and longitudes from a square area

Flood Risk Map
02:49
+
Data Visualization Package #2 : Business Intelligence
13 Lectures 35:03

This lecture will introduce the second Data Visualization package--Business Intelligence.

Business Intelligence Introduction
01:01

This lecture will demonstrate how to plot a product category with a Sankey chart.

Sankey Diagram
02:54

This lecture will demonstrate how to plot animated air traffic.

Migration Animation Map
02:55

This lecture will demonstrate how to plot bars with a stepped waterfall configuration.

Stepped Waterfall Chart
02:42

This lecture will demonstrate how to plot basic radar chart.

Basic Radar Chart
02:50

This lecture will demonstrate how to plot multiple bars with designated positive/negative values.

Bar Negative Chart
02:50

This lecture will demonstrate how to plot China's air quality with a heat map

Air Quality of China Heat Map
02:46

This lecture will demonstrate how to plot Shanghai stock market with a candlestick chart.

Candlestick Chart
02:56

This lecture will demonstrate how to plot China's air quality with varying color for each city

Air Quality Map of China -- Color
02:48

This lecture will demonstrate how to plot a aligned funnel chart.

Aligned Funnel Chart
02:53

This lecture will demonstrate how to plot a multiple funnel chart

Multiple Funnel Chart
02:54

This lecture will demonstrate how to plot multiple lines with designated, stacked and shaded areas.

Line Area Stack Chart
02:48

This lecture will demonstrate how to plot a pie chart that varies in size.

Sized Pie Chart
02:46
+
Data Visualization Conclusion
1 Lecture 03:21

This lecture will conclude the course and provide information for further research.

Conclusion
03:21
About the Instructor
Zhenyu Zhu
3.4 Average rating
45 Reviews
3,812 Students
3 Courses
CEO at ParaTool

Dr. Zhenyu Zhu is a senior data analyst, database specialist, and seasoned structural engineer. Hehas 20 years of experience using Excel with advanced data analysis and presentation functionalities and 10 years of programming experience with multiple languages—including Excel VBA. Over the years, he has served as the lead analytical engineer for multiple landscape bridge projects, most significantly the San Francisco-Oakland Bay Bridge. During this time, he also implemented a cloud-based platform to facilitate data communication between multiple disciplinary workers of the design and construction project. The cloud-based platform has, hence, extended to other industrial fields and served as the infrastructure for all of the apps discussed within this course.

Jessica Keaton
3.4 Average rating
39 Reviews
2,526 Students
2 Courses
Writer; Digital Media Marketing Specialist at ParaTool

Jessica Keaton is a recent graduate of San Jose State University's MFA Creative Writing Program. Formally a college English instructor, she is now using her acquired writing skills in the tech industry on the ParaTool Marketing Team.