Fundamentals of Data Analysis in Excel (Coursera)

Fundamentals of Data Analysis in Excel (Coursera)

Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis. In this course, you’ll apply Excel’s native tools to structure your data into spreadsheets and tables. You’ll then analyze and produce insights from that data using pivot tables. Finally, you’ll visualize those insights by building a dashboard in Excel. You’ll apply these skills using modern functionality like dynamic array formulas, linked data types, and Ideas in Excel. You’ll work hands-on with real-world scenarios, using datasets pulled from financial statements and retail sales.

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

By the end of the course, you'll be able to:

  • analyze a dataset using native Excel tools
  • apply Excel tools and formulas to transform and structure your data
  • create pivot tables to slice and dice your data
  • visualize data with pivot charts and Excel Charts
  • describe the landscape of data analysis and visualization

This course is part of the Data Skills for Excel Professionals Specialization.

Syllabus

Getting Started
Welcome to the Fundamentals of Data Analysis in Excel course.

Analyze Data
In this module, we will learn to analyze a dataset using native Excel tools.

Transform Data
In this module, we will learn to apply Excel tools and formulas to transform and structure our data.

Excel Tables
In this module, we will learn to apply Excel tools and formulas to transform and structure our data.

Dynamic Arrays

Pivot Tables
In this module, we will learn to explore the landscape of data analysis and visualization and create pivot tables to slice and dice your data.

Visualize Data
In this module, we will learn to visualize data with pivot and Excel charts.

Course Conclusion

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

Related Courses

Competencias digitales. Herramientas de ofimática (Microsoft Word, Excel, Power Point) (Coursera) Coursera
Universitat Autònoma de Barcelona

Competencias digitales. Herramientas de ofimática (Microsoft Word, Excel, Power Point) (Coursera)

Los continuos cambios tecnológicos, sobre todo en aquellos aspectos vinculados a las tecnologías de la información y la comunicación (TIC) hacen que las personas tengan la necesidad de actualizarse de forma continua para que sus conocimientos no queden obsoletos. En este contexto, para las empresas se convierte en algo imprescindible disponer de profesionales que tengan las competencias necesarias para ejercer con éxito las actividades que requieren en su lugar de trabajo.

Sep 28th 2026
5-12 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.

Sep 28th 2026
5-12 Weeks
Data Analytics for Lean Six Sigma (Coursera) Coursera
University of Amsterdam

Data Analytics for Lean Six Sigma (Coursera)

Welcome to this course on Data Analytics for Lean Six Sigma. In this course you will learn data analytics techniques that are typically useful within Lean Six Sigma improvement projects. At the end of this course you are able to analyse and interpret data gathered within such a project. You will be able to use Minitab to analyse the data. I will also briefly explain what Lean Six Sigma is.

Sep 28th 2026
5-12 Weeks
Big Data Analysis Deep Dive (Coursera) Coursera
Alibaba Cloud Academy

Big Data Analysis Deep Dive (Coursera)

The job market for architects, engineers, and analytics professionals with Big Data expertise continues to increase. The Academy’s Big Data Career path focuses on the fundamental tools and techniques needed to pursue a career in Big Data. This course includes: data processing with python, writing and reading SQL queries, transmitting data with MaxCompute, analyzing data with Quick BI, using Hive, Hadoop, and spark on E-MapReduce, and how to visualize data with data dashboards. Work through our course material, learn different aspects of the Big Data field, and get certified as a Big Data Professional!

Sep 28th 2026
5-12 Weeks
Introduction to Computers and Office Productivity Software (Coursera) Coursera
The Hong Kong University of Science and Technology - HKUST

Introduction to Computers and Office Productivity Software (Coursera)

In this course, you will learn the following essential computer skills for the digital age: major hardware components of a computer system; different types of software on a computer system; photo Editing using GIMP; and word processing applications, including MS Word, MS Excel, and MS PowerPoint.

Sep 28th 2026
5-12 Weeks
Global Statistics - Composite Indices for International Comparisons (Coursera) Coursera
University of Geneva

Global Statistics - Composite Indices for International Comparisons (Coursera)

In this course on global statistics, offered by the University of Geneva jointly with the ETH Zürich KOF, you will learn the general approach of constructing composite indices and some of resulting problems. We will discuss the technical properties, the internal structure (like aggregation, weighting, stability of time series), the primary data used and the variable selection methods. These concepts will be illustrated using a sample of the most popular composite indices. We will try to address not only statistical questions but also focus on the distinction between policy-, media- and paradigm-driven indicators.

Sep 28th 2026
5-12 Weeks
Habilidades de Excel para negócios: Fundamentos (Coursera) Coursera
Macquarie University

Habilidades de Excel para negócios: Fundamentos (Coursera)

Neste primeiro curso da especialização Habilidades de Excel para negócios, você aprenderá os fundamentos do Microsoft Excel. Dentro de seis semanas, você poderá navegar habilmente pela interface de usuário do Excel, realizar cálculos básicos com fórmulas e funções, formatar planilhas profissionalmente e criar visualizações de dados por meio de gráficos e tabelas.

Oct 5th 2026
5-12 Weeks
Population Health: Predictive Analytics (Coursera) Coursera
Leiden University

Population Health: Predictive Analytics (Coursera)

Predictive analytics has a longstanding tradition in medicine. Developing better prediction models is a critical step in the pursuit of improved health care: we need these tools to guide our decision-making on preventive measures, and individualized treatments. In order to effectively use and develop these models, we must understand them better. In this course, you will learn how to make accurate prediction tools, and how to assess their validity. First, we will discuss the role of predictive analytics for prevention, diagnosis, and effectiveness. Then, we look at key concepts such as study design, sample size and overfitting.

Sep 28th 2026
4 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.

Oct 5th 2026
5-12 Weeks
Population Health: Responsible Data Analysis (Coursera) Coursera
Leiden University

Population Health: Responsible Data Analysis (Coursera)

In most areas of health, data is being used to make important decisions. As a health population manager, you will have the opportunity to use data to answer interesting questions. In this course, we will discuss data analysis from a responsible perspective, which will help you to extract useful information from data and enlarge your knowledge about specific aspects of interest of the population.

Oct 5th 2026
4 Weeks
Data Visualization with Tableau Project (Coursera) Coursera
University of California, Davis

Data Visualization with Tableau Project (Coursera)

In this project-based course, you will follow your own interests to create a portfolio worthy single-frame viz or multi-frame data story that will be shared on Tableau Public. You will use all the skills taught in this Specialization to complete this project step-by-step, with guidance from your instructors along the way.

Oct 5th 2026
5-12 Weeks
Practical Time Series Analysis (Coursera) Coursera
The State University of New York

Practical Time Series Analysis (Coursera)

Many of us are "accidental" data analysts. We trained in the sciences, business, or engineering and then found ourselves confronted with data for which we have no formal analytic training. This course is designed for people with some technical competencies who would like more than a "cookbook" approach, but who still need to concentrate on the routine sorts of presentation and analysis that deepen the understanding of our professional topics.

Oct 5th 2026
5-12 Weeks