Duration: 2 Days
This 2 day course will help project managers and analysts save a substantial amount of time in their project management activities, learn better solutions to their existing problems and help them plan more effectively.
This hands-on course is divided in three main modules, Planning & Budgeting, Tracking and Reporting. It will systematically teach you how to tackle the different problems involved in project management with the help of real life case studies.
Why Excel for Project Managers
- Highly required for Project Managers involved in Planning, Estimation, Budgeting, Tracking and Reporting
- Learn systematically to forecast time and cost to complete a project
- Start from the basics of finance and learn different measures that help project managers understand when a project would become profitable
- Learn how to create effective Dashboards which will eventually help you track your project on real time
- Learn how to implement scenario analysis
- Will understand and create models based on Earned Value Management
- You will learn how to effectively implement planning, tracking and reporting
- Learn Advanced concepts like Monte Carlo Simulation
Target Audience
- This course is aimed at Project Managers, Analysts, Project Leads and people aiming for various project management roles
- This course also helps project sponsors, people working in reporting & financial analysis of projects
Pre-Requisites
- Participants should be familiar with various aspects of Excel.
Topics
- Estimating IT Services Projects
- Planning for a Project using Excel
- Budgeting and forecasting
- Estimating Break Even Point
- Keeping Track of Resources
- Monitoring Risk
- Risk Analysis & Mitigation
- Keeping Track of Project Budget and Actual expenses
- Tracking Changes to Project Scope
- Project Scope Burndown
- Time Lines
- Critical Path Analysis
- Creating Sales target and analyzing performance
- Commercial Analysis of a Project
- Project Status Dashboards & Status Reporting
- Risk Return Analysis
- Earned Value Management