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. S. Pavan Kumar,
Head, School of Management,
National Institute of Technology Karnataka,
Post: Srinivasanagar, Surathkal, Mangalore - 575025
Karnataka, India.
•       Hot line: +91-824-2474000 (Extn. 4047)
                 +91-0824-2474000 (Extn. 3079)
•       Mobile:   +91 7760020200
•       Email:          pavankumar@nitk.ac.in
                         saraf_pavan@rediffmail.com

Connect with us

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