Excel: Apply & Evaluate Unsupervised Clustering
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Ask Coursera
Skills you'll gain
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
There are 2 modules in this course
This hands-on course empowers learners to apply, analyze, and evaluate unsupervised learning techniques—specifically clustering—using Microsoft Excel. Designed for learners with basic Excel knowledge, the course walks through the entire data clustering pipeline: from preparing and structuring datasets to building and refining logic-based cluster assignments.
Learners begin by identifying and selecting relevant data attributes, then construct conditional logic using Excel functions to group entries into meaningful clusters. Through progressive stages, learners extend these clusters across datasets and visualize patterns using scatter plots. The course culminates with a workbook-wide review where students evaluate the effectiveness of their clustering logic and summarize their analytical outcomes. By the end of the course, learners will confidently use Excel as a lightweight yet powerful tool for clustering analysis—without relying on programming or external machine learning platforms.
This module introduces learners to the foundational steps required to prepare data and implement clustering workflows in Excel. It covers understanding and formatting datasets, selecting relevant variables, and progressively building clustering logic using Excel functions. Learners will explore both initial and advanced clustering strategies to construct meaningful groupings and analyze structured patterns in data through conditional logic and iterative refinement.
What's included
9 videos4 assignments
9 videos•Total 76 minutes
- Introduction to Project•4 minutes
- Data Introduction•10 minutes
- Data Format and Selection•10 minutes
- Clustering Phase Part 1•11 minutes
- Clustering Phase Part 2•7 minutes
- Clustering Phase Part 3•7 minutes
- Clustering Phase Part 4•7 minutes
- Clustering Phase Part 5•11 minutes
- Clustering Phase Part 6•10 minutes
4 assignments•Total 60 minutes
- Graded - Data Preparation and Clustering Process•30 minutes
- Understanding the Data•10 minutes
- Initial Clustering Workflow•10 minutes
- Advanced Clustering Steps•10 minutes
This module focuses on the final stages of clustering using Excel, where learners apply, verify, and visualize their clustering logic. Through iterative enhancements and scatter plot construction, students will learn how to visually validate cluster groupings and complete the analytical process. The module concludes with a comprehensive review and consolidation of all clustering activities, ensuring learners can confidently assess and present their results.
What's included
5 videos3 assignments
5 videos•Total 48 minutes
- Clustering Phase Part 7•6 minutes
- Clustering Phase Part 8•9 minutes
- Scatter Plot•12 minutes
- Cluster Analysis Final Phasing•13 minutes
- Conclusion•7 minutes
3 assignments•Total 50 minutes
- Graded - Cluster Visualization and Final Analysis•30 minutes
- Finalizing the Clustering Process•10 minutes
- Evaluating Results and Project Wrap-up•10 minutes
Explore more from Data Analysis
- Status: Preview
Course
- Status: Free TrialU
University of Colorado Boulder
Course
- Status: Preview
Why people choose Coursera for their career
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 purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, 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,
