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