Learn Data Analysis using Microsoft Excel Basics Fast

This is the bite size course to learn Data Analysis using Microsoft Excel fasts. This course will use CRISP DM MOdel, and we will go through Data Understanding (Data Visualizations, Statistics, Data ANlaysis) and Data Preparation (Remove Mssing values, remove duplicates) using Mcirosoft Excel.  

You will need to know some COmputer knowledge before learning this course and you need to know Microsoft Excel before learning also. You can learn Microsoft Excel at my course "Learn Microsoft Excel Basics Fast". 

You can take the course as follow and you can take an exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office and Data Analysis with Excel:

- Learn Microsoft Word Basics Fast

- Learn Microsoft Powerpoint Basics Fast

- Learn Microsoft Excel Basics Fast

- Learn Data Aalysis using Microsoft Excel Basics Fast.

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