Learn Business Data Analysis with Excel in under 5Hrs.

Learn how to get more Insight out of your Business Data using simple yet powerful tool of Microsoft Excel.
4.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
631 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 47
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course Description

  • Essential Data Analytics with Excel online Tutorial course provides basic as well as advance skills & knowledge required to become a Data Analyst. This course provides you a better vision of Excel in order to train you excellently. Participants, at the end of the training, will be technically competent in essential concepts of Analysis such as Descriptive Statistics, Forecasting and Visualizing Data, Hypothesis Testing, Probability Distribution, Covariance, Correlations and Bayesian Analysis.
  • This course provides an overview of the fundamentals, from common calculations means from very basic to implementation of Bayesian analysis that is also the part of Data Analysis in Excel.
  • This course contains lectures as videos, additional Exercise files are attached with third video "How to use Exercise Files" for your self practice and complementary book on Excel has attached with last Lecture of the course in order to provide you more help.
  • Excel in this course is convenient for all those individuals who don't want to learn hard core programming in order to get insights from the data for day to day basis. So it is useful for those who want to begin Data Analysis quickly and want to become Data Analyst.

What are the requirements?

  • How to open and close Excel Tool
  • should know what is the objective of Excel
  • It will be an advantage if you know how to work with formulas in Excel. But if you are not familiar with formulas, don’t worry…you’ll learn how to use them, in this course.
  • if you are familiar with the charts in Excel you will get the concepts quickly.

What am I going to get from this course?

  • 1. Understand the fundamentals of Data Organization in Excel
  • 2. Enhance skills by applying them to the Data Analysis
  • 3. Get familiar to Data Analytics as career option with practical knowledge on some of the techniques that are currently in demand, such as Forecasting, Data Visualizations, Hypothesis Testing, correlations, Bayesian Analysis, etc.
  • 4. Work with data and perform EDA
  • 5. Get aware of the job trends and scopes ahead in market after being trained in Essential Data Analytics with Excel.
  • 6. Develop constructive approach to solve business queries with Excel
  • 7. Analyze real time data and perform learnt skills

What is the target audience?

  • This course is applicable for everybody who wants to dive deep in playing with numbers, graphical visualization and understanding Data

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction to Course
Preview
10:14
What you should know?
Preview
02:09
How to use Exercise Files?
Preview
02:29
Section 2: Data Analysis using Descriptive Statistics
Introduction to Module
01:36
Calculating Mean and Median Values
09:42
Min, max and quartiles
08:44
Variance and Standard deviation
10:32
Introduction to central limit theorem
Preview
02:12
Sample and Population Data
10:03
Identifying sources of error
05:26
Section 3: Forecasting and Visualizing Data
Introduction to Module
01:35
Understanding the Histograms
07:28
XY scattercharts
05:21
Understanding the Logarithmic Scales
08:00
Adding Trend Lines
Preview
04:56
Forecasting Future Results
13:01
Calculating Running Averages
08:22
Section 4: Testing a Hypothesis
Introduction to module
00:47
Formulating a Hypothesis
06:06
Interpreting the results of hypothesis
03:06
Considering the limits of Hypothesis
03:29
Section 5: Utilizing Probability Distributions
Introduction to Module
01:11
Normal Distribution
09:02
Exponential Distribution
08:10
Uniform Distribution
08:44
Binomial Distribution
08:40
Poisson Distribution
08:35
Section 6: Working with Covariance and Correlations
Introduction to Module
01:04
Introduction to Covariance
Preview
06:33
Covariance for two columns of Data
08:33
Covariance for multiple columns of Data
08:32
Introduction to Correlation
09:33
Correlation for two columns of data
04:14
Correlation for multiple columns of Data
06:39
Section 7: Working with Bayesian Analysis
Introduction to Module
01:07
Case Study for Bayesian Analysis
Preview
04:41
Analyzing a Sample Problem
07:34
Creating a Classification Matrix
07:06
Working with Bayesian Analysis in Excel
09:42
Updating Baseyian Analysis
06:44
Section 8: Further Resources
Further Resources
02:05
Section 9: Assignments and Quiz
Section 2 Assignments
Article
Section 3 Assignments
Article
Section 4 Assignments
Article
Section 5 Assignments
Article
Section 6 Assignments
Article
Section 7 Assignments
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Easylearning guru, Your Pace!! Your Place!!

Easylearning guru is a leading provider of professional certification courses. We offers training from best experts in the industry to meet the unique learning needs. We are the pioneer's in online education and training, and aims to offer our professionals flexible & an integrated model of training to meet their needs & requirements.

Ready to start learning?
Take This Course