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

Course Info

Length: 1 Week

Type: Online

Available Dates

Fees

  • Dec-30-2024

    1,550

  • Jan-06-2025

    1,550

  • Feb-03-2025

    1,550

  • Mar-03-2025

    1,550

  • Apr-07-2025

    1,550

  • May-05-2025

    1,550

  • June-02-2025

    1,550

  • July-07-2025

    1,550

  • Aug-04-2025

    1,550

  • Sep-01-2025

    1,550

  • Oct-06-2025

    1,550

  • Nov-03-2025

    1,550

  • Dec-01-2025

    1,550

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