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.