Summarizing Data Using Google Sheets (Coursera)

Summarizing Data Using Google Sheets (Coursera)

This project gives you easy access to the invaluable summarizing data techniques used by experts in business, science, math, sports, art, music, literature, and many other disciplines. We’ll learn how to summarize vast amounts of data into a few numbers, charts, and graphs to gain the invaluable insights hidden in them. We’ll also cover the most commonly used methods in the business setting while focusing on how to develop them and when one is more appropriate than others. We will use Google Sheets and large data sets to illustrate how to create the summary techniques.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

Using these techniques, no matter what your skill levels in the topic, you can change your way of solving problems using data and approaching them. If you’re already an expert, this peep under the methods in data science will give you ideas for turbocharging successful learning, including tips and insights that will help you make the best use of data for your decision-making. If you’re struggling, you’ll see a structured treasure trove of practical techniques that walk you through what you need to do to get on track. If you’ve ever wanted to become better at summarizing data, this project will help serve as your guide.

In this Guided Project, you will:

  • Use Google Sheets to construct frequency tables, bar charts, histograms, scatter plots, pie charts to analyze your data.

Learn step-by-step
Task 1: Frequency tables in Google sheets – Quantitative Data
Task 2: Frequency tables in Google Sheets – Qualitative Data
Task 3: Presenting Frequency Tables as a Bar Graph in Google Sheets
Task 4: Histograms in Google Sheets
Task 5: Pie Charts in Google Sheets
Task 6: Scatter plots in Google Sheets

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Investigating Epidemics like COVID-19: An Analyst's Guide (Coursera) Coursera
Johns Hopkins University

Investigating Epidemics like COVID-19: An Analyst's Guide (Coursera)

Do you want to learn how to detect, identify the cause, and decrease the morbidity and mortality from outbreaks or pandemics like COVID-19? Are you considering a career in public health practice, but aren’t sure how health departments collect and use outbreak data? Are you working in public health, but interested in moving into analytical and/or technical roles or curious how health departments investigate outbreaks? If so, this course is for you.

Nov 2nd 2026
4 Weeks
Necessary Condition Analysis (NCA) (Coursera) Coursera
Erasmus University Rotterdam

Necessary Condition Analysis (NCA) (Coursera)

Welcome to Necessary Condition Analysis (NCA). NCA analyzes data using necessity logic. A necessary condition implies that if the condition is not in place, there will be guaranteed failure of the outcome. The opposite however is not true; if the condition is in place, success of the outcome is not guaranteed.

Oct 26th 2026
5-12 Weeks
Data science perspectives on pandemic management (Coursera) Coursera
Politecnico di Milano

Data science perspectives on pandemic management (Coursera)

The COVID-19 pandemic is one of the first world-wide scenarios where data made a difference in capturing and analyzing the diffusion and impact of the disease. We offer an introductory course for decision makers, policy makers, public bodies, NGOs, and private organizations about methods, tools, and experiences on the use of data for managing current and future pandemic scenarios.

Nov 2nd 2026
5-12 Weeks
Visualización de Datos con Python (Coursera) Coursera
IBM

Visualización de Datos con Python (Coursera)

"Una imagen vale mas que mil palabras". Todos estamos familiarizados con esta expresión. Se aplica especialmente cuando se trata de explicar la información obtenida del análisis de conjuntos de datos cada vez más grandes. La visualización de datos juega un papel esencial en la representación de datos tanto a pequeña como a gran escala. Una de las habilidades clave de un científico de datos es la capacidad de contar una historia convincente, visualizando datos y hallazgos de una manera accesible y estimulante

Oct 26th 2026
3 Weeks
Bioinformatic Methods II (Coursera) Coursera
University of Toronto

Bioinformatic Methods II (Coursera)

Large-scale biology projects such as the sequencing of the human genome and gene expression surveys using RNA-seq, microarrays and other technologies have created a wealth of data for biologists. However, the challenge facing scientists is analyzing and even accessing these data to extract useful information pertaining to the system being studied. This course focuses on employing existing bioinformatic resources – mainly web-based programs and databases – to access the wealth of data to answer questions relevant to the average biologist, and is highly hands-on.

Oct 26th 2026
5-12 Weeks
Construção de Relacionamentos em Vendas Orientada a Dados (Coursera) Coursera
FIA Business School

Construção de Relacionamentos em Vendas Orientada a Dados (Coursera)

Nossas boas-vindas ao Curso Construção de Relacionamento em Vendas Orientada a Dados. Neste curso, você aprenderá métodos sobre data analytics para o ambiente dos profissionais de vendas. Ao final deste curso, você será capaz de avaliar relacionamentos entre o desempenho de vendas e os gastos relacionados; agrupar por semelhança itens, produtos ou serviços e, por fim, realizar recomendações de produtos para clientes sob características preestabelecidas.

Oct 26th 2026
4 Weeks
Analyzing and Visualizing Data in Looker (Coursera) Coursera
Google Cloud

Analyzing and Visualizing Data in Looker (Coursera)

In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Upon completion of this course, you will be able to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance, ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision making.

Oct 26th 2026
2 Weeks
Business Intelligence and Competitive Analysis (Coursera) Coursera
Rutgers University

Business Intelligence and Competitive Analysis (Coursera)

By the end of 2019, it is clear that American Airlines (AAL), the world’s largest airline group, is in trouble. With the growth rate of its stock price ranked at the bottom of all major US airlines and going in the opposite direction from the SP500 index, AAL needs to find out what is going on, and how to turn the company and its stock price around.

Oct 26th 2026
4 Weeks
Introduction to Statistics (Coursera) Coursera
Stanford University

Introduction to Statistics (Coursera)

Stanford's "Introduction to Statistics" teaches you statistical thinking concepts that are essential for learning from data and communicating insights. By the end of the course, you will be able to perform exploratory data analysis, understand key principles of sampling, and select appropriate tests of significance for multiple contexts. You will gain the foundational skills that prepare you to pursue more advanced topics in statistical thinking and machine learning.

Nov 2nd 2026
5-12 Weeks
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Nov 2nd 2026
5-12 Weeks
3D Data Visualization for Science Communication (Coursera) Coursera
University of Illinois at Urbana-Champaign

3D Data Visualization for Science Communication (Coursera)

This course is an introduction to 3D scientific data visualization, with an emphasis on science communication and cinematic design for appealing to broad audiences. You will develop visualization literacy, through being able to interpret/analyze (read) visualizations and create (write) your own visualizations.

Nov 2nd 2026
4 Weeks