Coursera

Everyday Excel, Part 2 (Coursera)

Offered by University of Colorado Boulder,

"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Parts 1". Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)".

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

This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel.
In this course (Part 2), you will:
1) learn advanced data management techniques;
2) learn how to implement financial calculations in Excel;
3) use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses; 4) learn how to create mathematical predictive regression models using the Regression tool in Excel.
This course is meant to be fun and thought-provoking. I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!" Given the wide range in experience and abilities of learners, the goal of the course is to appeal to a wide audience. The course is organized into 5 Weeks (modules).
To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.
Course 2 of 3 in the Everyday Excel Specialization.
What You Will Learn

Advanced data management techniques
How to implement financial calculations in Excel
How to use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses
How to create mathematical predictive regression models using the Regression tool in Excel

Syllabus

WEEK 1
Advanced Data Management
In Week 1 you will learn all about advanced data management strategies in Excel. These techniques include two-way look-ups, two-way conditional look-ups, how to find the maximum or minimum location in an array, conditional drop-down lists, advanced conditional formatting strategies, how to compare lists (for unique, duplicates, and absent items), advanced duplicate management, and how to work with expiry dates. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. For paid learners, the Week 2 Excel files will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!

WEEK 2
Excel for Financial Applications, Part 1
In Weeks 2 and 3 you will learn all about advanced financial functions and applications in Excel. In Week 2, you will first learn about the concepts of and how to implement Excel formulas for the time value of money, simple and compound interest, and various loans (amortized, interest-only, and line of credit loans). You will learn how to create amortization schedules in Excel for these loans. Week 2 concludes with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 2, you will be given a "completion code", which you can input into the Assignment 2 submission quiz to earn credit for the assignment. For paid learners, the Week 3 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!

WEEK 3
Excel for Financial Applications, Part 2
In Week 3, you will continue learning about advanced financial features of Excel. First, you will learn about depreciation and how to calculate depreciation and implement depreciation schedules in Excel. Next, you will learn about cash flows and net present value, and how to implement Excel functions to analyze cash flows. Then, you will learn how to compare financial alternatives. Finally, you'll learn about internal rate of return (IRR) and how to implement the IRR function in Excel. The week concludes with Quiz 3 and Assignment 3. When you successfully complete Assignment 3, you will be given a "completion code", which you can input into the Assignment 3 submission quiz to earn credit for the assignment. For paid learners, the Week 4 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!

WEEK 4
Case Studies and "What-If" Analyses
One of the most valuable aspects of Excel is that it can be used nicely for case studies and "what-if" analyses. In Week 4, you'll learn about case studies, one-way and two-way data tables, and how to use the Goal Seek and Solver tools for targeting calculations. You'll also learn to use the Solver tool for optimization problems and problems for which you have constraints. The week concludes with Quiz 4 and Assignment 4. When you successfully complete Assignment 4, you will be given a "completion code", which you can input into the Assignment 4 submission quiz to earn credit for the assignment. For paid learners, the Week 5 Excel files will be released when you have successfully passed Quiz 4 and Assignment 4. Good luck!

WEEK 5
Model Building in Excel
Week 5 of the course is all about creating mathematical models for experimental data. In this week, you'll first learn about how to insert trendlines into Excel plots and how to linearly interpolate between data points. Next, you'll learn about simple linear regression, general linear regression, and multilinear regression models and how to use Excel's Regression tool to create these regression models. The week concludes with an introduction to the logistic regression model, which is a type of nonlinear regression model. The week concludes with Quiz 5 and Assignment 5. When you successfully complete Assignment 5, you will be given a "completion code", which you can input into the Assignment 5 submission quiz to earn credit for the assignment. Then, you can pat yourself on the back for completing "Everyday Excel, Part 2!"

Go to Class

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

Related Courses

Coursera

Tufts University

Hypothesis Testing with Python and Excel (Coursera)

Statistics & Data Analysis Data Science

In today's job market, leaders need to understand the fundamentals of data to be competitive. An essential procedure to understand business and analytics is hypothesis testing. This short course, designed by Tufts University expert faculty, will teach the fundamentals of hypothesis testing of a population mean and a population proportion, using Excel and Python for calculations. You'll also discover the central limit theorem, which is essential for hypothesis testing. To conclude the course, you will apply your newfound skills by creating a plan for an experiment in your own workplace that uses hypothesis testing.

Jun 23rd 2026

1 Week

Python Excel Python Programming

Coursera

PwC

Data Visualization with Advanced Excel (Coursera)

Statistics & Data Analysis Data Science

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek.

Jun 22nd 2026

4 Weeks

Databases Excel Data Analysis

Coursera

Georgia Institute of Technology

Machine Design Part I (Coursera)

Engineering Sci: Physics

“Machine Design Part I” is the first course in an in-depth three course series of “Machine Design.” The “Machine Design” Coursera series covers fundamental mechanical design topics, such as static and fatigue failure theories, the analysis of shafts, fasteners, and gears, and the design of mechanical systems such as gearboxes. Throughout this series of courses we will examine a number of exciting design case studies, including the material selection of a total hip implant, the design and testing of the wing on the 777 aircraft, and the impact of dynamic loads on the design of an bolted pressure vessel. In this first course, you will learn robust analysis techniques to predict and validate design performance and life.

Jun 22nd 2026

5-12 Weeks

Mechanical Engineering Problem Solving Failure

Coursera

Rice University

Introduction to Data Analysis Using Excel (Coursera)

Statistics & Data Analysis

The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This course is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills.

Jun 22nd 2026

4 Weeks

Spreadsheets Excel Data Analysis

Coursera

Rice University

Business Statistics and Analysis Capstone (Coursera)

Statistics & Data Analysis Data Science

The Business Statistics and Analysis Capstone is an opportunity to apply various skills developed across the four courses in the specialization to a real life data. The Capstone, in collaboration with an industry partner uses publicly available ‘Housing Data’ to pose various questions typically a client would pose to a data analyst. Your job is to do the relevant statistical analysis and report your findings in response to the questions in a way that anyone can understand.

Jun 22nd 2026

4 Weeks

Data Analysis Microsoft Excel Business Analysis

Coursera

IBM

IBM Data Analyst Capstone Project (Coursera)

Statistics & Data Analysis Data Science

In this course you will apply various Data Analytics skills and techniques that you have learned as part of the previous courses in the IBM Data Analyst Professional Certificate. You will assume the role of an Associate Data Analyst who has recently joined the organization and be presented with a business challenge that requires data analysis to be performed on real-world datasets. You will undertake the tasks of collecting data from multiple sources, performing exploratory data analysis, data wrangling and preparation, statistical analysis and mining the data, creating charts and plots to visualize data, and building an interactive dashboard.

Jun 22nd 2026

5-12 Weeks

SQL Data Analysis Microsoft Excel

Coursera

University of Melbourne,The Chinese University of Hong Kong

Basic Modeling for Discrete Optimization (Coursera)

CS: Software Engineering

Optimization is a common form of decision making, and is ubiquitous in our society. Its applications range from solving Sudoku puzzles to arranging seating in a wedding banquet. The same technology can schedule planes and their crews, coordinate the production of steel, and organize the transportation of iron ore from the mines to the ports. Good decisions in manpower and material resources management also allow corporations to improve profit by millions of dollars.

Jun 22nd 2026

4 Weeks

Programming Software Discrete Optimization

Coursera

Cloudera

Managing Big Data in Clusters and Cloud Storage (Coursera)

Statistics & Data Analysis Data Science

In this course, you'll learn how to manage big datasets, how to load them into clusters and cloud storage, and how to apply structure to the data so that you can run queries on it using distributed SQL engines like Apache Hive and Apache Impala. You’ll learn how to choose the right data types, storage systems, and file formats based on which tools you’ll use and what performance you need.

Jun 22nd 2026

5-12 Weeks

SQL Big Data Data Management

Coursera

IBM

IBM Data Privacy for Information Architecture (Coursera)

CS: Information & Technology

Data privacy controls how information is collected, used, shared, and disposed of, in accordance with policies or external laws and regulations. In this course, students will gain an understanding of what data privacy is along with how to identify and understand typical data protection and privatization objectives that an enterprise may have, and how to choose a data protection approach.

Jun 22nd 2026

5-12 Weeks

Security Data Management Organizational Structure

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

Coursera

PwC

Problem Solving with Excel (Coursera)

Statistics & Data Analysis Data Science

This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration. Each week you will build on your excel skills and be provided an opportunity to practice what you’ve learned. Finally, you will have a chance to put your knowledge to work in a final project. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

Jun 22nd 2026

4 Weeks

Excel Data Analysis Microsoft Excel

Coursera

University of California, Davis

Critical Thinking Skills for the Professional (Coursera)

Business

Have you ever tried to find a solution to a problem only to realize you’ve been focusing on the wrong problem from the very beginning? Or you’ve proposed a solution only to have it shut down by your boss or coworkers? How stressful and defeating is that? With massive changes in our world that seem to create the most difficult of circumstances, both personally and professionally, your skills as a critical thinker and problem solver need to be further developed now more than ever.

Jun 22nd 2026

3 Weeks

Business Decision Making Critical Thinking