Learn the new advanced analytics charts in EXCEL 2016 today
3.9 (13 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.
96 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn the new advanced analytics charts in EXCEL 2016 today to your Wishlist.

Add to Wishlist

Learn the new advanced analytics charts in EXCEL 2016 today

Master new statistical charting tools in EXCEL 2016 for data analysis
3.9 (13 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.
96 students enrolled
Created by Luc Zio
Last updated 10/2016
English
Current price: $12 Original price: $20 Discount: 40% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 24 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • At the end of the course you will be able to effectively use the new and advanced charting tools in EXCEL 2016
  • At the end of the course, you will understand what type of charts to use for your projects
  • At the end of the course, you will be able to make the advanced charts in EXCEL 2016 and interpret them
View Curriculum
Requirements
  • Must have EXCEL 2016 desktop version installed and working
Description

This course is about a new set of charting tools that are available exclusively in EXCEL 2016.  
The new charting features extend the analytical capability of EXCEL and provide the analyst with the ability to do exploratory data analysis that was not possible in EXCEL2010-2013.

The course uses real world datasets in the area of health, world economy, baseball statistics, education and industry to showcase how the data should be organized and transformed prior to the analysis, how the analysis should be performed and especially how to interpret the results.

The datafiles used for the course are available for the student to practice. The course will take about an hour or less to complete and the skills learned can be used right away in your daily business or educational activities.

This course is essential for those interested in data analytics in EXCEL 2016 as it showcases how to effectively use the new EXCEL charting tools for data analysis.



Who is the target audience?
  • Anyone with a basic knowledge of EXCEL or willing to learn
  • Anyone with basic knowledge of the concepts of descriptive statistics
  • Anyone interested in using EXCEL 2016 for data analytics and exploration
Compare to Other Excel Charts Courses
Curriculum For This Course
24 Lectures
01:35:08
+
Introduction to EXCEL 2016 charting features
2 Lectures 07:25

In this section, we will cover the basics of the features that will use for creating charts.

Preview 06:37

The project file name is ProjectNewChartingtoolsExcel2016.   I added new datafiles for you to use for the project work. The name of the sheet in the file tells you what needs to be done. Exemple: Boxplot  (do a boxplot comparing men and women literacy rate for all countries in the world).  For histogram, you only need to do  the histogram of the total literacy rate.
When you are done or if you need help, please contact me.

Download course files
00:48
+
Understanding the new advanced charts features in EXCEL 2016 and their use.
7 Lectures 09:40

At the end of this lecture, the students will know more about the Pareto chart and the Pareto principle.

Preview 01:09

After completing this lecture,students will know about box and whiskers, how they are constructed and used to compare the groups.

Box and whisker charting tool in EXCEL 2016
01:47

At the end of this lecture, students will know about the WATERFALL new chart and the areas of application of this new charting tool.

WATERFALL charting tool in EXCEL 2016
00:59

At the end of this lecture, the students will know about the TREEMAP advanced charting feature and when to use it for hierarchal data.

TREEMAP charting tool in EXCEL 2016
01:04

At the end of this lecture, students will know about the SUNBURST chart and when it is used instead of the TREEMAP.

SUNBURST charting tool in EXCEL 2016
01:11

This lecture provides basic explanations about the histogram and what it is used for.

Histogram charting tool in EXCEL 2016
02:13

At the end of this lecture, the student will learn about the funnel charting tool and will be able to use for appropriate datasets for analytical purposes.

The funnel charting tool in EXCEL 206
01:17
+
Using histograms and pareto charts for data analysis
5 Lectures 21:59

After completing this lesson, you will be able to use the advanced histogram chart tool to easily analyze the distribution of any quantitative variable in your data.

Preview 04:04

After this lesson, you will know how to effectively use the funnel chart to analyze data and draw interpretation about the resulting chart. 

Preview 04:12

In this lecture, you will learn how to create a histogram in EXCEL 2016 and make interpretation of the results.

Creating histograms in EXCEL 2016 part 1
06:09

In this lecture, you will learn how to create and interpret a Pareto chart in EXCEL 2016

Creating a Pareto chart in Excel 2016 (Part 1)
04:23

In this lecture, we continue to reinforce the Pareto principle with more suitable examples/

Creating a Pareto chart in Excel 2016 (Part 2)
03:11
+
Analyzing datasets with multiple levels (hierarchal data) in EXCEL 2016
2 Lectures 17:03

In this lecture, you will learn how to use the EXCEL 2016 advanced analysis tool TREEMAP to analyze causes of death datasets.

Analyzing world nations causes of death datasets with TREEMAP
08:12

In this lecture, you will learn how to use the SUNBURST charting tool to analyze a dataset and make interpretations of the results.

Analyzing data with the SUNBURST charting tool
08:51
+
Comparing several group means with the Boxplot
2 Lectures 16:51

At the end of this lesson, you will know how the data needs to be organized and prepared before using the boxplot charting tool.

Reshaping data to be charted using the Boxplot tool
09:05

In this lecture, you will learn how to use the boxplot charting tools to compare two or more groups means and then draw conclusion from the resulting analytical chart.

Using the boxplot to compare groups means (Part-1)
07:46
+
Using the People Graph and the Waterfall chart in EXCEL 2016
2 Lectures 08:28

At the end of this lecture, students will be able to use people charts tool to analyze data 

Using the people chart tool in EXCEL 2016
05:19

At the end of this lecture, you will know how to use effectively the Waterfall chart to analyzed data with positive and negative values.

Analyzing financial data with the waterfall chart
03:09
+
Visualizing linear processes with the funnel charts
3 Lectures 10:20

At the end of this lesson, the student will understand how to use the funnel chart to display data that progresses in stages.

Preview 03:14

After this lesson, you  will know how to construct an effective funnel chart by sorting the data before or after producing the chart.

Preview 04:44

In this lecture, you will learn how to use the funnel charting tool to analyze data and also be able to interpret the resulting analysis.

Analyzing data with the funnel charting tool
02:22
+
Conclusion and other remarks
1 Lecture 03:22

Concluding remarks for the course

Concluding remarks on EXCEL 2016 new advanced charts tools
03:22
+
Take the course quizzes to show mastery of the content
0 Lectures 00:00

Choosing the right type of advanced charting tool for analyzing data

Which type of chart is appropriate to be constructed with the following data?
1 question

Determining the composante of a box and whisker chart in EXCEL 2016

In a box and whisker chart, the horizontal line inside the box represents?
1 question

Finding which gender group literacy is higher than the other.

Comparing literacy data for men and women in the world
1 question
About the Instructor
Luc Zio
3.9 Average rating
109 Reviews
1,804 Students
9 Courses
Adjunct faculty of Math and Statistics

I  have over 18 years of work experience in the field of statistics as an Applied Statistician. For the last  twelve years, I have also  been teaching undergraduate college level statistics courses at St Petersburg College.  As an Applied Statistician, I have developed over the years a strong interest in using EXCEL as a statistical tool with my classes in order to give to the students real world hands-on experience with Statistics.