Statistical Computing Master Class in Excel
Offered by
Benaadir Research, Consultancy & Evaluation Center (BRCE)
-
LevelAll Levels
-
Total Enrolled220
-
Duration6 hours
-
Last Updated29/04/2026
-
CertificateCertificate of completion
Course description
The “Statistical Computing Master Class in Excel” is an advanced course designed to provide in-depth knowledge and practical skills in statistical analysis using Microsoft Excel. The course is structured to guide you through the essential aspects of statistical computing, from data collection and cleaning to performing complex inferential statistics. Each section is meticulously crafted to build your proficiency in leveraging Excel for statistical tasks, making it an invaluable tool for data analysis in various professional fields.
Why should you take this course?
This course is perfect for anyone looking to harness the power of Excel for statistical analysis. Excel is one of the most widely used tools in business and academia for data analysis due to its accessibility and versatility. By taking this course, you will:
- Gain a comprehensive understanding of Excel’s statistical functions.
- Learn practical skills for real-world data analysis.
- Improve your ability to make data-driven decisions.
- Enhance your resume with advanced Excel and statistical computing skills.
Who is this course for?
- Business professionals who need to analyze data as part of their job.
- Students and academics conducting research requiring statistical analysis.
- Data analysts looking to enhance their skills with Excel.
- Anyone interested in learning how to perform statistical analysis without specialized software.
Material Includes
- 3 Downloadable Excel Datasets
- 1 Downloadable course note
Course Curriculum
Section 1. Course Overview
-
36:53
-
Basic Aggregations
20:55
Section 2. Data Basics
-
Developing questionnaire
06:16 -
Data collection (online)
19:20 -
Downloading and importing data into Excel.
01:35 -
Data Cleaning
05:03
Section 3. Descriptive statistics
-
Statistical Analysis Using Pivot table
28:32 -
Statistical Analysis Using Charts
09:31 -
Measures of Central Tendency
19:34 -
Measures of Dispersion
18:52 -
Descriptive statistics
25:52
Section 4. Inferential statistics
-
Fundamentals of hypothesis testing
47:42 -
One Sample t test Example 1
16:18 -
One Sample t test Example 2
07:36 -
Independent T-test Example 1
08:04 -
Independent T-test Example 2
09:13 -
Dependent T-test (paired) Example 1
05:11 -
Dependent T-test (paired) Example 2
03:00 -
One-way (between Subjects) Annova Example 1
12:45 -
One-way (between Subjects) Annova Example 2
05:34 -
Repeated Measured (Within Subject) Annova Example 1
11:04 -
Repeated Measured (Within Subject) Annova Example 2
02:00 -
Correlation Example 1
04:39 -
Correlation Example 2
02:59 -
Regression Example 1
05:19 -
Regression Example 2
04:24 -
Chi Square Example 1
10:18 -
Chi Square Example 1
17:19
Final Assessment
-
Statistical Computing masterclass in Excel Final assessment
Student Ratings & Reviews
I would like to thank you for your well-prepared lessons and practical sessions. I have greatly benefited from the Banadir and Laambad team. Thank you once again for your commitment and hard work toward the future prosperity of Somali youth.
Guul iyo Gobonimo, Inshallah.
About the instructors
Offered by
BRCE waa xarun ka shaqaysa horu marinta iyo barashada arimaha la xariira xirfadaha Casriga ah oo ku salaysan Technology-ga.
Laambad Waxaan ammaanayaa madasha Laambad oo aan ka helay aqoon tayo leh iyo faa'iidooyin badan.
Guusha Dadaalkii iyo hagistii aan helay waxay fure u noqdeen horumarkayga aqooneed iyo yoolkayga maanta.