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 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 FastContentGetting 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