By geetasingh on 08 Sep 2020
English
Programmes Participant Benefits:
Participants will be able to learn:
• Performing complex calculations more efficiently, using various Excel functions.
• Organizing and analyzing large volumes of data.
• Creating reports.
• Consolidating and managing data from multiple workbooks.
Programmes Course Coverage:
• Building logic with IF & Nested IF statements
• Lookup & Index Functions
• Summarizing & slicing & dicing with Pivot Tables
• Goal Seek, Solver & Scenario Manager
• Sensitivity Analysis
• Building UI with Data Forms
• Advance financial functions IRR, NPV, PMT, IPMT, etc
• Consolidating and managing data from multiple workbooks
• Sorting and Filtering
• Advance Filter
Programmes Methodology:
Lecture, Discussion and Hands-On.
Programmes Who May Attend:
Executives of level E1-E7 from NTPC and other organizations of similar background.
Programmes Coordinators:
Geeta Singh
Programme Overview and Objective:
The program has been designed for executives who are already familiar with the basics of Microsoft Excel, and who want to learn more advanced feature of Excel. Upon completion of this programme, participants will be able to perform complex calculations more efficiently, organize and analyze data in worksheets, create MIS reports, and automate various tasks.
Programmes Category:
Programmes Venue:
PMI-Noida
Programmes Residential/Non-residential:
Programmes Start Date:
Wednesday, September 9, 2020
Programmes End Date:
Friday, September 11, 2020
Programmes No of Days:
3
Programmes Category Email:
Programme ID:
50127919
New Programme:
No
Training Coordinator Employee Number:
1975
Training Coordinator Mobile Number:
9650992451
Scheduled/Unscheduled/Drum/Sponsored:
Organizer - Abbreviation:
PMI
Organizer - Name:
POWER MANAGEMENT INSTITUTE
Program Status:
Need Based/Competency Based: