

Data Analysis (Statistical Analysis / Optimization) using MS Excel
Understand business scenario and learn to use Data Analysis tool pack / solver /Goal Seek
Self paced
tutorials
What is this course all about?
- This course demonstrates how to use "Data Analysis Tool Pack".
- 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.
Who should take this course?
- This course is for professionals who quickly want to learn statistical analysis / data analysis procedure / solver usage for getting solution of linear programming cases
- This course is not for someone, who is looking to get deep understanding of statistics / genesis of formula etc. For that I will recommend you to check my course "Statistics by Example" .
What makes the course unique?
The course explains almost every thing of data analysis tool pack (except fourier series and z test of mean) and shows how to interpret the output. It also shows how to use Goal seek and usage of solver.
Why Should learns enroll in this course?
- To see the demo of application of statistical technique.
- To see the demo of application of solver in linear programming cases
- To see the demo of goal seek
Is there any study material with the course?
- The course allows to download 18 excel files. Each excel file has data and indication about how to interpret the statistical output.
- The course contains 24 video files.
What are predictable outcome of the course?
Students should be
- Able to 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
Does the course prepare learners for any exam?
No, but it prepares learners to be able to apply data analysis tool pack, solver and goal seek in his work.
Language of instruction: English
- It explains the business scenario and statistical technique applicable
- It shows how to frame the linear programming problem in excel solver
- It explains important section of statistical output & interpretation
- It is more of Excel course which briefly touches about statistics
- For deep understanding of statistics look statistics by example course
I am Gopal an Analytics professional with 13+ years of professional experience. I am a keen trainer, who believes that training is all about making users understand the concepts. If students remain confused after the training, the training is useless. I ensure that after my training, students (or partcipants) are crystal clear on how to use the learning in their business scenarios. My expertise is in Credit Card Business, Scoring (econometrics based model development), score management, loss forecasting and MS access based database application development.
Schedule & Syllabus
