Study Learn Grow
Learn Data Analysis Using Microsoft Excel Basics Fast

Learn Data Analysis Using Microsoft Excel Basics Fast


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".

Overview

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 Analysis) and Data Preparation (Remove Missing values, remove duplicates) using Microsoft 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 Analysis using Microsoft Excel Basics Fast
Content

Getting Started
Download Data set
Read CSV
Data Mining Process
Insert Lien Chart
Insert Bar Chart
Insert Pie Chart
Insert Scatter plot
Insert Combo Chart
Pivot Table
Insert Pivot Table and Pivot Chart
Data Analysis Plugins
Data Analysis Plugins 2
Descriptive Statistics
Histogram
Correlation
Co-variance
T Test Two Samples Paired for means
T Test Two Samples Equal Variances
T Test Two Samples Unequal Variances
F Test Two Samples for Variances
ANOVA Single Factor
ANOVA Two Factor Without Replication
Regression Analysis
Remove Duplicates
Remove Missing
Sort Data
Filter Data
Basic knowledge
Basic Computer Knowledge

Course Information

Basic Computer Knowledge

What will you learn
Microsoft Excel and Data Analysis

Beginner Computer Passion People a nd analysts who want to learn Microsoft Excel and Data Analysis

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs