MS Excel and MS Project for Project Managers

The DIXONTECH MS Excel and MS Project for Project Managers course equips professionals with practical and advanced skills to plan, track, and control projects using Microsoft Excel and Microsoft Project. Aligned with PMI standards, the programme enables participants to manage schedules, budgets, resources, and performance dashboards efficiently, improving visibility, accuracy, and decision-making across project lifecycles.

TRAINING TOPICS

• Project planning and scheduling using MS Project

• Task dependencies and critical path analysis

• Budgeting and cost tracking in MS Project

• Advanced Excel for project data analysis

• Dashboards and pivot tables for reporting

• Resource allocation and performance monitoring

• Automated progress tracking and reporting

• Integration between MS Excel and MS Project

BY THE END OF THIS TRAINING COURSE, DELEGATES WILL BE ABLE TO:

• Develop and manage project schedules

• Track progress and control timelines

• Analyse project data using Excel tools

• Allocate and manage project resources

• Forecast budgets and monitor costs

• Report performance visually and clearly

• Integrate Excel and MS Project outputs

TRAINING IS TAILORED TO

• Project managers and team leaders

• PMO analysts and coordinators

• Project planners and schedulers

• Engineers and cost controllers

• Business analysts and consultants

• PMP® certification candidates

TRAINING METHODOLOGY

This DIXONTECH programme combines hands-on software labs, guided exercises, and case-based simulations. Participants practice building schedules, Gantt charts, dashboards, and automated reports using MS Project and MS Excel, ensuring practical application of PMI-aligned project management techniques.

DAY 1

INTRODUCTION TO PROJECT PLANNING AND MS PROJECT ENVIRONMENT

• PMI project management process overview

• MS Project interface and navigation

• Project calendars and parameters setup

• Tasks milestones and dependencies creation

• Task modes and scheduling constraints

• Basic Gantt chart development

• Saving and sharing project plans

DAY 2

TASK SCHEDULING RESOURCES AND COST MANAGEMENT

• Task linking and critical path analysis

• Resource assignment and workload management

• Resource levelling and over allocation resolution

• Baselines setup and performance tracking

• Cost estimation and project budgeting

• Tracking actuals variances and earned value

• Advanced task and milestone control

DAY 3

ADVANCED MS PROJECT TOOLS AND ANALYSIS

• Custom views filters and tables

• Custom fields formulas and calculations

• Progress tracking with baseline updates

• Advanced reports and visualisations

• Multi project and shared resource management

• Data exchange between Project and Excel

• Automated reporting techniques

DAY 4

EXCEL FOR PROJECT DATA ANALYSIS AND REPORTING

• Advanced Excel functions for projects

• Data structuring using tables

• Pivot tables for performance analysis

• Pivot charts and progress visualisation

• KPI dashboards and variance analysis

• Conditional formatting and alerts

• Linking Excel reports with MS Project

DAY 5

INTEGRATION AUTOMATION AND REPORTING EXCELLENCE

• Integrating MS Project with Excel

• Automating updates using Power Query

• Dynamic dashboard creation

• Consolidating multi project reports

• Visual storytelling for stakeholders

• PMI aligned reporting best practices

• Final case study and assessment