The Statistical Analysis Skills Training (SAST) in Excel
A comprehensive course to undertake the statistical analysis functionalities in Excel on real-life large data sets
Skills you will learn:
- Comprehensive statistical analysis in Excel
- Frequency curves
- Histogram charts
- Descriptive statistics
- Correlation analytics
- Regression analytics
- Data smoothing techniques
- Moving averages
- No prior qualification required
See how are participants are engaging regularly with our training programs
Last 12 months = 629,585 mins
(Updated: January 2020)
Ashish is a Business and Finance Expert with around 10 years of experience in this domain. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked with the Strategy and Corporate Finance practice at McKinsey, the world’s most prestigious consulting company. He has advised clients globally on various Strategy and Finance engagements.
Ashish is also the founder of an education firm SKILLFIN LEARNING which curates content in Business, Finance and Data Analysis topics. He conducts corporate trainings in a leading global consulting firm. He is passionate about teaching and strongly believes education should be accessible and affordable to all.
What will you learn?
PreviewYour instructor (1:38)
PreviewLecture 1: Welcome to the course (0:28)
PreviewLecture 2: What will we learn in this course? (3:26)
StartLecture 3: Why Excel is a good tool for Statistical Analysis? (1:52)
StartLecture 4: What are the limitations of Excel as a tool for Statistical Analysis? (2:01)
StartLecture 5: Steps to activate the Statistical Analysis Add-In in Excel (0:33)
StartLecture 6: How to activate the Statistical Analysis Add-In in Excel (2:31)
StartLecture 9: Conceptual understanding of Histogram (2:52)
StartLecture 10: Illustration for HISTOGRAM analysis in Excel (1:41)
StartLecture 11: Calculating the monthly return in Infosys share price (2:33)
StartLecture 12: Calculating the Range for the HISTOGRAM analysis (2:18)
StartLecture 13: Calculating the measures of central tendency of the data (1:40)
StartLecture 14: Calculating the Data Range for the HISTOGRAM analysis (2:34)
StartLecture 15: Undertaking the HISTOGRAM analysis in Excel (2:32)
StartLecture 16: Decoding the HISTOGRAM analysis (1:24)
StartLecture 17: Please provide us your valuable feedback on the course thus far
"A great learning experience with data set example sheet so that the illustrated methods can be practiced along with the course pace. Happy learning. Regards, Awnish Kumar Jha"
- Awnish Kumar Jha, Manager Reliance-Nippon Insurance
"Fundamentals of statistics taught in the most simplest way."
- Dinesh Kumar, Data analytics professional