Fundamentals of Data Analysis in Excel (Coursera)

Fundamentals of Data Analysis in Excel (Coursera)
Course Auditing
Categories
Effort
Certification
Languages
No prior experience required.
Misc

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

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.

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

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



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

Course Auditing
45.00 EUR/month
No prior experience required.

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