Advanced MS-Excel: Applications in HR, Finance and Marketing

Introduction

This is the proposal for conducting MDP in Advanced MS Excel for managers. As MS Excel is widely used in industry, there are certain features which are required to be used by executives working in middle or senior position in different functional areas of HR, Finance or Marketing

Objectives of the MDP

MDP aims to cover the following key features;

• Why MS Excel
• Key management areas where MS Excel can be applied
• How MS Excel can be customized to execute various executive level tasks
• How MS Excel can be integrated with other Office products to utilize the existing data

Programme Contents

• Understanding the various add-on operations in the MS excel such Analysis tool pack
• Understanding the linkages of data in various sheets
• A quick glimpse of programming in MS Excel
• Demonstration of some of the advanced tricks in MS Excel
• Handling complex data in MS Excel
• Formatting the Data in MS Excel by means of String functions, date functions, etc.

Pedagogy

Mix of lectures, PPTs, hands on exercise and case studies

For Whom

• Senior and middle level Executives
• Team Leads
• Entrepreneurs

Duration:

One day.

Faculty Incharge

Mr. Sanjive Saxena, Mr. Devesh Lowe & Ms. Disha Grover