Advance Analytics with Excel - data analysis toolpak/ Solver (Udemy.com)
Advanced data analysis in excel: Data Analysis tools (toolpak add-in) for statistics / solver for linear optimization
Created by: Gopal Prasad Malakar
Last updated January 2021
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
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.3 out of 5higher than 13% of them
- Reviews1,659#127 of 356 by number of reviews
- Length2.8 hoursshorter than 77% of them
- Last updatedJanuary 2021earlier than 70% of them
Course Description
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.
Instructor Details
- 4.3 Rating
1,659 Reviews
Gopal Prasad Malakar
I am the Founder & CEO of ProData Science AI Consultancy Pvt. Ltd. and an analytics leader with 25+ years of industry experience in Data Science, Artificial Intelligence, Machine Learning, Business Analytics, Decision Strategy, and Enterprise Data Strategy.
Throughout my career, I have focused on one mission: turning data into measurable business value. My experience spans building predictive models, designing enterprise analytics platforms, developing scorecards, forecasting business performance, and helping organizations make better data-driven decisions.
I am also the creator of Extreme-ML—an AI-powered Zero Code, Zero Prompt analytics platform that enables users to perform sophisticated analytics and machine learning without programming or prompt engineering. The platform combines advanced automation, statistical rigor, and AI-guided workflows to make enterprise-grade analytics accessible to everyone.
Teaching is my passion. I believe that training is successful only when learners can confidently apply concepts to solve real business problems. Every course I create is designed to explain not only how techniques work, but why they work, when they should be used, and how they create business impact. My goal is to bridge the gap between academic concepts and practical industry application.
More courses by Gopal Prasad Malakar
Excel VBA Bootcamp: VBA Programming with Practical Workouts (2024)
4.0 (5,956 Reviews)
Provider: Udemy
Time: 4.5h
$11.99
Logistic Regression using SAS - Indepth Predictive Modeling (2025)
4.3 (1,151 Reviews)
Provider: Udemy
Time: 18.2h
$13.99
Statistics for MBA/ Business statistics explained by example (2024)
4.2 (407 Reviews)
Provider: Udemy
Time: 15.7h
$64.99
Principal Component Analysis (PCA) and Factor Analysis (2018)
4.1 (258 Reviews)
Provider: Udemy
Time: 1.7h
$39.99
Crash Course : SAS Macro Programming By Example (2023)
4.0 (178 Reviews)
Provider: Udemy
Time: 1.8h
$29.99
Crash Course : SAS Programming from Scratch with workout (2023)
4.2 (174 Reviews)
Provider: Udemy
Time: 4.8h
$19.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Lori Modico on 5/9/2020
He is very knowledgeable but jumps around too much. To make this important tutorial better I would like to see more fluidity in the data sets. There are three data sets illustrated and it confuses the process. I like the variations, possible add them at the end as a practice and apply section. The voice of the instructor is very flat. I find myself drifting and having to go back and listen again.
By Akanksha Verma on 5/2/2020
i feel that a little more on hypotheses could have been added in this course to make it even better for students to understand. moreover a brief introduction on what is the use of certain tools in the beginning of each video would have been added.
By Darren Charette on 4/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.
By Anonymized User on 4/11/2020
Yes, it has practical explanations that I needed and the rationales are shown step by step. Great course so far.
By Aichatou Mohamadou on 11/29/2019
bonjour a vous oui le cours m as vraiment interesser et correspondais a mes attentes la seule difficulte est que je ne metrise pas bien la langue anglaise se qui fais que j ai ete trop lente et j ai du repasser les video a plusieurs reprise si vous pouvez egalement faire des cours en francais je serais satisfaites a 100% . comment avoir mon certificat s'il vous plais.
By Sonal Somani on 5/18/2018
To the point examples of how to use Excel Solver and Analysis Tool Pak functionalities. Not for people looking for an explanation of the mentioned statistical concepts. Swift and example based approach. Appreciate the efforts of the instructor.
By Ivana Bunjevacki on 2/4/2018
Very clear and practical. The explanations are easy to understand and logical and what's of crucial importance is that the statistical analysis procedures are applied to real life business situations together with their interpretation.
By Mee S on 8/11/2017
Great coverage of material from both excel and data interpretation perspective. This course will serve as an excellent refresher for those who have some statistical knowledge or at least familiarity with the very basic measures.
By Divya Soni on 10/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!! :)
By Michael Balongie on 11/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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 86 / 100












