Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice realworld skills and achieve your goals.
Teaching 11 Courses on Excel and Data Analysis!
OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!
OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!
Last updated: Nov 01, 2016 with 6 Case Studies, and 46 Problems with Solutions.
**************************************************************************************
What students are saying about this course?
~ Very clear, concise explanation of basic and more advanced statistical Excel functions  Donna M Knapp
~ This is an excellent well taught course. The explanations are clear and concise. The course moves along a comfortable pace. I learned a lot from this course and shouldn't have any difficulty applying the concepts to future projects. Well done.  Bill Hengen
**************************************************************************************
Welcome to my brand new course on Data Analysis in Excel with Statistics: Get Meanings of Data.
I want to start with a quote from Daniel Egger. He is a professor at Duke University.
He says: “No commercial forprofit company that is in a competitive market can remain profitable or even survive over the next five years without incorporating best practices for business data analytics into their operations.”
So learning how to analyze data will be the most valuable expertise in your career in next five years.
Excel will analyze and visualize data easily – this is why Excel is created and this is why Excel is the most popular spreadsheet program in the world.
Microsoft Company has added new data analysis features, functions, and tools in every new version of Excel.
Before going into the course: I want to warn you about something. Excel is a just a tool. To analyze data you will use this tool. But analyzing data requires that you know some basic statistics and probability theories.
Most of the statistics and probability concepts that are necessary to analyze data effectively are covered in your undergraduate level courses. But in this course, at first I have discussed the theory at first, then I have advanced to teach you how to use that theory in business with the help of Excel.
Let’s discuss now what I will cover in this course. It is tough to build a course on data analysis using Excel as so many topics are there to be covered. So I have used the guidelines of Project Management Institute (PMI) to create this course.
The topics I am going to cover in this course are:
Analyzing Business data is a must need expertise for every employee of a company. Your company will not survive another five years if it does not take seriously business data. And you could be the best employee in your company to direct the business in the smartest way. So keep learning business data analysis 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.
Section 1: Welcome to the Course!  

Lecture 1  03:20  


Lecture 2  00:24  
Get an idea on what you should know before joining this course. You can call them the prerequisites of this course. 

Lecture 3  00:13  
Download the course resources from this lecture. 

Lecture 4  00:33  
Get to know how to instantly contact me when you face an Excel, Statistics or course related problems. 

Section 2: [Essential Excel Knowledge 1]  Excel Formula Basics & Important Excel Functions  
Lecture 5  10:28  
In this video lecture,


Lecture 6  09:31  
The operators have working hierarchy. All the operators in a formula do not work at the same time. In this lecture,


Lecture 7  07:17  
In this video lecture,


Lecture 8  09:40  
Excel is nothing but a word processor if you deduct Excel's capability to use functions. Functions are the hearts of Excel. In this video, you will learn how to insert Excel functions into a formula. You will also learn how to use effectively Insert Function dialog box. 

Lecture 9  05:23  
In this video lecture,


Lecture 10  03:23  
In this video lecture,


Lecture 11  07:48  
In this video lecture,


Lecture 12  08:01  
In this video lecture,


Lecture 13  05:28  
In this video lecture,


Lecture 14  07:51  
In this video lecture,


Lecture 15  06:54  
In this video lecture,


Lecture 16  07:09  
In this video lecture,


Lecture 17  03:17  
In this video lecture,


Lecture 18  07:06  
In this video lecture,


Lecture 19  07:35  
In this video lecture:


Lecture 20  05:42  
In this video lecture:


Lecture 21  08:11  
In this video lecture,


Lecture 22  04:32  
VLOOKUP() is one of the top 10 Excel functions. In this video lecture: you will learn VLOOKUP() function with multiple examples. 

Section 3: [Essential Excel Knowledge 2]  Excel Tables & Using Structured References  
Lecture 23  06:42  
Topics covered in this lecture


Lecture 24  07:22  
Topics covered in this lecture


Lecture 25  06:12  
In this video lecture, you will learn basically two topics:


Lecture 26  10:44  


Lecture 27  04:16  


Lecture 28  12:44  
In this video lecture,


Lecture 29  08:31  
In this video lecture,


Section 4: Foundational Concepts of Statistical Data Analysis  
Lecture 30  07:10  
To calculate centrality of a data set, you need to find out the Mean, Median and Mode values from a data set. This lecture will teach you how to calculate them using Excel functions. 

Lecture 31  06:01  
Calculating maximum, minimum, and quartile values from a data set is easy using Excel. This lecture will teach you those topics. 

Lecture 32  10:35  
Variance and Standard deviation are the two most important ways to figure out the dispersion of a data set. You will learn here not only how to calculate them, but also you will visualize them. 

Lecture 33  03:30  
In this lecture, you will get the concept of Central Limit Theorem with a real life example. 

Lecture 34  08:34  
This lecture is very important. You will get a brief and effective method for analyzing a population using data samples. Get the concepts of this lecture very well. 

Lecture 35  03:22  
Statistics is not a pure science. When you will come up with a decision using the principles of statistics, you have to keep in mind that your analysis might be wrong in many ways. This lecture will teach you to identify and minimize the sources of error while you are working with statistical analysis. 

Section 5: Visualizing Data  
Lecture 36  05:20  
Creating histogram from a data set is one of the main focus when you're working with data distributions. In this lecture, you will build histogram using Excel's Data Analysis ToolPak. 

Lecture 37  02:36  
XY Charts show the trend between two data sets. Creating XY charts are not tough. This lecture will teach you XY chart in details. 

Lecture 38  05:36  
When you work with a data set having extreme large and small number and you make charts using that data set, reading that chart will be not so easy. Converting an Axis using Logarithmic Scale will make your chart readable and effective. This lecture will teach you how to do that. 

Lecture 39  02:43  
This lecture will teach you how to add trend lines to a chart. Even if you want to forecast values from existing values, you can do that using trend line. This is the topic of this lecture. 

Lecture 40  07:09  
Forecasting future results can be performed in two ways: using Excel's AutoFill Handle Tool and FORECAST() function. Both of these ways are discussed in this lecture. 

Lecture 41  06:03  
The calculating of running average is simple. This lecture will teach you how to calculate running average and 3day running average. 

Section 6: Testing a Hypothesis  
Lecture 42  07:23  
Formulating hypothesis based on a data is set is not tough, but you have to be very careful to do that. This lecture will teach you to do that. 

Lecture 43  05:23  
This lecture will teach you how to interpret the results of your hypothesis. 

Lecture 44  03:08  
In this video lecture, you will learn about the limits of testing a hypothesis. 

Section 7: Utilizing Data Distributions  
Lecture 45  07:57  
Normal distribution or Bell Curve or Gaussian Curve is one of the most important topics in Statistics. This lecture will cover the topic in great details. 

Lecture 46  07:22  
In this lecture, you will learn how to calculate exponential distribution in Excel. 

Lecture 47  06:56  
This lecture will teach you how to calculate binomial distribution. You will also learn how to use it with a proper example. 

Section 8: Measuring Covariance and Correlation  
Lecture 48  04:54  
This lecture will teach you how to visualize Covariance with an example. 

Lecture 49  05:37  
Learn how to calculate covariance between two columns of data pairs. 

Lecture 50 
0803  Calculating Covariance among Multiple Pairs of Columns

04:14  
Lecture 51 
0804  Visualizing What Correlation Means

09:11  
Lecture 52  03:50  
This lecture will teach you how to calculate correlation between two columns of data pairs. 

Section 9: Case Study: Summarizing Data by Using Histograms  
Lecture 53 
0901  Overview of the section

00:14  
Lecture 54 
0902  Stock Return Analysis Using Histograms

04:53  
Lecture 55 
0903  Common Shapes of Histograms

02:58  
Lecture 56 
6 More Problems and Solutions
Preview

01:05  
Section 10: Case Study: Summarizing Data by Using Descriptive Statistics  
Lecture 57 
1001  Overview of the section

00:46  
Lecture 58 
1002  How to Get Descriptive Statistics Using Excel's Data Analysis ToolPak

02:56  
Lecture 59 
1003  What defines a typical value (or centrality) for a data set?

06:16  
Lecture 60 
1004  How can I measure how much a data set spreads from its typical value?

03:26  
Lecture 61 
1005  What do the mean and standard deviation of a data set tell me about?

05:19  
Lecture 62 
1006  How can I use descriptive statistics to compare data sets?

02:57  
Lecture 63 
1007  How to easily find the second largest or second smallest number in a data

01:32  
Lecture 64 
1008  How can I rank numbers in a data set?

07:44  
Lecture 65 
1009  What is the trimmed mean of a data set?

03:28  
Lecture 66 
1010  Alternative of Data Analysis ToolPak

01:53  
Lecture 67 
1011  Why financial analysts use Geometric mean instead of arithmetic average?

04:39  
Lecture 68 
16 Problems and Solutions

03:10  
Section 11: Case Study: Estimating Straightline Relationships  
Lecture 69 
1101  Overview of the section

00:22  
Lecture 70 
1102  A brief introduction to dependent and independent variable

03:21  
Lecture 71 
1103  The relationship between monthly production & operating costs

08:52  
Lecture 72 
1104  Meaning and significance of Rsquare value

01:31  
Lecture 73 
1105  Standard error of regression to measure the accuracy of a relationship

03:30  
Lecture 74 
1106  Find intercept, slope and Rsquare values using Excel's functions

01:30  
Lecture 75 
12 Problems and Solutions
Preview

02:08  
Section 12: Case Study: Modeling Exponential Growth  
Lecture 76 
1201  Overview of the section

00:07  
Lecture 77 
1202  How can I model the growth of a company’s revenue over time?

09:32  
Lecture 78 
6 Problems and Solutions

00:45  
Section 13: Case Study: Using Correlations to Summarize Relationships  
Lecture 79 
1301  Overview of the section

00:08  
Lecture 80 
1302  Measuring correlation using Excel's Data Analysis ToolPak

03:22  
Lecture 81 
1303  Filling the matrix

02:18  
Lecture 82 
1304  Relation between correlation and Rsquare value

01:34  
Lecture 83 
5 Problems and Solutions

01:13  
Section 14: Case Study: Using Moving Averages to Understand Time Series  
Lecture 84 
1401  Overview of the section

00:15  
Lecture 85 
1402  How to apply the Moving Average based trend line to show a trend

04:20  
Lecture 86 
1 Problem and Solution

00:20 
Love to see you here!
I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a fulltime data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.
I love to make courses in the combination of both theory and practice.
Monthly 30,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).
I love to learn and teach (teaching from my eighteen)!
Visit my blog!
You will find plenty of useful posts, articles, video tutorials, and important Excel resources.
What I love most is: add some value to people around me, believe me!
Here are some of my working areas:
I am always around you to help and support!
Just knock me!