Fundamentals of Data Analysis in Excel
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Fundamentals of Data Analysis in Excel
This course is part of Data Skills for Excel Professionals Specialization
12,005 already enrolled
Included with
Ask Coursera
95 reviews
95 reviews
Skills you'll gain
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 8 modules in this course
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. 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
Welcome to the Fundamentals of Data Analysis in Excel course.
What's included
1 video1 reading
1 video•Total 1 minute
- Course Overview•1 minute
1 reading•Total 10 minutes
- Downloads•10 minutes
In this module, we will learn to analyze a dataset using native Excel tools.
What's included
10 videos
10 videos•Total 40 minutes
- Introduction•1 minute
- Sorting & Filtering•5 minutes
- Conditional Formatting•4 minutes
- Conditional Logic - IF() & SWITCH()•5 minutes
- Conditional Logic - IF() & IFS()•4 minutes
- SUMPRODUCT() Function•7 minutes
- Defining Variables - LET()•4 minutes
- Defining Names - Name Manager•5 minutes
- Defining Functions - LAMBDA()•5 minutes
- Review•1 minute
In this module, we will learn to apply Excel tools and formulas to transform and structure our data.
What's included
10 videos1 assignment
10 videos•Total 40 minutes
- Introduction•1 minute
- Text to Columns•3 minutes
- Removing Duplicate Values•3 minutes
- String Functions for Text Values•7 minutes
- Working with Date Values•7 minutes
- Looking Up Data - VLOOKUP()•4 minutes
- Using HLOOKUP() with VLOOKUP()•6 minutes
- Looking Up Data - INDEX() & MATCH()•5 minutes
- Dealing with Errors - IFNA() & IFERROR()•3 minutes
- Chapter Review - Transform Data in Excel•1 minute
1 assignment•Total 25 minutes
- Week 1 Challenge•25 minutes
In this module, we will learn to apply Excel tools and formulas to transform and structure our data.
What's included
10 videos
10 videos•Total 37 minutes
- Excel Tables•1 minute
- Calculated Columns in Excel Tables•5 minutes
- Special Item Specifiers in Excel Tables•4 minutes
- Power Query - Introduction•2 minutes
- Power Query - Filtered Table•5 minutes
- Power Query - Group & Aggregate Data•5 minutes
- Linked Data Types•4 minutes
- Expand Power Query Data with Linked Data Types•4 minutes
- Linked Data Types as a Power Query Source•3 minutes
- Chapter Review - Excel Tables•6 minutes
What's included
6 videos1 assignment
6 videos•Total 19 minutes
- Chapter Introduction - Dynamic Arrays•1 minute
- Dynamic Array Formulas•5 minutes
- Dynamic Array Functions•2 minutes
- Combining Dynamic Arrays & Excel Functions•4 minutes
- XLOOKUP()•6 minutes
- Chapter Review - Dynamic Arrays•1 minute
1 assignment•Total 25 minutes
- Week 2 Challenge•25 minutes
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.
What's included
10 videos
10 videos•Total 35 minutes
- Chapter Introduction - Pivot Tables•2 minutes
- Summarize Data with a PivotTable•3 minutes
- Update & Sort a PivotTable•3 minutes
- PivotTable Analyze Options•6 minutes
- PivotTable Design Options•3 minutes
- Filtering with Slicers & Timelines•6 minutes
- Pivot Charts•4 minutes
- Analyze Data - Ideas in Excel•3 minutes
- Power Pivot•4 minutes
- Chapter Review - Pivot Tables•1 minute
In this module, we will learn to visualize data with pivot and Excel charts.
What's included
12 videos
12 videos•Total 35 minutes
- Chapter Introduction - Visualize Data in Excel•1 minute
- Excel Visuals•3 minutes
- Excel Visuals Continued•5 minutes
- Dashboard Preview•2 minutes
- Net Earnings Waterfall•3 minutes
- Combo Chart - Cash Flow & Cash Balance•4 minutes
- Bullet Chart - Introduction•2 minutes
- Creating Bullet Chart•3 minutes
- Formatting Bullet Chart•4 minutes
- Setting up Data Table for Bullet Chart•7 minutes
- Excel vs Dashboard Tools•1 minute
- Chapter Review - Visualize Data in Excel•0 minutes
What's included
1 video1 assignment
1 video•Total 1 minute
- Summary•1 minute
1 assignment•Total 60 minutes
- Week 3 Challenge•60 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Explore more from Finance
- Status: Free Trial
Course
- Status: Free TrialL
Logical Operations
Course
- Status: Free TrialM
Macquarie University
Course
- Status: PreviewC
Coursera
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
82.29%
- 4 stars
14.58%
- 3 stars
1.04%
- 2 stars
1.04%
- 1 star
1.04%
Showing 3 of 95
Reviewed on Aug 2, 2025
An excellent and perfect for finance students and finance relevant employees.
Reviewed on Dec 10, 2024
There are too many short videos, it's better to put the similar topics together.
Reviewed on Jan 6, 2026
Informative yet simple and practical course, highly recommend!
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,