Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course is designed for students and businesses who want to learn how to summarize data and communicate the results effectively.
In this course, I will take you through the tabular and graphical methods that one can use to turn data into information using Microsoft Excel.
There are no prerequisites required to take this course as I will start all the concepts from scratch.
How is this course structured?
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Introduction to the course and the instructorPreview
|Section 2: Data - Types and Collection|
Data and Information
Types of data - Qualitative and QuantitativePreview
How to collect data?Preview
|Section 3: How to make sense of Qualitative Data?|
Relative Frequency and Percent Frequency DistributionsPreview
How to construct Frequency Distribution using MS Excel
Using Bar Graphs to present the dataPreview
How to construct Bar Graph for Qualitative Data using MS Excel
|Section 4: Summarizing Quantitative Data using tabular and graphical methods|
Discrete Frequency Distribution
Basic Principles for forming a Grouped Frequency Distribution
Ungrouped Frequency Distribution for Discrete Data using MS Excel
Grouped Frequency Distribution for Discrete Data using MS Excel
Continuous Frequency Distribution
Relative Frequency and Percent Frequency Distributions
Simple Bar Graph and Multiple Bar Graph using MS Excel
Histogram - Case when you have inclusive classes
Grouped Frequency Distribution for Continuous Data and Histogram using MS Excel
Cumulative Frequency and Cumulative Percent Frequency Distributions
Pie charts - How good are they?
Get your audience's attention : Make the most of graphs and charts
|Section 5: Applications|
Application - 1
Application - 2 (Unsolved)
|Section 6: Measures of Central Tendency|
Introduction to Central Tendency
Sample and Population
Why is 'Mean' so popular as a measure
How to calculate mean : Ungrouped Frequency Distribution Case
How to calculate mean : Grouped Data Case
Mean and Weighted Mean using MS Excel
Mean, Median, Mode - Which is best?
Median and Mode using MS Excel
M.A. Economics, Business Analyst, Certified Financial Planner (CFP)
Shubham Kalra has a Masters in Economics from Delhi School of Economics and has worked as a Business Analyst in one of the largest banking and financial services organizations in the world.
He has done research projects in Education and Infrastructure Sector in India involving field work and analysis of data. He holds a diploma in Financial Planning and has good understanding of Risk Management concepts and Financial Instruments as well.
He loves teaching and has been teaching since his college days in one way or another. It was in 2015, when he started teaching full time and is now teaching Economics and Statistics to many students online.His areas of specialization include Economics, Statistics, Finance and Game theory.