Advanced Excel skills for project management

Create a cost effective project management tool with Excel! All organizations have the Excel software and the majority of them have projects to manage. Excel can be used beneficially and offer a solution for a more comprehensive planning and control of the projects.


Our training will allow you to optimize the features and incorporate best practices
in your project management.



OBJECTIVES
> To create an effective planning tool
> To manage and control the projects efficiently
> To integrate the key elements of the project
management process
> To make it a collaborative tool

WHO IS THIS TRAINING COURSE FOR
Project managers who want to use Excel for better planning and managing their projects. Also suitable for engineers, architects, accountants
and other consultants.



OBJECTIVES
  • Learn to handle and import information from your database
  • Learn the useful formulas in project management
  • Learn how to create an Excel file with all the necessary elements
    for your project management
  • Learn how to use presentation tools
  • Build ergonomic and user-friendly designs
  • Knowing the design mistakes to avoid
  • Spread your useful reference tools to create
    your project management files
  • Maximize Excel's potential in a project context
  • Build a project plan with Excel
  • Create dynamic links between different information
  • Get projects off to a good start
  • Facilitate planning and creating projects
  • Centralize project information
  • Create easy visuals
  • Facilitate collaboration
  • Standardize practices


    DETAILED TRAINING COURSE CONTENTS
    Note: content elements will not necessarily be applicable to all participants.
    Their relevance will vary according to the nature of their projects.

    • Revision of the main project management processes
    • Create different modules
      • The charter and the main phases
      • The SDP
      • The Gantt chart
      • The budget
      • The risk register
      • The change's modules
      • The synthesis module
      • The control and monitoring module
      • The closing module
    • The principles of progress reviews
    • Give the right access rights
    • Integrate Excel to the current time management tool
    • Import data from:
      • Access
      • Excel
      • SQL
      • PowerPivot
    Use the useful formulas in project management:
    • Calculations Formulas
    • Research Formulas
    • Conditional formulas
    • Statistics formulas

    Use basics and advanced filters
    Data Validation (drop-down menu)
    Present data
    • Conditional formatting
    • Pivot tables
    • Presentation Tools



    PEDAGOGICAL APPROACH
    • Guided practical exercises, performed independently on a computer
    • Theoretical content
    • Interactive presentations

    TRAINING COURSE MATERIAL
    • Participant Manual
    • Sample files

    Our mobile classroom

    15 laptops are available to participants in the training room. Each computer
    is programmed so that all functions are displayed in full screen mode. Participants are then working in a similar computing environment to the one they use at work. Our mobile classroom also gives us the ability to provide training internally in your company.



    Training

    Date

    City

    Location

    Excel avancé pour la gestion de projets
    10 december 2018
    Français
    Montréal
    Directions
    Excel avancé pour la gestion de projets
    23 may 2019
    Français
    Québec
    Directions




    Newsletter
    Stay tuned for new services and training