Learn the new advanced analytics charts in EXCEL 2016 today

Master new statistical charting tools in EXCEL 2016 for data analysis
4.4 (5 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.
52 students enrolled
Instructed by Luc Zio Business / Data & Analytics
$19
$50
62% off
Take This Course
  • Lectures 24
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2016 English

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



What are the requirements?

  • Must have EXCEL 2016 desktop version installed and working

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to EXCEL 2016 charting features
06:37

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

00:48

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.

Section 2: Understanding the new advanced charts features in EXCEL 2016 and their use.
01:09

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

01:47

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

00:59

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

01:04

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

01:11

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

02:13

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

01:17

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.

Section 3: Using histograms and pareto charts for data analysis
04:04

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.

04:12

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

06:09

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

04:23

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

03:11

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

Section 4: Analyzing datasets with multiple levels (hierarchal data) in EXCEL 2016
08:12

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

08:51

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

Section 5: Comparing several group means with the Boxplot
09:05

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

07:46

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.

Section 6: Using the People Graph and the Waterfall chart in EXCEL 2016
05:19

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

03:09

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

Section 7: Visualizing linear processes with the funnel charts
03:14

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

04:44

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

02:22

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.

Section 8: Conclusion and other remarks
03:22

Concluding remarks for the course

Section 9: Take the course quizzes to show mastery of the content
1 question

Choosing the right type of advanced charting tool for analyzing data

1 question

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

1 question

Finding which gender group literacy is higher than the other.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Luc Zio, 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.

Ready to start learning?
Take This Course