- It is a practical Excel based understanding of Project Management with Excel
- It focuses on capital implication of Modeling Decisions
- You will understand the concepts from scratch
- Step by step tutorials and templates will be provided
Target Audience
- This course is aimed at Project Managers, Business 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
- Should be familiar with various aspects of Excel (preferably Excel 2007 or 2010)
- 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
Pedagogy
- Duration
- 20 Hrs of Excel for Project Managers training
- Hands-on Case Study (Real Life) based learning
- Participants create models from scratch
- Step by Step Instruction on Creating the model
- Practicing Faculty hand holds the participants
Materials
- Access to Step by Step Model Templates
- Example workbooks – both Empty & Completed ones
- 24x7 Online Access* to Course Material (Unlocked Excel Models, Presentations, etc.)
- Forums to interact with faculty & fellow students
- Certificate of Participation for all the Candidates
- * Access is valid for 6 months
- Pristine is a leader in Financial modelling training having trained 2000+ participants across sectors (FMCG, Infrastructure, Real Estate, Oil and Gas, Internet Startups) and geographies (40+ countries).
- Conducted serves a list of reputed corporate clients such as JP Morgan, Bank of America, Mizuho Bank, E&Y and B-schools such as IIM C, IIM I, NUS Singapore, FMS in the area of financial modelling.
- Pristine is also a leader in finance Certifications trainings such as CFA (registered with CFA Institute), FRM (Registered with GARP) and PRM (Registered with PRMIA).
- Pristine Prides itself to provide "Value for Money Training courses" that respect the time commitment of professionals.
