Business Analytics with Excel: Elementary to Advanced

Johns Hopkins University

A leader in a data-driven world requires knowledge of statistical methods and appropriate models to analyze data. This course focuses on analytical frameworks for decision-making using Excel, covering linear and integer optimization, decision analysis, risk modeling, and more.

  • Emphasizes formulating problems and translating them into useful models
  • Prepares managers to interpret the output of software and appreciate quantitative decision-making approaches
  • Covers basic to advanced modeling techniques, starting from Excel basics

Certificate Available ✔

Get Started / More Info
Business Analytics with Excel: Elementary to Advanced
Course Modules

This course comprises six modules that cover Excel basics, what-if analysis, decision analysis through regression and NPV, linear programming, transportation and assignment problems, and integer programming and nonlinear programming, offering a comprehensive journey from fundamental skills to advanced modeling techniques.

Introduction to Excel: Basics and Best Practices

This module introduces Excel basics and best practices, from creating budgets to using formatting, formulas, and functions. Students will gain a solid foundation in Excel before moving on to more advanced analytical techniques.

What-If Analysis in Excel

Discover what-if analysis in Excel, including goal seeking, data tables, uncertainty, and more. Students will learn to apply these techniques to real-world business problems, such as determining break-even points and analyzing uncertainty.

Decision Analysis through Regression and NPV

Explore decision analysis through regression and net present value (NPV) calculations. Students will learn to model and evaluate decision alternatives, using regression to analyze trends and forecast future outcomes.

Linear Programming

Learn about linear programming, including campaign marketing, investment allocation, and transportation problems. Students will apply solver tools in Excel to optimize resource allocation and solve complex business challenges.

Transportation and Assignment Problems

This module covers transportation and assignment problems, including alternative Excel templates and real-world scenarios such as new hire assignments and MLB umpire assignments. Students will develop problem-solving skills for logistical challenges.

Integer Programming and Nonlinear Programming

Delve into integer programming and nonlinear programming using real-world examples like project selection, portfolio variance, and investment decisions. Students will learn to use solver tools to optimize decision-making in complex business scenarios.

More Business Essentials Courses

Fintech: Foundations & Applications of Financial Technology

University of Pennsylvania

Explore the world of financial technology with Wharton's Fintech Specialization. Gain insights into cryptocurrency, blockchain, robo-advising, and more to make informed...

Habilidades de Excel para el negocio: Conceptos básicos

Macquarie University

Habilidades de Excel para el negocio: Conceptos básicos provides a comprehensive foundation in Microsoft Excel, covering essential skills such as navigating the...

Salesforce Reporting

University of California, Irvine

Salesforce Reporting is a comprehensive course covering custom objects, data management, and customer engagement using Salesforce Service Cloud.

Gestión de clientes potenciales con Hubspot

HubSpot Academy

Enroll in this course to learn how to effectively manage potential clients using HubSpot tools.