Excel Statistics / Data Analytics

Get Marketable Data Analytic Skills Using the Microsoft Excel Data Analysis ToolPak

4.60 (164 reviews)

Udemy

platform

English

language

Data & Analytics

What you will learn

Run a variety of statistical analyses in Excel (using the Analysis Toolpak), know when to use a given statistical procedure covered in this course, and know how to make a proper conclusion from a statistical test, including professionally written results

Why take this course?

Get marketable data analytic skills in this course using Microsoft Excel. This course will substantially increase your knowledge of data analytics using the extremely popular Microsoft Excel software program, with a focus in the area of significance testing, an important tool for A/B testing and product assessment.

Many tests covered, including different t tests, ANOVA, post hoc tests, correlation, and regression.

This course is great for professionals, as it provides step by step instruction of tests with clear and accurate explanations. Get ahead of the competition and make these tests important parts of your data analytic toolkit!

Students will also have the tools needed to succeed in their statistics and experimental design courses.

In this course, a number statistical procedures will be covered in Microsoft Excel using the Data Analysis TookPak.

The following statistical procedures will be covered in this course:

Central Tendency (Mean, Median, Mode)
Variability (Standard Deviation, Variance, Range)
t tests (Independent t and Dependent t)
Analysis of Variance (ANOVA)
Post Hoc Tests
Correlation
Multiple Regression

For each test, we will cover:

How to perform the analysis step-by-step in Microsoft Excel
What the results mean in clear, yet accurate language
How to effectively, accurately, and professionally communicate the results to others, clearly demonstrating your understanding of the material.

Enroll in this course and obtain important marketable data analytic skills today!

Reviews

James

March 15, 2022

A good course on how to use some of the basic statistical features found in excel. The examples are kept simple so you are able to follow along easily. The explanations are clear and you come away with a good understanding of the concepts presented. A good overall course!

Nick

February 26, 2021

This short course was great. It shows how to use Excel for the most common descriptive and inferential stats. There are no forumulas, and it's all done from the menus rather having to recall functions to type in, as other courses do. If you just want to be able to use Excel for these functions without worrying about the mathematical underpinning or being an Excel wizard, this is great.

Kostas

November 1, 2020

Overall, a useful course for someone that is not working with stats every day and wants to brush up on some of the topics presented. Short concise videos make learning easier.

Stephen

March 20, 2020

Not at All what I has expected. This gives very little explanation of the Statistical concepts being covered. I am not looking to be an expert in Statistics but there is a baseline to be able to effectively use it. Extremely terse and not giving much application for outside use.

Temisan

December 17, 2018

Wow. One of the best Udemy kcourses I have subscribed to. If there's any instructor that can effectively condense a whole textbook of statistics for excel, this is the perfect one. Kudos!

Daniella

November 27, 2018

Seems pretty straightforward. You might want to update the fact that the Data Analysis is useable on Mac's if they have the 2018 version of Excel. :)!

Francisco

August 17, 2018

I feel confident that I am being instructed by a pro. Easy to understand, simplified, starts from the basic foundation. Enjoy learning from videos. One word to describe this course is Satisfaction.

Amie

July 17, 2018

So far so good. Linking the standard deviation as the square root of the sample variance would've been a good thing to provide. I figured it out on my own.

Ian

July 16, 2018

Quick overview of Analysis Toolpak. Very useful if you understand intermediate statistics and need a refresher on Excel's capabilities.

Joseph

June 21, 2018

The data analysis tools are fairly easy to implement (highlight the data and pick the right test). A section that reviews the different tests would be helpful. Half the battle is recognizing which tests to apply and why. In other words, show or explain what the written out formula being done in excel is before highlighting and generating the test statistics.

Tilak

June 17, 2018

The course is helpful for beginners. Spending time on this is worthy and can help in learning many new things.

Dr.

May 7, 2018

Love his courses. I have enrolled in several of this instructor's course. He is one of Udemy's best! Dr. Hawk

Sharath

April 25, 2018

Great tutorial on how to use and interpret excel data analysis tools and results. Course objective was met. Would have been more complete if it included some in-depth explanations of the analysis methods used.

Max

August 6, 2017

Mostly clear but would like to see more examples of a single concept to grasp the concept - repetition, repetition, repetition is the mantra to help your candidates understand these simple but highly technical issues.

Lucija

March 23, 2017

Its very clear and easy to follow. My objective was to better understand how to use excel for statistical analysis and interpret the output and this course really helped me. I finished all in one sitting but I am definitely going to go over it again, once I have to apply it for my research. I'm probably going to have a look at the other courses as well! Thanks!