Coursera

Fundamentals of Data Analysis in Excel (Coursera)

Offered by Corporate Finance Institute,
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

Advanced Reproducibility in Cancer Informatics (Coursera) Coursera
Johns Hopkins University

Advanced Reproducibility in Cancer Informatics (Coursera)

Statistics & Data Analysis Data Science

This course introduces tools that help enhance reproducibility and replicability in the context of cancer informatics. It uses hands-on exercises to demonstrate in practical terms how to get acquainted with these tools but is by no means meant to be a comprehensive dive into these tools. The course introduces tools and their concepts such as git and GitHub, code review, Docker, and GitHub actions.

Aug 17th 2026
5-12 Weeks
Github Data Analysis R Language
Details
Research Design: Inquiry and Discovery (Coursera) Coursera
University of North Texas

Research Design: Inquiry and Discovery (Coursera)

Personal and Professional Development

The main purpose of this course is to focus on good questions and how to answer them. This is essential to making considered decisions as a leader in any organization or in your life overall. Topics will include the basis of human curiosity, development of questions, connections between questions and approaches to information gathering design, variable measurement, sampling, the differences between experimental and non-experimental designs, data analysis, reporting and the ethics of inquiry projects.

Aug 17th 2026
4 Weeks
Data Analysis Research Research Design
Details
Big Data Analysis with Scala and Spark (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Big Data Analysis with Scala and Spark (Coursera)

CS: Theory CS: Programming

Manipulating big data distributed over a cluster using functional concepts is rampant in industry, and is arguably one of the first widespread industrial uses of functional ideas. This is evidenced by the popularity of MapReduce and Hadoop, and most recently Apache Spark, a fast, in-memory distributed collections framework written in Scala. In this course, we'll see how the data parallel paradigm can be extended to the distributed case, using Spark throughout.

Aug 17th 2026
4 Weeks
Programming Algorithms SQL
Details
Principles of fMRI 1 (Coursera) Coursera
Johns Hopkins University

Principles of fMRI 1 (Coursera)

Statistics & Data Analysis

Functional Magnetic Resonance Imaging (fMRI) is the most widely used technique for investigating the living, functioning human brain as people perform tasks and experience mental states. It is a convergence point for multidisciplinary work from many disciplines. Psychologists, statisticians, physicists, computer scientists, neuroscientists, medical researchers, behavioral scientists, engineers, public health researchers, biologists, and others are coming together to advance our understanding of the human mind and brain. This course covers the design, acquisition, and analysis of Functional Magnetic Resonance Imaging (fMRI) data, including psychological inference, MR Physics, K Space, experimental design, pre-processing of fMRI data, as well as Generalized Linear Models (GLM’s).

Aug 17th 2026
4 Weeks
Medicine Statistics Data Analysis
Details
Redes Ecológicas (Coursera) Coursera
Universidade de São Paulo, Brasil

Redes Ecológicas (Coursera)

Statistics & Data Analysis Data Science

Todos os seres vivos estão conectados entre si por interações ecológicas, formando a “colina emaranhada” de Darwin, metáfora inspirada pela “teia da vida” de Humboldt. Desemaranhar essa complexidade é uma tarefa desafiadora, mas factível, desde que você use ferramentas adequadas. A ciência de redes nos ajuda com excelentes ferramentas conceituais e operacionais.

Aug 17th 2026
4 Weeks
Networks Data Analysis Network Analysis
Details
Infonomics I: Business Information Economics and Data Monetization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Infonomics I: Business Information Economics and Data Monetization (Coursera)

Business

Thriving in the Information Age compels organizations to deploy information as an actual business asset, not as an IT asset or merely as a business byproduct. This demands creativity in conceiving and implementing new ways to generate economic benefits from the wide array of information assets available to an organization. Unfortunately, information too frequently is underappreciated and therefore underutilized.

Aug 17th 2026
4 Weeks
Business Economics Big Data
Details
Business Statistics and Analysis Capstone (Coursera) Coursera
Rice University

Business Statistics and Analysis Capstone (Coursera)

Statistics & Data Analysis Data Science

The Business Statistics and Analysis Capstone is an opportunity to apply various skills developed across the four courses in the specialization to a real life data. The Capstone, in collaboration with an industry partner uses publicly available ‘Housing Data’ to pose various questions typically a client would pose to a data analyst. Your job is to do the relevant statistical analysis and report your findings in response to the questions in a way that anyone can understand.

Aug 17th 2026
4 Weeks
Data Analysis Microsoft Excel Business Analysis
Details
Infonomics II: Business Information Management and Measurement (Coursera) Coursera
University of Illinois at Urbana-Champaign

Infonomics II: Business Information Management and Measurement (Coursera)

Business

Even decades into the Information Age, accounting practices yet fail to recognize the financial value of information. Moreover, traditional asset management practices fail to recognize information as an asset to be managed with earnest discipline. This has led to a business culture of complacence, and the inability for most organizations to fully leverage available information assets. This second course in the two-part Infonomics series explores how and why to adapt well-honed asset management principles and practices to information, and how to apply accepted and new valuation models to gauge information’s potential and realized economic benefits.

Aug 17th 2026
4 Weeks
Business Big Data Accounting
Details