Coursera

Problem Solving with Excel (Coursera)

Offered by PwC,

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.

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

Course 2 of 5 in the Data Analysis and Presentation Skills: the PwC Approach Specialization.

Syllabus

WEEK 1
Overview of Excel
In this module, you will learn the basics of Excel navigation and Excel basic functionality. You will learn how to navigate the basic Excel screen including using formulas, subtotals and text formatting. We will provide you an opportunity to perform a problem solving exercise using basic Excel skills. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

WEEK 2
vLookups and Data Cleansing
In this module you will learn about VLookup, value cleansing and text functions. We will also introduce you to PwC's perspective on the value in cleansing data and using the appropriate functions. Finally, we will provide you an opportunity to perform a problem solving exercise using VLookup, value cleansing and text function. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

WEEK 3
Logical Functions & Pivot Tables
In this module, you will learn about logical functions and pivot tables. We will show you how to create and use pivot tables to solve business problems. We will give you an opportunity to practice creating and using a pivot table to solve a business problem. Finally, we will share some insight on PwC’s perspectives on the impact of Excel on your career and work. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

WEEK 4
More Advanced Formulas
In this module you will learn more advanced Excel formulas. We will show you how to create statistical formulas, perform an index match, and lastly, build financial formulas. We will provide you with an opportunity to problem solve using statistical formulas. Finally, we will give you an opportunity to practice what you have learned through a final project. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

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

University of California, San Diego

Mastering the Software Engineering Interview (Coursera)

CS: Software Engineering

You’ve hit a major milestone as a computer scientist and are becoming a capable programmer. You now know how to solve problems, write algorithms, and analyze solutions; and you have a wealth of tools (like data structures) at your disposal. You may now be ready for an internship or (possibly) an entry-level software engineering job. But can you land the internship/job? It depends in part on how well you can solve new technical problems and communicate during interviews. How can you get better at this? Practice!

Jun 8th 2026

4 Weeks

Algorithms Object-Oriented Software Engineering

Coursera

Duke University

Introduction to Probability and Data with R (Coursera)

Statistics & Data Analysis Data Science

This course introduces you to sampling and exploring data, as well as basic probability theory and Bayes' rule. You will examine various types of sampling methods, and discuss how such methods can impact the scope of inference. A variety of exploratory data analysis techniques will be covered, including numeric summary statistics and basic data visualization.

Jun 8th 2026

5-12 Weeks

Statistics Probability Inference

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 8th 2026

4 Weeks

Spreadsheets Excel Data Analysis

Coursera

Johns Hopkins University

Reproducible Research (Coursera)

Statistics & Data Analysis Data Science

This course focuses on the concepts and tools behind reporting modern data analyses in a reproducible manner. Reproducible research is the idea that data analyses, and more generally, scientific claims, are published with their data and software code so that others may verify the findings and build upon them. The need for reproducibility is increasing dramatically as data analyses become more complex, involving larger datasets and more sophisticated computations.

Jun 8th 2026

4 Weeks

Data Analysis Data Science Reproducible Research

Coursera

University of Colorado System

Business Intelligence Concepts, Tools, and Applications (Coursera)

Statistics & Data Analysis Data Science

This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You’ll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards.

Jun 8th 2026

5-12 Weeks

Data Analysis Decision Making Business Intelligence

Coursera

University of Michigan

Introduction to Data Science in Python (Coursera)

CS: Software Engineering Statistics & Data Analysis

This course will introduce the learner to the basics of the python programming environment, including fundamental python programming techniques such as lambdas, reading and manipulating csv files, and the numpy library. The course will introduce data manipulation and cleaning techniques using the popular python pandas data science library and introduce the abstraction of the Series and DataFrame as the central data structures for data analysis, along with tutorials on how to use functions such as groupby, merge, and pivot tables effectively. By the end of this course, students will be able to take tabular data, clean it, manipulate it, and run basic inferential statistical analyses.

Jun 8th 2026

4 Weeks

Python Data Analysis Data Science

Coursera

University of California, Irvine

Cómo resolver problemas y tomar decisiones con eficacia (Coursera)

Management & Leadership

El pensamiento crítico (la aplicación de métodos científicos y del razonamiento lógico) constituye la base para resolver problemas y tomar decisiones con eficacia. El pensamiento crítico nos permite evitar escollos frecuentes, verificar la validez de nuestras creencias y suposiciones y corregir las distorsiones que pueden haberse producido en nuestros procesos mentales.

Jun 8th 2026

4 Weeks

Critical Thinking Problem Solving Éxito Profesional Specialization

Coursera

The University of Sydney

Problem-Solving Skills for University Success (Coursera)

Education Social Sciences

In this course, you will learn how to develop your Problem Solving and Creativity Skills to help you achieve success in your university studies. After completing this course, you will be able to: 1-Recognise the importance and function of problem solving and creative thought within academic study and the role of critical thought in creative ideation; 2-Develop a toolkit to be able to identify real problems and goals within ill-defined problems; 3-Recognize and apply analytical problem solving techniques: 4-Recognise and apply creative problem solving techniques; 5-Identify the use of creativity within and types of problems most common to your field; 6-Apply learnt problem solving and creative ideation skills to a real-life context and reflect on personal learning processes

Jun 8th 2026

5-12 Weeks

Education Creativity University

Coursera

ESSEC Business School

Foundations of strategic business analytics (Coursera)

Management & Leadership Business

Who is this course for? This course is designed for students, business analysts, and data scientists who want to apply statistical knowledge and techniques to business contexts. For example, it may be suited to experienced statisticians, analysts, engineers who want to move more into a business role. You will find this course exciting and rewarding if you already have a background in statistics, can use R or another programming language and are familiar with databases and data analysis techniques such as regression, classification, and clustering.

Jun 8th 2026

4 Weeks

Data Analysis Analytics Presentations

Coursera

University of Washington

Machine Learning Foundations: A Case Study Approach (Coursera)

Statistics & Data Analysis Data Science

Do you have data and wonder what it can tell you? Do you need a deeper understanding of the core ways in which machine learning can improve your business? Do you want to be able to converse with specialists about anything from regression and classification to deep learning and recommender systems? In this course, you will get hands-on experience with machine learning from a series of practical case-studies.

Jun 8th 2026

5-12 Weeks

Python Machine Learning Clustering

Coursera

University of Illinois at Urbana-Champaign

Cloud Computing Applications, Part 2: Big Data and Applications in the Cloud (Coursera)

Security & Networking

Welcome to the Cloud Computing Applications course, the second part of a two-course series designed to give you a comprehensive view on the world of Cloud Computing and Big Data! In this second course we continue Cloud Computing Applications by exploring how the Cloud opens up data analytics of huge volumes of data that are static or streamed at high velocity and represent an enormous variety of information. Cloud applications and data analytics represent a disruptive change in the ways that society is informed by, and uses information.

Jun 8th 2026

4 Weeks

Cloud Machine Learning Big Data

Coursera

University of Illinois at Urbana-Champaign

Exploring and Producing Data for Business Decision Making (Coursera)

Management & Leadership

This course provides an analytical framework to help you evaluate key problems in a structured fashion and will equip you with tools to better manage the uncertainties that pervade and complicate business processes. Specifically, you will be introduced to statistics and how to summarize data and learn concepts of frequency, normal distribution, statistical studies, sampling, and confidence intervals.

Jun 8th 2026

4 Weeks

Probability Excel Inference