Coursera
Coursera Logo

Business Analytics with Excel: Elementary to Advanced 

  • Offered byCoursera

Business Analytics with Excel: Elementary to Advanced
 at 
Coursera 
Overview

Duration

23 hours

Start from

Start Now

Total fee

Free

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Explore Free Course External Link Icon

Credential

Certificate

Business Analytics with Excel: Elementary to Advanced
 at 
Coursera 
Highlights

  • Earn a Certificate upon completion
Details Icon

Business Analytics with Excel: Elementary to Advanced
 at 
Coursera 
Course details

More about this course
  • This Business Analytics class focuses on the latter: it introduces students to analytical frameworks used for decision making though Excel modeling
  • These include Linear and Integer Optimization, Decision Analysis, and Risk modeling
  • The course will prepare managers who are comfortable with translating trade-offs into models, understanding the output of the software, and who are appreciative of quantitative approaches to decision making
  • This class focuses on introducing students to analytical frameworks used for decision making to make sense of the data, starting from the basics of Excel and working up to advanced modeling techniques

Business Analytics with Excel: Elementary to Advanced
 at 
Coursera 
Curriculum

Introduction to Excel: Basics and Best Practices

Warm-Up - Creating a Budget in Excel

NCAA T-Shirt Vendor

Woodworks Bookshelf Co.

Course Information

NCAA T-Shirt Vendor

Formatting, Formulas, and Functions

Woodworks Bookshelf Co.

References, Tables, and Charts

Introduction to Excel

What-If Analysis in Excel

Quality Sweater Company

B&N Bookstore

Quality Sweater Company

Goal Seek and One-Way Data Tables

B&N Bookstore

Two-Way Data Tables and More Functions

Haute Dog

Copy Shop

What-If Analysis in Excel

Self-Evaluation for What-If Analysis

Decision Analysis through Regression and NPV

The 19th Hole

Gopher Drugs

The 19th Hole

Trendlines and Conditional Formatting

Gopher Drugs

Modeling Net Present Value

Midcourse Project

Sample Model - Bluejay Natural Gas

Exercise Equipment Company

Net Present Value

Decision Analysis through Regression and NPV

Self Evaluation for Decision Analysis

Model Set-Up - Bluejay Natural Gas

Linear Programming

Campaign Marketing

PC Tech Company

Investment Allocation

Busing Problem

What Is Linear Programming?

Adding Solver to Excel

Campaign Marketing

Using Solver for LP Problems

PC Tech Company

Investment Allocation

Busing Problem

Intro to Linear Programming

Furniture Company

Feed Mix

Bus Company

Linear Programming

Transportation and Assignment Problems

Transportation Problem Excel Template

Alternative Excel Template

New Hire Assignments

MLB Umpire Assignment

Transportation Problems

New Hire Assignments

Assignment Problems

MLB Umpire Assignment

Construction Projects

College Professors

Transportation and Assignment Problems

Integer Programming and Nonlinear Programming

Princess Brides

Bolsa de Café

Binary Investment Decision

Portfolio Variance

Motorcross Snowmobiles

Princess Brides

Bolsa de Café

Integer Programming in Solver

Binary Investment Decision

Binary Integer Programming with Solver

Portfolio Variance

Motorcross Snowmobiles

Nonlinear Programming with Solver

Final Project

Sample Model - Bluejay Natural Gas Project Selection

Art Posters

Horizon Wireless

Baseball Stadium

Integer Programming and Nonlinear Programming

Project Selection at Bluejay Natural Gas

Business Analytics with Excel: Elementary to Advanced
 at 
Coursera 
Admission Process

    Important Dates

    May 25, 2024
    Course Commencement Date

    Other courses offered by Coursera

    – / –
    3 months
    Beginner
    – / –
    20 hours
    Beginner
    – / –
    2 months
    Beginner
    – / –
    3 months
    Beginner
    View Other 6715 CoursesRight Arrow Icon
    qna

    Business Analytics with Excel: Elementary to Advanced
     at 
    Coursera 

    Student Forum

    chatAnything you would want to ask experts?
    Write here...