Blog
Library

Learn Data Analysis using Microsoft Excel Basics Fast

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

  • Categories

    Productive Expertise & Efficiency

  • Duration

    00:41:11

  • 0 Students Enrolled

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

What will you learn
  • Microsoft Excel and Data Analysis
Course Curriculum
Number of Lectures: 28 Total Duration: 00:41:11
Reviews

No Review Yet