Every organization has Excel, and most of them have projects to manage. Excel can be used to advantage, offering a comprehensive solution for project planning and control. Our training will enable you to optimize its functionalities and integrate project management best practices.
Objectives
By the end of this course, you'll be able to use Excel's features to manage your projects.
Is it for you ?
Project managers, engineers, architects, accountants and other consultants.
Prerequisite
Have taken or have the knowledge of the CH128 essential features training course.
Content
Main project management processes
Creation of the various modules
- Charter and main phases
- Project breakdown structure (PDS)
- Gantt chart
- Project budget
- Risk register
- Change module
- Synthesis module
- Monitoring and control module
- Closing module
See more + / -
Principles of progress reviews
How to give the right access rights
Integrating Excel into the time management tool
Importing data from
- Access
- Excel
- SQL
- PowerPivot
Use formulas applicable to project management
- Calculation formulas
- Search formulas
- Conditional formulas
- Statistical formulas
How to use basic and advanced filters
Data validation (drop-down list)
Data presentation
- Conditional formatting
- Pivot tables
- Presentation tools.
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote