Advance Analytics with Excel - data analysis toolpak/ Solver
Advanced data analysis in excel: Data Analysis tools (toolpak add-in) for statistics / solver for linear optimization
4.45 (1136 reviews)
5,611
students
3 hours
content
Jan 2021
last update
$64.99
regular price
What you will learn
Perform Data Analysis / Statistical Analysis using Excel
Be comfortable with data analysis tool pack / solver / goal seek
Understand the business context / scenario where the statistical procedure is applicable
Understand the most important portion of statistical procedure output and how to interpret it for a given scenario
Know how to solve linear programming cases using solver
Why take this course?
What is this course all about?
- This course demonstrates how to use "Data Analysis ToolPak".
- It explains the business scenario and then shows application of statistical procedure using data analysis tool pack on the given data.
- The course also shows how to use Goal Seek and Solver (to solve linear optimization problems)
- It gives clue about what is the most important portion of statistical procedure output and how to interpret it with respect to problem at hand.
Tags
- Statistical Analysis using Excel
- Linear optimization using Excel
- Data Analysis toolpak (Excel Add-in)
- Statistical Analysis case studies
- Data Analysis examples
- Data analysis using Excel
What Kind of Material is included
- All the excel files that has been used in videos are available to download.
- These excel contains data files, so that students can practice it on their own.
How long it should take to complete the course
It should take roughly 10 hours to practice and master all the procedure.
How is the course structured
The course first explains a business context and the data. Then it demonstrates how to use statistical procedure using data analysis tool pack. It Also explains how to solve linear programming problem using solver. It demonstrates how th use goal seek. The content of the course will be
- Numeric data Analysis
- Categorical data Analysis
- Chi square test of independence
- Simple Linear regression / Multiple linear regression
- F test for equality of variances
- T- Test for Comparing two sample means
- Pair t test
- ANOVA – single factor
- ANOVA – two factor with / without replication
- Generating random numbers with uniform / normal / poison distr.
- Rank and Percentile
- Histogram and pareto charts
- Goal seek
- Linear programming problem - Solver example
Why Take this course
- To quickly understand how to perform statistical analysis using excel.
- The understand, which are the most important portion of statistical procedure output and how to interpret it for a given context.
- To understand the process of formulating linear programming cases in solver and getting solution.
Screenshots
Reviews
Aleksandrs
April 2, 2024
Not all screen was seen during course. There also could be explanation of what results of all calculations mean, but not only "p-value".
Bryan
August 6, 2023
The added questions to each video were helpful. I'm not sure why the questions stopped for the second half of the course. Also, I didn't appreciate the YouTube detour in section 2.
Ahmed
July 9, 2023
nice, course, straight to the point and simple, advised for people who has solid background in statistics and looking for applications on excel
Braj
January 3, 2023
It was a good learning to know all the statistical formulas can be used directly in excel instead of going to Python and R for small datasets.
Oscar
November 11, 2022
Extreme effort by the instructor. Very knowledgeable. The modules will help me as a team leader in creating reports and analysis
Reka
September 27, 2021
the content would be very useful if it wouldn't be so hard to follow the hard-to-understand accent of the presenter.
Darren
April 17, 2020
Great course! I learned a lot on how to analyze data in Excel. The format was well structured with both the problem to solve and the solution clearly identified; as well as how to interpret the data. Great job!
For further improvement, I recommend each section be peer reviewed by someone who knows how to clearly explain the data results and how to interpret the data. Maybe a Marketing or Finance colleague who can clarify some of the wording of the problem statements and interpretations to appeal to a broader audience.
Ignacio
April 11, 2020
Yes, it has practical explanations that I needed and the rationales are shown step by step.
Great course so far.
Patrick
February 29, 2016
Really nice class. There were lots of examples about how to use the various analysis functions in Excel. I will be taking other classes from this teacher.
Dp
October 22, 2015
I spent four hours in a class on Saturday to NOT learn what this person taught me in less than 5 mins...
Anand
October 9, 2015
This is one of the best excel tutorial I have come across, that explains the advanced excel topics like Solver, Goal Seek, Smoothening of data series, etc. I would recommend this to everyone who wants to understand the above topics with examples. The best part of this tutorial is that one can practice side by side along with the teachings and you can learn quickly by doing it yourself.
Thanks for creating this!! :)
Md
May 19, 2015
As a beginner, I would say the way it has been explained, is really a good start for me. I believe the next level must be more comprehensible.
Michael
November 19, 2014
This is a very good course that has just the right level of instruction and detail for someone who may have had an undergrad stats course, but is wondering how they might apply it in the real world. Gopal is very straightforward and provides useful examples to which the student can return for review and retention. The section on Solver was better than many I've seen because it provides detailed instruction, but just the right level of complexity to understand the power of the tool. Very well done. Highly recommended.
Abhishek
November 10, 2014
I've already started using skills I learnt from this course in my Job. That was my objective and thanks to our Trainer Gopal for providing no-nonsense professional friendly course
Sean
November 9, 2014
The course was very well presented and each subject was explained in an easy to understand manner. The course material is an excellent resource to assist with a better understanding of the subjects and for further practice
Charts
Price
Rating
Enrollment distribution
Related Topics
322820
udemy ID
10/20/2014
course created date
11/22/2019
course indexed date
Bot
course submited by