Basics and Tools In MS Excel and MS Project for Project Managers

Course Info

Length: 1 Week

City: Singapore

Type: In Classroom

Available Dates

  • Apr-08-2024

    Singapore

  • May-13-2024

    Singapore

  • June-10-2024

    Singapore

  • July-08-2024

    Singapore

  • Aug-12-2024

    Singapore

  • Sep-09-2024

    Singapore

  • Oct-14-2024

    Singapore

  • Nov-11-2024

    Singapore

  • Dec-09-2024

    Singapore

Dates in Other Venues

  • Apr-01-2024

    Kuala Lumpur

  • Apr-01-2024

    Istanbul

  • Apr-08-2024

    Paris

  • Apr-15-2024

    Dubai

  • Apr-15-2024

    Barcelona

  • Apr-22-2024

    London

  • Apr-22-2024

    Kuala Lumpur

  • Apr-29-2024

    Amsterdam

  • Apr-29-2024

    Istanbul

  • May-06-2024

    Istanbul

  • May-06-2024

    Kuala Lumpur

  • May-13-2024

    Paris

  • May-20-2024

    Dubai

  • May-20-2024

    Barcelona

  • May-27-2024

    Amsterdam

  • May-27-2024

    London

  • June-03-2024

    Istanbul

  • June-03-2024

    Kuala Lumpur

  • June-10-2024

    Paris

  • June-17-2024

    Dubai

  • June-17-2024

    Barcelona

  • June-24-2024

    Amsterdam

  • June-24-2024

    London

  • July-01-2024

    Kuala Lumpur

  • July-01-2024

    Istanbul

  • July-08-2024

    Paris

  • July-15-2024

    Barcelona

  • July-15-2024

    Dubai

  • July-22-2024

    Kuala Lumpur

  • July-22-2024

    London

  • July-29-2024

    Istanbul

  • July-29-2024

    Amsterdam

  • Aug-05-2024

    Kuala Lumpur

  • Aug-05-2024

    Istanbul

  • Aug-12-2024

    Paris

  • Aug-19-2024

    Barcelona

  • Aug-19-2024

    Dubai

  • Aug-26-2024

    Amsterdam

  • Aug-26-2024

    London

  • Sep-02-2024

    Istanbul

  • Sep-02-2024

    Kuala Lumpur

  • Sep-09-2024

    Paris

  • Sep-16-2024

    Barcelona

  • Sep-16-2024

    Dubai

  • Sep-23-2024

    London

  • Sep-23-2024

    Kuala Lumpur

  • Sep-30-2024

    Istanbul

  • Sep-30-2024

    Amsterdam

  • Oct-07-2024

    Kuala Lumpur

  • Oct-07-2024

    Istanbul

  • Oct-14-2024

    Paris

  • Oct-21-2024

    Dubai

  • Oct-21-2024

    Barcelona

  • Oct-28-2024

    London

  • Oct-28-2024

    Amsterdam

  • Nov-04-2024

    Istanbul

  • Nov-04-2024

    Kuala Lumpur

  • Nov-11-2024

    Paris

  • Nov-18-2024

    Barcelona

  • Nov-18-2024

    Dubai

  • Nov-25-2024

    London

  • Nov-25-2024

    Amsterdam

  • Dec-02-2024

    Istanbul

  • Dec-02-2024

    Kuala Lumpur

  • Dec-09-2024

    Paris

  • Dec-16-2024

    Barcelona

  • Dec-16-2024

    Dubai

  • Dec-23-2024

    London

  • Dec-23-2024

    Kuala Lumpur

  • Dec-30-2024

    Istanbul

  • Dec-30-2024

    Amsterdam

Course Details

Course Outline

5 days course

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

 

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

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

 

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

 

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