Problem Solving Using Microsoft Excel (Coursera)

Problem Solving Using Microsoft Excel (Coursera)

Excel is a spreadsheet developed by Microsoft for Windows for macOS, iOS and Android. Using Excel, one can make simple and complex calculations, plot graphs and charts, and analyze data for problem solving. It is a very popular spreadsheet, used by students, teachers, and industries worldwide. In this project, you will understand what a spreadsheet is, learn about the Excel interface, the basic functions and techniques used in Excel, how to identify and troubleshoot common errors, solve data tables, and create linear regression models!

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

In this Guided Project, you will:

  • Understand what a spreadsheet is
  • Learn about the Excel interface and the basic functions and techniques used in Excel, identify and troubleshoot common errors
  • Solve data tables and create linear regression models

Learn step-by-step

  1. Understand what a spreadsheet is and identify the different components of the Excel window
  2. Use various popular Excel functions and techniques in your calculations
  3. Identify and troubleshoot common errors
  4. Make different plots, graphs and charts in Excel
  5. Solve data tables using Excel
  6. Solve optimization problems using the Solver tool
  7. Create regression models in Excel
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Excel Essentials and Beyond (Coursera) Coursera
Board Infinity

Excel Essentials and Beyond (Coursera)

Dive into "Excel Essentials and Beyond", a comprehensive exploration of Excel, the world's leading spreadsheet tool. This course is thoughtfully crafted for both newcomers to Excel and also for those aiming for mastery. We begin by introducing Excel's robust interface and foundational features, ensuring a firm grasp of data organization techniques. As you advance, you'll delve into data visualization, transforming raw data into captivating stories.

Aug 17th 2026
5-12 Weeks
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Aug 10th 2026
5-12 Weeks
Excel/VBA for Creative Problem Solving, Part 2 (Coursera) Coursera
University of Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 2 (Coursera)

Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Aug 10th 2026
4 Weeks
Accounting Data Analytics with Python (Coursera) Coursera
University of Illinois at Urbana-Champaign

Accounting Data Analytics with Python (Coursera)

This course focuses on developing Python skills for assembling business data. It will cover some of the same material from Introduction to Accounting Data Analytics and Visualization, but in a more general purpose programming environment (Jupyter Notebook for Python), rather than in Excel and the Visual Basic Editor. These concepts are taught within the context of one or more accounting data domains (e.g., financial statement data from EDGAR, stock data, loan data, point-of-sale data).

Aug 17th 2026
5-12 Weeks
Fundamentos de Excel para Negocios (Coursera) Coursera
Universidad Austral

Fundamentos de Excel para Negocios (Coursera)

Cuando finalices este curso habrás logrado un gran número de habilidades como introducir información, ordenarla, manipularla, realizar cálculos de diversa índole (matemáticos, trigonométricos, estadísticos, financieros, ingenieriles, probabilísticos), extraer conclusiones, trabajar con fechas y horas, construir gráficos, imprimir reportes y muchas más.

Aug 17th 2026
5-12 Weeks
Excel aplicado a los negocios (Nivel Avanzado) (Coursera) Coursera
Universidad Austral

Excel aplicado a los negocios (Nivel Avanzado) (Coursera)

Objetivos Generales: Al finalizar el curso, podrás: 1.- ENTENDER y profundizar convenientemente aspectos específicos de diferentes formas de trabajo (individual o grupal), 2.- EVALUAR el uso de funciones avanzadas para manipular datos y CREAR tus propios análisis utilizando técnicas específicas tales como tablas dinámicas, análisis de hipótesis, administración de escenarios, tablas de simple y doble entrada, análisis de optimización de recursos. 3.- ANALIZAR cómo vincular Excel con otras aplicaciones importando información desde archivos de texto y bases de datos, exportando información a archivos de texto de diversas formas. 4.- ENTENDER el uso de macros lo que te permitirá vislumbrar otro universo de aplicaciones que harán mucho más productiva tu labor.

Aug 10th 2026
5-12 Weeks
Business Applications of Hypothesis Testing and Confidence Interval Estimation (Coursera) Coursera
Rice University

Business Applications of Hypothesis Testing and Confidence Interval Estimation (Coursera)

Confidence intervals and Hypothesis tests are very important tools in the Business Statistics toolbox. A mastery over these topics will help enhance your business decision making and allow you to understand and measure the extent of ‘risk’ or ‘uncertainty’ in various business processes. This course advances your knowledge about Business Statistics by introducing you to Confidence Intervals and Hypothesis Testing. These are done by easy to understand applications.

Aug 10th 2026
4 Weeks
Programming Fundamentals (Coursera) Coursera
Duke University

Programming Fundamentals (Coursera)

Programming is an increasingly important skill, whether you aspire to a career in software development, or in other fields. This course is the first in the specialization Introduction to Programming in C, but its lessons extend to any language you might want to learn. This is because programming is fundamentally about figuring out how to solve a class of problems and writing the algorithm, a clear set of steps to solve any problem in its class.

Aug 10th 2026
4 Weeks
Habilidades de Excel para negócios: Fundamentos (Coursera) Coursera
Macquarie University

Habilidades de Excel para negócios: Fundamentos (Coursera)

Neste primeiro curso da especialização Habilidades de Excel para negócios, você aprenderá os fundamentos do Microsoft Excel. Dentro de seis semanas, você poderá navegar habilmente pela interface de usuário do Excel, realizar cálculos básicos com fórmulas e funções, formatar planilhas profissionalmente e criar visualizações de dados por meio de gráficos e tabelas.

Aug 10th 2026
5-12 Weeks
Introduction to Engineering Design (Coursera) Coursera
Starweaver

Introduction to Engineering Design (Coursera)

In today's fast-paced technological environment, understanding the fundamentals of engineering design is crucial for aspiring engineers and professionals alike. This comprehensive course serves as a primer, introducing participants to key concepts and methodologies essential for designing innovative solutions to complex problems. It provides an overview of the engineering design process, emphasizing the integration of creativity and functionality in problem-solving.

Aug 17th 2026
4 Weeks