- About Us
- Introduction
- Srishyla Educational Trust
- G M University
- GMU- Campus
- GMU Logo, Flag and Mascot
- GMU- Anthem
- Vision, Mission, Values, and Objectives
- Leadership
- Statutory Committees
- University Documents
- Organisation Structure
- University Best Practices
- Information and Communication Technology (ICT)
- Learning Management System (LMS)
- Human Resources (HR)
- Collaboration and Cooperation
- Campus life
- Events
- Proctorial System
- Student Placements
- IQAC
- Assessment
- Careers
- Contact Us
- Home About Us
- Introduction
- Srishyla Educational Trust
- G M University
- GMU- Campus
- GMU Logo, Flag and Mascot
- GMU- Anthem
- Vision, Mission, Values, and Objectives
- Leadership
- Statutory Committees
- University Documents
- Organisation Structure
- University Best Practices
- Information and Communication Technology (ICT)
- Learning Management System (LMS)
- Human Resources (HR)
- Collaboration and Cooperation
- Campus life
- Proctorial System
- Student Placements
- Contact Us
- Careers
- Programs
- Admissions
- Academics
- Research
- Skill Development
- Con, Innov.&Entr
- Library
- Grievances
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
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.| 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 |
|
Course Certification
Certificate will have your name, photograph and the score in the final exam with the breakup. It will have the logos of GMU and company handling the course.