Spreadsheets and use of spreadsheets in the process of Management Decision Making SEMINAR FOR WEEK 01 Class Discussion: How does spreadsheet help in Management Decision Making? How does the various functions in Ms-Excel help in the process of Management Decision Making? What is decision modelling? READINGS FOR WEEK 01 Tennent, John & Friend, Graham (2010), Guide to Business Modelling, First South Asian Edition 2010, Chapter 1& 2 Mayes, Timothy R., & Shank Todd M.(2012), Financial Analysis with Microsoft Excel, South Western, Cengage Learning, Chapter 1& 2 Whigham, David (2011), Business Data Analysis using Excel, Indian Edition, Oxford University Press, Chapter 1& 2 Winston, Wayne L. (2010), Excel-Data Analysis and Business Modeling, Microsoft Press, Chapter 1& 2 WEEK 2: Business Modelling and Business Plans – Decisions Using Ms-Excel - Business Data Analysis Using Excel Learning Outcome Having attended this lecture, students should be able to understand How Ms-Excel functions help in the various Decision Making processes What are the various types of functions in Ms-Excel How the Ms-Excel Functions are applied in real world problems What are the applications and uses of Ms-Excel Functions in Business Modeling What are the various tools and techniques in MS-Excel which help us in Management Decision Making and Business Modeling What are the various key factors and variables which must be reflected in business plan How Ms-Excel can help us in preparing projected financial statements so as to produce future projections of finance
Spreadsheets and use of spreadsheets in the process of Management Decision Making SEMINAR FOR WEEK 01 Class Discussion: How does spreadsheet help in Management Decision Making? How does the various functions in Ms-Excel help in the process of Management Decision Making? What is decision modelling? READINGS FOR WEEK 01 Tennent, John & Friend, Graham (2010), Guide to Business Modelling, First South Asian Edition 2010, Chapter 1& 2 Mayes, Timothy R., & Shank Todd M.(2012), Financial Analysis with Microsoft Excel, South Western, Cengage Learning, Chapter 1& 2 Whigham, David (2011), Business Data Analysis using Excel, Indian Edition, Oxford University Press, Chapter 1& 2 Winston, Wayne L. (2010), Excel-Data Analysis and Business Modeling, Microsoft Press, Chapter 1& 2 WEEK 2: Business Modelling and Business Plans – Decisions Using Ms-Excel - Business Data Analysis Using Excel Learning Outcome Having attended this lecture, students should be able to understand How Ms-Excel functions help in the various Decision Making processes What are the various types of functions in Ms-Excel How the Ms-Excel Functions are applied in real world problems What are the applications and uses of Ms-Excel Functions in Business Modeling What are the various tools and techniques in MS-Excel which help us in Management Decision Making and Business Modeling What are the various key factors and variables which must be reflected in business plan How Ms-Excel can help us in preparing projected financial statements so as to produce future projections of finance