Learning Excel: Data Analysis
This course is designed for individuals seeking to harness the power of Microsoft Excel for data analysis and decisionmaking. Participants will delve into essential Excel functions, tools, and techniques to manipulate, visualize, and analyze data effectively. From basic data cleaning to advanced statistical analysis, this course provides a comprehensive guide to unlocking the full potential of Excel for datadriven insights.
Module 1. Foundational Concepts of Data Analysis

1Calculate mean and median values
Calculate mean and median values

2Analyze data using variance and standard deviation
Analyze data using variance and standard deviation

3Introducing the central limit theorem
Introducing the central limit theorem

4Analyze a population using data samples
Analyze a population using data samples

5Identify and minimize sources of error
Identify and minimize sources of error
Module 2. Visualize Data

6Group data using histograms
Group data using histograms

7Identify relationships using XY scatter charts
Identify relationships using XY scatter charts

8Visualize data using logarithmic scales
Visualize data using logarithmic scales

9Add trendlines to charts
Add trendlines to charts

10Forecast future results
Forecast future results

11Calculate running averages
Calculate running averages
Module 3. Test a Hypothesis
Module 4. Utilize Data Distributions

15Use the normal distribution
Use the normal distribution

16Use the exponential distribution
Use the exponential distribution

17Use a uniform distribution
Use a uniform distribution

18Use the binomial distribution
Use the binomial distribution

19Use the poisson distribution
Use the binomial distribution
Module 5. Measure Covariance and Correlation

20Visualize what covariance means
Visualize what covariance means

21Calculate covariance between two columns of data
Calculate covariance between two columns of data

22Calculate covariance among multiple pairs of columns
Calculate covariance among multiple pairs of columns

23Visualize what correlation means
Visualize what correlation means

24Calculate correlation between two columns of data
Calculate correlation between two columns of data

25Calculate correlation among multiple pairs of columns
Calculate correlation among multiple pairs of columns
Module 6. Perform Bayesian Analysis

26Introduce Bayesian analysis
Introduce Bayesian analysis

27Analyze a sample problem: Kahnemanâ€™s Cabs
Analyze a sample problem: Kahneman’s Cabs

28Create a classification matrix
Create a classification matrix

29Calculate Bayesian probabilities in Excel
Calculate Bayesian probabilities in Excel

30Update your Bayesian analysis
Update your Bayesian analysis