Business Analytics with Excel: Elementary to Advanced Excel

GMUSD52

Credits: 2.00

Prerequisites : For Regular Pathway Eligibility the candidate must have passed class 12th and should have cleared the five exams covering all six modules. (Will be covered, if the knowledge gap is found)

Course Duration : 30 Hours / 12 Weeks

Start Date : 2024-03-15

End Date : 2024-07-15

Seats Remaining : 60

BACK

Aim & Summary

The purpose of this course is to expose you to a variety of problems that can be solved using management science methods and modeled in Excel. In this course, we start from the basics of spreadsheet design and work our way up to broader mathematical optimization modeling. Many airlines, banks, and technology companies could not operate today as they do without the skills and techniques taught in this course. In this first module, we begin by introducing a relatively simple example of a mathematical model which we will use as our platform to build off of for more complicated applications later in the course.

Course Content
Week 1	INTRODUCTION TO EXCEL: BASIC AND BEST PRACTICES
Week 2	INTRODUCTION TO EXCEL: BASIC AND BEST PRACTICES (Continued)
Week 3	“WHAT IF” ANALYSIS IN EXCEL
Week 4	“WHAT IF” ANALYSIS IN EXCEL (Continued)
QUIZ 1
Week 5	DIGITAL ANALYSIS THROUGH REGRESSION AND NPV
Week 6	DIGITAL ANALYSIS THROUGH REGRESSION AND NPV (Continued)
Week 7	LINEAR PROGRAMMING
Week 8	LINEAR PROGRAMMING (Continued)
QUIZ 2
Week 9	TRANSPORTATION AND ASSIGNMENT PROBLEMS
Week 10	TRANSPORTATION AND ASSIGNMENT PROBLEMS (Continued)
Week 11	INTEGER PROGRAMMING AND NON LINEAR PROGRAMMING
Week 12	INTEGER PROGRAMMING AND NON LINEAR PROGRAMMING (Continued)
PROJECT REPORT

Business Analytics with Excel: Elementary to Advanced Excel

Aim & Summary

Course Certification