INTRODUCTION
The "Basics and Tools in MS Excel and MS Project for Project Managers" training is designed to provide project managers with the knowledge and skills to use Microsoft Excel and Microsoft Project effectively in managing their projects. The halfday training will cover the basics of these tools and their most commonly used features.
Participants will learn how to use these tools to organise, analyse, and visualise project data and create project plans and schedules.
OBJECTIVES
By the end of this training, participants will be able to:
Understand the basic features of MS Excel and MS Project and their role in project management
Apply basic formulas and functions in Excel for project data analysis and visualisation
Create project plans and schedules using MS Project
Monitor and track project progress using MS Project
Identify the appropriate tool and features to use based on their project requirements
WHO SHOULD ATTEND ?
A training on "Basics and Tools in MS Excel and MS Project for Project Managers" would be appropriate for project managers or other professionals who are involved in managing projects and want to learn or enhance their skills in using Microsoft Excel and Microsoft Project.
Microsoft Excel is a widely used spreadsheet program that can be used for tasks such as budgeting, data analysis, and project planning. Project managers may find it especially useful for creating project schedules, tracking project progress, and managing project resources.
Microsoft Project is a project management software that is designed specifically for managing complex projects. It allows project managers to create and manage project schedules, track project progress, and collaborate with team members.
Therefore, the training would be useful for individuals who are new to using Microsoft Excel or Microsoft Project, as well as those who have some experience but want to improve their skills. This might include project managers, team leaders, business analysts, or other professionals who are responsible for planning, executing, and monitoring projects.
COURSE OUTLINE
Day 1
Introduction to MS Excel and MS Project for Project Managers
Introduction to MS Excel and MS Project
Understanding the role of these tools in project management
Understanding Excel interface and key features
Basic formulas and functions for project data analysis
Organising and visualising project data using Excel
Day 2
Advanced MS Excel for Project Managers
Advanced formulas and functions for project data analysis
Creating and formatting charts for project data visualisation
Introduction to data validation and conditional formatting
Day 3
MS Project Basics for Project Managers
Understanding MS Project interface and key features
Creating project plans and schedules in MS Project
Tracking and monitoring project progress using MS Project
Day 4
Advanced MS Project for Project Managers
Creating custom fields and views in MS Project
Creating multiple project plans and linking them together
Introduction to earned value management (EVM) in MS Project
Day 5
Integration of MS Excel and MS Project for Project Managers
Importing project data from Excel to MS Project
Exporting project data from MS Project to Excel
Using MS Excel to enhance project data visualisation and analysis
