Course Introduction (15 hrs.)
This course will teach you a basic understanding of Excel so that you may use it for more complex issues in business statistics. It is an introduction to the usage of Excel. The course is developed with two types of learners in mind: individuals with limited functional understanding of Excel and those who use Excel on a regular but peripheral basis and want to improve their abilities. The course progresses from fundamental processes such as reading data into Excel using multiple data formats and organizing and manipulating data to more advanced Excel capability. Throughout, Excel functionality is explained using simple examples that are demonstrated in such a way that learners may grow comfortable understanding and using them.
Program Added Value
After completing this program, audiences will be able to:
- Learn Descriptive Statistics and Probability
- Understand Random Variables, Skewness, and Histograms
- Point Estimation and Finite Correction Factor
- Sample Intervals Fundamentals & Essentials and Confidence .
- Binomial and Poisson Rule Core Ideas
- Variance, Random Variable Standard Deviation, and Mean
- Total Probability Law and Bayes Rule
- Testing and Hypothesis Evaluation
After completing this program, audiences will be able pass the following exams:
- Exam MO-200: Microsoft Excel (Office 2019)
Program Prerequisites
Before attending this course, audiences must have:
- Basic Algebra Knowledge
- Knowledge of Microsoft Excel Tables, Charts, and Formulas
- Data Summarization and Management Knowledge
- Knowledge of Excel Analytical Tools such as Pivot Tables and Charts.
Program Topics
Descriptive Statistics
Basic Probability
Random Variables
Sampling and Confidence Intervals
Hypothesis Testing
Attendees Required Resources
Personal Laptop with at least Windows 10 & Office 2016 is required to access course LAB.