Coursera

Everyday Excel, Part 3 (Projects) (Coursera)

Offered by University of Colorado Boulder,
Everyday Excel, Part 3 (Projects) (Coursera)

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and Parts 2". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways).
Each learner must complete two easy projects (chosen from four), two intermediate projects (chosen from 4), and three main (more difficult) projects (chosen from 7).

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds.
It is hoped that this project-based courses will damatically reinforce the application of Excel tools, techniques, and functions to real-world projects.
What You Will Learn

  • In this course, you'll apply Excel functions and tools to solving broad, somewhat open-ended problems through a wide variety of "guided" projects.

Course 3 of 3 in the Everyday Excel Specialization.

Syllabus

WEEK 1
Introduction and General Course Information
This module contains introductory information regarding the course requirements, how to obtain a Course Certificate, and information for Mac users.

WEEK 2
Warm-Up Projects (Choose Two)
For the Warm-Up Projects, you must select two of four projects to complete. If you are more math-inclined, you might appreciate the "Nearest Eighth of an Inch" and "Ladder Around the Corner" projects. If you are not so math-inclined, you will gravitate towards the "World Bank Lookup" and the "Dynamic Amortization Schedule" projects.

WEEK 3
Intermediate Projects (Choose Two)
Now that you're warmed up, let's transition to some more challenging projects! There are four possible projects for you to choose from for the Intermediate Projects, and you must complete two of them. The Sensitivity Analysis and Historical Weather Lookup (Part A) projects are perhaps the easier projects of the bunch, but the Dynamic Data Cleaning is not far behind. The Friday the 13th project is interesting but possibly a tad bit more challenging. Have fun!

WEEK 4
Main Projects (Choose Three)
Now for the heart of the course - the Main Projects! You'll implement many of the techniques and tools that you've learned in Parts 1 and 2 of "Everyday Excel". These projects are more involved than the intermediate projects. However, in many cases I provide significant hints and suggestions (mainly through screencasts). Therefore, I "guide" you through these projects. You'll be left with a proud, well-earned sense of accomplishment after having done these projects! There are 5 projects to choose from, and you need to complete 3 of them. Good luck!

WEEK 5
For Honors!
Are you chomping at the bit to apply more of your vast Excel knowledge to some more challenging problems?! If so, the Honors Certificate is for you! For Honors distinction on your Course Certificate, complete both projects. The Historical Weather Lookup (Part B) is a continuation of the Historical Weather Lookup (Part A), and Francesca's French Bakery is a tough one. Far less hints and tips are provided for these projects, so it is up to you to utilize what you've learned in these courses to solve these open-ended problems!

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

Related Courses

Data Manipulation at Scale: Systems and Algorithms (Coursera) Coursera
University of Washington

Data Manipulation at Scale: Systems and Algorithms (Coursera)

Statistics & Data Analysis Data Science

Data analysis has replaced data acquisition as the bottleneck to evidence-based decision making --- we are drowning in it. Extracting knowledge from large, heterogeneous, and noisy datasets requires not only powerful computing resources, but the programming abstractions to use them effectively. The abstractions that emerged in the last decade blend ideas from parallel databases, distributed systems, and programming languages to create a new class of scalable data analytics platforms that form the foundation for data science at realistic scales.

Jun 22nd 2026
4 Weeks
Algebra Algorithms Databases
Details
Algorithms on Strings (Coursera) Coursera
University of California, San Diego,Higher School of Economics - HSE University

Algorithms on Strings (Coursera)

CS: Software Engineering CS: Theory

World and internet is full of textual information. We search for information using textual queries, we read websites, books, e-mails. All those are strings from the point of view of computer science. To make sense of all that information and make search efficient, search engines use many string algorithms. Moreover, the emerging field of personalized medicine uses many search algorithms to find disease-causing mutations in the human genome.

Jun 22nd 2026
4 Weeks
Algorithms Data Structures Strings
Details
Practical Machine Learning (Coursera) Coursera
Johns Hopkins University

Practical Machine Learning (Coursera)

Statistics & Data Analysis Data Science

One of the most common tasks performed by data scientists and data analysts are prediction and machine learning. This course will cover the basic components of building and applying prediction functions with an emphasis on practical applications. The course will provide basic grounding in concepts such as training and tests sets, overfitting, and error rates.

Jun 22nd 2026
4 Weeks
Algorithms Machine Learning Regression
Details
Forecasting Models for Marketing Decisions (Coursera) Coursera
Emory University

Forecasting Models for Marketing Decisions (Coursera)

Management & Leadership Marketing & Communication

How will customers act in the future? What will demand for our products and services be? How much inventory should we order for the next season? Beyond simply forecasting what customers will do, marketers need to understand how their actions can shape future behavior. In Developing Forecasting Tools with Excel, learners will develop an understanding of the basic components of a forecasting model, how to build their own forecasting models, and how to evaluate the performance of forecasting models.

Jun 22nd 2026
4 Weeks
Marketing Excel Microsoft Excel
Details
Big Data Modeling and Management Systems (Coursera) Coursera
University of California, San Diego

Big Data Modeling and Management Systems (Coursera)

Statistics & Data Analysis Data Science

Once you’ve identified a big data issue to analyze, how do you collect, store and organize your data using Big Data solutions? In this course, you will experience various data genres and management tools appropriate for each. You will be able to describe the reasons behind the evolving plethora of new big data platforms from the perspective of big data management systems and analytical tools.

Jun 22nd 2026
5-12 Weeks
Big Data Data Management Data Modeling
Details
Machine Learning With Big Data (Coursera) Coursera
University of California, San Diego

Machine Learning With Big Data (Coursera)

Statistics & Data Analysis Data Science

Want to make sense of the volumes of data you have collected? Need to incorporate data-driven decisions into your process? This course provides an overview of machine learning techniques to explore, analyze, and leverage data. You will be introduced to tools and algorithms you can use to create machine learning models that learn from data, and to scale those models up to big data problems.

Jun 22nd 2026
5-12 Weeks
Algorithms Machine Learning Big Data
Details
Advanced Algorithms and Complexity (Coursera) Coursera
University of California, San Diego,Higher School of Economics - HSE University

Advanced Algorithms and Complexity (Coursera)

CS: Software Engineering CS: Theory

You've learned the basic algorithms now and are ready to step into the area of more complex problems and algorithms to solve them. Advanced algorithms build upon basic ones and use new ideas. We will start with networks flows which are used in more typical applications such as optimal matchings, finding disjoint paths and flight scheduling as well as more surprising ones like image segmentation in computer vision.

Jun 22nd 2026
5-12 Weeks
Algorithms Data Structures Machine Learning
Details
Introduction to Recommender Systems: Non-Personalized and Content-Based (Coursera) Coursera
University of Minnesota

Introduction to Recommender Systems: Non-Personalized and Content-Based (Coursera)

Data Science

This course, which is designed to serve as the first course in the Recommender Systems specialization, introduces the concept of recommender systems, reviews several examples in detail, and leads you through non-personalized recommendation using summary statistics and product associations, basic stereotype-based or demographic recommendations, and content-based filtering recommendations.

Jun 22nd 2026
4 Weeks
Statistics Machine Learning Data Mining
Details