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.
Duration
1 day
Schedule
See training dates for details
Regular fee
$540
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$485
Objectives of the training
By the end of this course, you'll be able to use Excel's features to manage your projects.Targeted audience
Project managers, engineers, architects, accountants and other consultants.Prerequisite
Be an advanced Excel userTrainers
Course architecture
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
- Charter and main phases
- Project breakdown structure (PDS)
- Gantt chart
- Project budget
- Risk register
- Change module
- Synthesis module
- Monitoring and control module
- Closing module
Principles of progress reviews
How to give the right access rights
I
ntegrating Excel into the time management tool
Importing data from
- Access
- Excel
- SQL
- PowerPivot
- Access
- Excel
- SQL
- PowerPivot
Use formulas applicable to project management
- Calculation formulas
- Search formulas
- Conditional formulas
- Statistical formulas
- 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
- Conditional formatting
- Pivot tables
- Presentation tools
Pedagogical details
Training architecture
-Theoretical content -Interactive presentations -Demonstration of proposed methods -Guided and independent practical exercises on a computer workstation
Type of training
Skill development
Skill development and knowledge integration
Decision support
Basic knowledge
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
1 day
Schedule
See training dates for details
Regular fee
$540
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$485
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote