Learn Data Analysis using Microsoft Excel Basics Fast
1.4 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
611 students enrolled

Learn Data Analysis using Microsoft Excel Basics Fast

Learn Data Analysis using Microsoft Excel
1.4 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
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
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