Learn Data Analysis using Microsoft Excel Basics Fast
1.4 (6 ratings)
611 students enrolled

# Learn Data Analysis using Microsoft Excel Basics Fast

Learn Data Analysis using Microsoft Excel
1.4 (6 ratings)
611 students enrolled
Created by SVBook Pte. Ltd.
Published 3/2019
English
Current price: \$139.99 Original price: \$199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
• 41 mins on-demand video
• Full lifetime access
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
• Microsoft Excel and Data ANalysis
Requirements
• Basic COmputer Knowledge
Description

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

Who this course is for:
• Beginner Computer Passion People a nd analysts who want to learn Microsoft Excel and Data Analysis
Course content
Expand 28 lectures 40:56
+ Course
28 lectures 40:56
Preview 00:49
Preview 01:11
Preview 00:48
Preview 05:37
Preview 02:54
INsert Bar Chart
01:33
INsert Pie CHart
01:36
INsert Scatterplot
01:10
Insert Combo Chart
01:07
Pivot Table
03:47
INsert Pivot Table and Pivot CHarts
01:23
Data ANalysis Plugins
00:47
Data Analysis PLugin 2
00:50
Descriptive Statistics
01:17
HIstogram
01:22
Correlation
01:20
Covariance
00:53
TTest Two Samples Paired for Means
01:31
TTest Two Samples Equal Variances
01:13
TTest Two Samples Unequal Variances
01:12
F Test Two Samples for Variances
01:05
ANOVA SIngle Factor
01:09
ANOVA Two Factor without Replication
01:15
Regression Analysis
02:03
Remove Duplicates
00:47
Remove Missing Values
01:10
Sort Data
00:38
Filer Data
00:29