Decision Making using MS Excel














  • PREFACE

    With advancement in today’s technology, companies can collect tremendous amounts of data with relative ease. Indeed, companies have more data than they can capture and process. However, the data are meaningless until they are processed and transformed into useful information. This programme illustrates in a practical way a variety of methods, from simple to complex, to help you analyze data sets and uncover important information. In many business contexts, data analysis forms the core and basic step. Acting on the solution and the information provides to make good decisions forms the critical next step.

    MS Office 2013 is being used by managers in most of the organizations. Excel, the spreadsheet component of MS Office 2013, is widely used throughout the business world today for processing quantitative data and developing analytical solutions. The ability to build decision support systems (DSS) based on these spreadsheet solutions facilitates knowledge management, thereby increasing information utilization within an organization.

    Despite the wider usage of spreadsheets, because of a manager’s unfamiliarity with some simple yet sophisticated Excel techniques, most managers receive only a fraction of the benefits they could derive from using Excel in their day-to-day decision making.

  • PROGRAMME OBJECTIVES

    Enabling managers to understand and apply

    • Data analysis techniques to process raw data into useful information
    • Decision-making tools to solve a business problem.
    • Built in features of Excel 2013 to solve data analysis problems.
    • Managing a spreadsheet development project
  • CONTENTS

    The three days of spreadsheet modeling with Excel includes theory and practice on these topics:

    • Referencing schemes: Relative, absolute and circular references
    • Ranges, Range name, Named parameters
    • Common Excel errors and how to deal with them
    • Functions and formulas: Array formulas; manipulating ranges; Matrix multiplication
    • Charting: effective presentation of business data, types of charts and their importance
    • What if analysis: Goal Seek, Scenario Manager, Data Table
    • Registration of Principal Employer and Licensing of the Contractor;
    • Optimization problem while modeling the worksheet
    • Drilling down and rolling up: Pivot Tables, Subtotals
    • Summarizing data in one worksheet from multiple worksheets
    • Securing worksheets while sharing
    • Managerial Tips: Do’s and Don’ts for Managers
    • Checklist for Organisations/Principal Employers etc.
  • METHODOLOGY

    Lecture, demonstration, hands-on exercises and project development and presentation.

  • WHO SHOULD ATTEND

    Junior/ Middle/ Senior level managers of private/ public sectors eager to learn spreadsheet modeling for an improved data analysis, presentation, and decision-making.

  • PROGRAMME DIRECTORS

    Dr. Pradeep Kumar, a Ph.D. from Hyderabad Central University in Computer Science and M. Tech from B.I.T. Mesra, Ranchi in Computer Science is an academician with IIM Lucknow. He was associated with SET Labs, Infosys Technologies Ltd as a researcher. He served the Institute for Development and Research in Banking Technology (IDRBT), Established by Reserve Bank of India, as a Research Fellow. His area of Interest includes Data Warehousing, Data Mining, Web Mining, and Text Mining. To his credit, he has more than 20 authored research papers in international journals and Conferences of repute. He can be reached at pradeepkumar@iiml.ac.in.

  • PROGRAMME FEE

    Residential: The programme fee for residential participant is @ Rs 45,000/- plus GST @ 18% or as applicable as per the Govt. of India guidelines. The fee includes the cost of boarding and lodging, tuition, course material, use of the Institute Library, Computer Center, and other infrastructural facilities, etc.

    Non-residential: The programme fee for non-residential participant is @ Rs 41,500/- plus GST @ 18% or as applicable as per the Govt. of India guidelines. The fee includes the cost of food during the course of the programme, tuition, course material, use of the Institute Library, Computer Center, etc

    EARLY BIRD DISCOUNT Nominations received along with the programme fee up to 30 days before the programme date will be entitled to an early bird discount of 10%.

    GROUP DISCOUNT A group discount of 10% on programme fee is admissible provided an organization nominates, and attends a minimum 5 or more of its executives for the programme. Organizations sponsoring minimum 5 or more executives for the programme may avail both the discounts subject to a maximum discount of 20% provided the nominations along with the fee is received at our end 30 days before the programme date

register your interest







I would like IIML representative to contact me

MDP Contact No’s
0522-669-6288/82/83

Venue: IIM Lucknow campus Residential Fee (excluding GST) : Rs. 45,000/-
Last date to apply :Oct 23, 2017 Residential Early Bird Fee (excluding GST) : Rs. 40,500/-
Start Date : Nov 06, 2017 Non-Residential Fee (excluding GST) : Rs. 41,500/-
End Date : Nov 08, 2017 Non-Residential Early Bird Fee : Rs. 37,350/-

Last date for Availing Early Bird Discount (10%) : Oct 05, 2017

Download Brochure

Top

Top