Spreadsheet Modelling for Business

Course Name: 

Spreadsheet Modelling for Business (MBA718)

Programme: 

MBA

Semester: 

First

Category: 

Foundation Courses

Credits (L-T-P): 

(2-0-2) 2

Content: 

Introduction to Spreadsheet- Functions of Spreadsheet- Spreadsheet Uses and Limitations- Entering Formulas into Excel- Control-Flow Statements-Charts in Excel- Dash Board- Sensitivity Analysis- Creating Tornado Diagrams- Pivot Tables and Charts- Modeling with IFPS and VBA- Matrix Operations - Regression Analysis- Macros - Recording and Editing- Lookup and Reference Functions- DCF-NPV and IRR Functions- Data Tables- Database Manipulation- Workbook Sharing & Merging- Customizing Toolbars And Menus- User-Defined Functions- Matrix Operations In Excel- Auditing Tools

Department: 

School of Management
 

Contact us

Dr. Sheena
Head, School of Humanities, Social Sciences and Management,
National Institute of Technology Karnataka
Post: Srinivasanagar, Surathkal, Mangalore - 575025
Karnataka, India.
Hot line: +91-0824-2474000 (Extn. 4047)
              +91-0824-2474000 (Extn. 3236)
Mobile:   +918277028734
Email:     hodsom@nitk.edu.in 
          

Connect with us

We're on Social Networks. Follow us & get in touch.