Learn Data Analysis using Microsoft Excel Basics Fast

Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$200

Course Overview

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

Who should take this course

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

Accreditation

Course Completion Certificate

Course content

What will you learn:

  • Microsoft Excel and Data Analysis

About Course Provider

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.

Frequently asked questions

{{ item.question }}