MS-Project training (Microsoft)

Ms-Project training program (VBE-VBA)

Woospeak, language and office training center since 2006 , offers you its expertise for your Microsoft Ms-Project office training . Our experienced trainers will help you improve and master the Ms-Project software. .

Goal: Perfect your skills on Ms-Project software (Microsoft).
Discover the usefulness, limits and constraints of VBE macros.
Maintaining existing macros, I want to intervene in the code generated by the macro recorder.
Deepen my mastery of VBA (Visual Basic Application) in order to develop more personalized projects.
Method: Face to face, telephone, videoconference, e-learning
Prerequisites: I often use Ms-Project and I absolutely master the advanced features.
Public: Anyone with knowledge of MS-Project software
Duration: 2, 4, 6, 8, 10 hours ... adjustable duration as needed
Possible certifications: PCIE

The objectives of your Microsoft Ms-Project training

Our Ms-Project training is one of our training courses in our office catalog. It will help you to master all the features of the Ms-Project software . This training will allow you among other things: to perfect your skills on the Ms-Project software, to discover the utility, the limits and the constraints of VBE macros, to maintain existing macros, to intervene in the code generated by the recorder macros, to deepen my mastery of VBA (Visual Basic Application) in order to develop more personalized projects.
Whatever your basic level, our tailor-made training programs are fully adapted to help you progress.

The program of your Ms-Project training (VBE-VBA)

The content of the Ms-Project training program is organized into 6 major areas, and will be adapted according to your objectives and your needs:


Module 1: Macros sequential commands

  • Create macro per record
  • Create a command button in the toolbar
  • Create a command button in the sheet

Module 2: Intervening in the code

  • The project explorer (management of modules and procedures)
  • Read and comment on the code generated by the recorder
  • Chain macros
  • Provide information to the user

Module 3: Discovery of the VBA (Visual Basic Application) environment

  • Introduction to VBA syntax: variables, objects, properties, methods
  • Submit a procedure to a decision of the user
  • Retrieve and use information provided by the user

Module 4: Basic structures of VBA programming

  • The main Project objects, their properties and methods
  • Communication structures (MsgBox, InputBox)
  • Decision structures (If Then Else, Select Case)
  • Functions (Ucase, Lcase, Format ...)
  • Loop structures (For Next and For Each)

Module 5: A sample planning management application

  • Basic macro recording
  • Automated insertion of planning dates
  • Conditional formatting
  • Error management
  • Workbook event procedures (Open and Before_Close)

Module 6: Research and calculations

  • Do While (Until) Loop
  • Offset () method
  • Function () type procedures
  • Sequence 4
  • Creation of a user interface
  • Creation of a Userform
  • The main controls and their properties
  • Event procedures

Practical work & learning control

If you wish, we can also offer you an office certification such as TOSA. This Ms-Project training is eligible for the CPF (Personal Training Account) .


Ms-Project VBE VBA training program

Microsoft Ms-Project in videoformation, by phone or face to face

As a specialized training organization, Woospeak offers you different training methods:

This MS-Project training can take place at home or within your company.

DISCOVER ALL OURTRAINING METHODS

We organize training sessions wherever you are and everywhere in France

Want to know more ? Please do not hesitate to contact us with any questions.
You can also ask us for a quote on your MS-Project training. .