Error message

  • Deprecated function: Methods with the same name as their class will not be constructors in a future version of PHP; views_display has a deprecated constructor in require_once() (line 3080 of /home/websites/hssm/includes/bootstrap.inc).
  • Deprecated function: Methods with the same name as their class will not be constructors in a future version of PHP; views_many_to_one_helper has a deprecated constructor in require_once() (line 113 of /home/websites/hssm/sites/all/modules/ctools/ctools.module).

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

K B Kiran, Professor and Head
School of Management, NITK, Surathkal
Srinivasanagar P.O, Mangalore - 575025
Karnataka, India.

  • Hot line: +91-824-2474000 (Extn. 3226)
                   +91-0824-2474000 (Extn. 3079)
  • Mobile:    +91 9886585458

Connect with us

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