This is a bite-size course to learn data analysis using Microsoft Excel in a short time. This course will use the CRISP-DM model and we will go through data understanding (data visualizations, statistics, and data analysis) and data preparation (remove missing values and remove duplicates) using Microsoft Excel.

Content

1. Getting Started
2. Download Dataset
3. Read CSV
4. Data Mining Process
5. Insert Lien Chart
6. Insert Bar Chart
7. Insert Pie Chart
8. Insert Scatterplot
9. Insert Combo Chart
10. Pivot Table
11. Insert Pivot Table and Pivot Chart
12. Data Analysis Plugins
13. Data Analysis Plugins 2
14. Descriptive Statistics
15. Histogram
16. Correlation
17. Covariance
18. TTest Two Samples Paired for Means
19. TTest Two Samples Equal Variances
20. TTest Two Samples Unequal Variances
21. F Test Two Samples for Variances
22. ANOVA Single Factor
23. ANOVA Two Factor Without Replication
24. Regression Analysis
25. Remove Duplicates
26. Remove Missing
27. Sort Data
28. Filter Data