MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
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.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.