Excel for Project Managers

Become an expert by mastering Excel tools & techniques needed to become the finest Project Manager in town.

ABOUT THE COURSE

The course has been designed in a manner that it’ll assist you in learning about the Advanced Excel functions and tools and techniques that’ll help improve and increase efficiency while analyzing your Project Management Activities.

LEARNING OUTCOMES?

This course will help project managers & business analysts save significant amount of their time in project management activities, analyze better and plan more effectively in the context of finding solutions to their existing problems.

TARGET AUDIENCE

This program is considered to be tailor-made to suit the needs of:

• Project Managers
• Business Analysts
• Project Leads
• Fund Managers
• Other executives currently working in the related fields of Project Management (reporting & financial analysis) where Excel skills are needed

CAREER BENEFITS

• Learn methodically how to estimate time needed and cost to be incurred to complete a project
• Start with understanding the basics and fundamentals of finance and grasp different measures and parameters that would help project managers know when a project that is underway, would become viable
• Grasp how to build effective Dashboards that will eventually help you follow your project on real time
• Learn how to use and perform scenario analysis
• Comprehend and build models based on Earned Value Management
• Learn how to effectively put into practice planning, tracking and reporting of projects in real time
• Learn from advanced subjects like Monte Carlo Simulation and how it can assist in effective monitoring

PRE- REQUISITES

Being adept with various aspects of Microsoft Excel (preferably Excel 2007 or 2010) is a prerequisite for this program.

COURSE CURRICULUM

The program basically focuses on three parts or modules in which the entire curriculum has been split. These include:

• Planning & Budgeting of a project that is underway
• Tracking the progress on the project in-hand
• Reporting and effectively managing the project and analyzing the results of the same

It will systematically teach you how to derive solutions to the existing problems at hand using a more accountable measure involved in project management.

The real-life case studies will assist in the learning process and enable you to understand the concept in a better and transparent manner.