Description
Course Overview
This Advanced Excel for Project and Programme Managers in the Public Sector Training Course is designed for project and program managers to enhance their efficiency, improve project outcomes, and save time by using Excel to tackle key aspects of project management such as planning, budgeting, tracking, and reporting.
Participants will develop skills to forecast project timelines and costs, track performance, and generate insightful reports using advanced Excel tools, helping them manage public sector projects effectively.
Course Details
-
Duration: 10 Days
-
Level: Advanced
-
Mode: In-person / Virtual
Who Should Attend?
This Advanced Excel for Project and Programme Managers in the Public Sector Training Course is ideal for:
-
✅ Project Team Leaders in government projects
-
✅ Project Management Staff
-
✅ Team Leaders
-
✅ Project Sponsors
-
✅ Managers of Project Portfolios
Course Objectives
By the end of this Advanced Excel for Project and Programme Managers in the Public Sector Training Course, participants will have the skills to:
-
✅ Forecast time and cost for project completion using Excel
-
✅ Implement scenario analysis to assess project outcomes
-
✅ Use Earned Value Management (EVM) to track project performance
-
✅ Create interactive dashboards and reports to monitor project progress in real-time
-
✅ Learn Monte Carlo Simulation for risk management and decision-making
Course Outline
📌 Module 1: Introduction to Advanced Excel
🔹 Master Advanced Excel shortcuts for efficient workflow
🔹 Present data using charts
🔹 Analyze data with PivotTables and PivotCharts
🔹 Sort, filter data, and manage references in Excel
🔹 Work with dates for project timelines
📌 Module 2: Advanced Formulas in Excel
🔹 Use advanced logical formulas in Excel
🔹 Work with text formulas and lookup functions
🔹 Automate tasks with macros and VBA programming
📌 Module 3: Schedule and Cost Planning with Excel
🔹 Estimate project scope and cost
🔹 Use Excel for time-limited schedules and cost-limited plans
🔹 Measure schedule and cost performance
🔹 Analyze schedule and cost variances
🔹 Implement methods to manage schedule and cost impacts
🔹 Track, analyze, and report project issues
📌 Module 4: Risk Management Using Excel
🔹 Identify and manage project risks
🔹 Perform qualitative assessments using probability and impact scales
🔹 Conduct quantitative analysis using Monte Carlo simulations, decision trees, PERT, and EMV
🔹 Develop risk response strategies
🔹 Monitor and control project risks using Excel
📌 Module 5: Creation of Dashboards and Reports
🔹 Set up SMART objectives for project success
🔹 Create Gantt charts and milestones
🔹 Build dynamic Excel Gantt chart dashboards
🔹 Track project progress with baseline bars and actual progress bars
🔹 Use KPIs, issues, and risks for reporting
📌 Module 6: Earned Value Management (EVM) in Excel
🔹 Calculate Earned Value (EV), Planned Value (PV), and Actual Cost (AC)
🔹 Use EVM to track schedule and cost performance
🔹 Calculate Cost Performance Index (CPI) and Schedule Performance Index (SPI)
🔹 Generate EVM reports for project stakeholders
📌 Module 7: Monte Carlo Simulation in Excel
🔹 Understand Monte Carlo Simulation for risk assessment
🔹 Set up Monte Carlo models in Excel
🔹 Analyze risk and project uncertainties using Monte Carlo simulation
📌 Module 8: Scenario Analysis and Forecasting
🔹 Use scenario analysis to predict different project outcomes
🔹 Create forecasting models to predict future project performance
🔹 Implement what-if analysis to evaluate potential risks and opportunities
📌 Module 9: Project Budgeting and Financial Analysis in Excel
🔹 Create detailed project budgets and financial plans
🔹 Use Excel to track expenses, cash flows, and resource allocation
🔹 Perform financial analysis to assess project feasibility and profitability
📌 Module 10: Reporting and Presentation
🔹 Design interactive reports and dashboards for stakeholders
🔹 Present project data effectively using Excel’s visualization tools
🔹 Share dynamic reports and presentations with project teams and sponsors