Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Learn Business Data Analysis with Excel in under 5Hrs. to your Wishlist.

Add to Wishlist

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 (9 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.
641 students enrolled
Last updated 7/2015
English
$15 $20 25% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 6 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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.
Who is the target audience?
  • This course is applicable for everybody who wants to dive deep in playing with numbers, graphical visualization and understanding Data
Students Who Viewed This Course Also Viewed
What Will I Learn?
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
View Curriculum
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.
Curriculum For This Course
Expand All 47 Lectures Collapse All 47 Lectures 04:14:13
+
Data Analysis using Descriptive Statistics
7 Lectures 48:15
Introduction to Module
01:36

Calculating Mean and Median Values
09:42

Min, max and quartiles
08:44

Variance and Standard deviation
10:32


Sample and Population Data
10:03

Identifying sources of error
05:26
+
Forecasting and Visualizing Data
7 Lectures 48:43
Introduction to Module
01:35

Understanding the Histograms
07:28

XY scattercharts
05:21

Understanding the Logarithmic Scales
08:00


Forecasting Future Results
13:01

Calculating Running Averages
08:22
+
Testing a Hypothesis
4 Lectures 13:28
Introduction to module
00:47

Formulating a Hypothesis
06:06

Interpreting the results of hypothesis
03:06

Considering the limits of Hypothesis
03:29
+
Utilizing Probability Distributions
6 Lectures 44:22
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
+
Working with Covariance and Correlations
7 Lectures 45:08
Introduction to Module
01:04


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
+
Working with Bayesian Analysis
6 Lectures 36:54
Introduction to Module
01:07


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
+
Further Resources
1 Lecture 02:05
Further Resources
02:05
+
Assignments and Quiz
6 Lectures 00:25
Section 2 Assignments
00:02

Section 3 Assignments
00:04

Section 4 Assignments
00:04

Section 5 Assignments
00:04

Section 6 Assignments
00:04

Section 7 Assignments
00:04
About the Instructor
3.7 Average rating
193 Reviews
2,165 Students
12 Courses
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.

Report Abuse