Course description
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 half-day 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.
Upcoming start dates
Suitability - 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 membersp>
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.
Outcome / Qualification etc.
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
Training Course Content
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
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
Request info
London Premier Centre
London Premier Centre is a UK leading training provider based in London and specialises in international short courses. Our inspiring, comprehensive portfolio of more than 400 professional development courses and seminars covers a wide range of professions from Administration, Leadership,...