Microsoft project training. Online training Microsoft Project. Completion of the project and the technique of calculating standards after the fact

Cost of education: for individuals - 7,000 rubles. / for organizations - 8,000 rubles. Graduation Certificate:At the end of the course, students receive a certificate from PM Expert - PMI® Global Registered Education Provider, and will be able to credit 8 study hours (PDU / Contact Hours) to pass the PMP® exam and renew the PMP® status.

PDU breakdown by Talent Triangle

technical	strategic	leadership
8	0	0

annotation

The course is designed to teach students the basic skills of working in MS Project Professional and is the first step for further training in working in these programs.

The course covers the most common tasks:

scheduling;
resource planning;
cost planning;
modeling of various scenarios for project implementation;
effective use of MS Project in Russian companies;

Learning outcomes

As a result of studying the course, students will be able to:

Develop a project schedule in MS Project
Develop a project budget in MS Project
Use tools for analyzing options for project implementation

Course trainers

- Head of Oil and Gas Projects Department PM Expert
Alexander Chernobrivets, PME, MCTS - PM Expert Planning, Reporting and Risk Manager

Audience

Microsoft Project tutorial

● MS Project: An Introduction to MS Project

INTRODUCING MS PROJECT

● MS Project: Chapter 1. Installation, launch and configuration

● MS Project: Chapter 2. Tables

● MS Project: Chapter 3. Sorting, Grouping and Filtering Data in Tables

● MS Project: Chapter 4. Gantt Chart

● MS Project: Chapter 5. Network Diagrams

● MS Project: Chapter 6. Calendar and Resource Schedule

● MS Project: Chapter 7. Task and Resource Usage Diagrams

● MS Project: Chapter 8. Views and Forms

PLANNING

● MS Project: Chapter 9. Planning Basics and Planning Preparation

● MS Project: Chapter 10. Work Planning

● MS Project: Chapter 11. Resource Scheduling and Making Assignments

● MS Project: Chapter 12. Additional Information about tasks and resources

● MS Project: Chapter 13. Project cost planning, analysis and optimization of resource utilization

● MS Project: Chapter 14. Analysis and Optimization of Work Plan and Project Cost

● MS Project: Chapter 15. Risk Analysis

● MS Project: Chapter 16. Project Plan Reconciliation: Data Export

● MS Project: Chapter 17. Project Plan Reconciliation: Printing and Making Changes

TRACKING

● MS Project: Chapter 18. Tracking a Project

● MS Project: Chapter 19. Collaboration

● MS Project: Chapter 20. Progress Analysis

● MS Project: Chapter 21. Report Preparation

ADDITIONAL FEATURES

● MS Project: Chapter 22. Standard Edition Features

● MS Project: Chapter 23. Installing and Configuring MS Project Server

● MS Project: Chapter 24. Professional Edition Features

MS Project: INTRODUCTION

INTRODUCTION

At first glance, Microsoft Project seems like another application in the Microsoft Office family with a toolbar like in Word, tables and graphs like in Excel. But the deeper you delve into Microsoft Project, the more differences you will notice.

One of the key differences lies in the narrow scope of the program. While other applications of the Microsoft Office family are focused on a wide range of applications and contain a variety of functions, then MS Project is intended solely for project management.

Another important difference is that it is impossible to work with MS Project without having theoretical knowledge in the field of project management and without knowing the features of this program. Anyone can open Word and prepare a document without first reading a book the size of the one in your hands. Of course, this user will not be able to use styling commands, they may not be able to insert page numbers, etc. into the document, but the document will be ready for printing and can be used. If you open MS Project and try to create a project plan, then without special knowledge you will not be able to get a plan suitable for project implementation.

Thus, if you want to manage projects using MS Project, then you cannot do without studying the theory of project management and the functionality of the program. And the book you are holding in your hands should help you with this.

What will you study

The book will introduce you to MS Project 2002 version. With the release of this version, profound changes have been made to the MS Project family. Whereas the previous version consisted only of the MS Project 2000 desktop application and was supplemented by the MS Project Central server package, now the MS Project family includes three applications: the MS Project Standard and MS Project Professional desktop applications and the MS Project Server. In addition, MS Project Standard and MS Project Server version 2002 have been translated into Russian.

Standard and Professional editions of MS Project are designed to create a project plan, which can then be published on the MS server

MS Project: INTRODUCTION

Project Server for organizing teamwork on a project. With the help of MS Project Server, project team members receive tasks from the manager, report on the progress of their implementation, and delegate them to each other. The project manager, in accordance with the data received from the employees, monitors the progress of work, and the organization's management analyzes the workload of employees and the status of all projects carried out in the organization.

Both Oralce and MS SQL Server could act as the DBMS used by MS Project Central, the predecessor of MS Project Server. MS Project Server

can only use MS SQL Server versions 7 and higher as a DBMS.

The package is intended for joint work on project documents

Share-Point Team Services included in the MS Project Server distribution. This package uses MS SQL Server as a DBMS, and its capabilities are available in both standard and professional editions of MS Project.

Differences between the standard edition and the professional edition

If your organization does not use MS Project Server, then the differences between Standard and Professional editions will not be noticeable, since they are related to the possibilities of using MS Project Server.

The combination of MS Project 2002 Standard Edition and MS Project Server is designed for small teams to work together on projects. The combination of the professional edition of MS Project 2002 and the server is intended for working on projects in a large organization. Therefore, when using the professional edition, the server allows you to carry out the operations necessary for large enterprise, such as centralized storage of project templates and a list of company employees. In addition, the professional version provides tools for automated selection of employees for a project based on their skills, and it is also possible to predict the workload of an enterprise, taking into account certain scenarios of the development of events.

MS Project Server is released in one edition and can be used with standard and professional editions of MS Project 2002, and even with MS Project 2000. Performing professional operations on the server is possible only when using MS Project 2002 Professional.

MS Project: INTRODUCTION

How to choose an edition and what you need to install

If you plan to work with MS Project without using collaboration tools, then you need to install the program in the standard edition. If you are planning joint work over projects in a small group, then the standard edition of the desktop application in combination with MS Project Server will suit you. In this case, you do not need to install the MS SQL Server DBMS, since the delivery of MS Project Server includes its reduced version intended for use with the standard edition.

Finally, if you need to use the corporate capabilities of the package, then install the professional edition of the desktop application and MS Project Server. In this case, you will need to install MS SQL Server version 7 or higher. For analytical operations used in the professional edition, the DBMS must support OLAP, that is, the Analysis Services package must be installed on the MS SQL Server.

What's new in version 2002

First of all, the server side of the product has undergone changes, which has been significantly redesigned. But there were some changes in desktop applications, although they mostly affected the program interface. The most important of these are the appearance of the Project Guide panel (Consultant) and the ability to view MS Project Server pages directly in the MS Project window. Scheduling tools have been enhanced with the ability to save multiple basic plans project and analyze earned value based on alternative task completion percentage data. For a list of new features and links to pages that describe how to work with changed program elements, see the alphabetical index at the end of the book.

How will you learn MS Project 2002

This course is divided into four parts. In the first part, you will get acquainted with the program interface in order to learn the capabilities of the tool with which you will have to work in the future. This does not require theoretical knowledge in the field of project management: you will master the principles of working with tables and diagrams, learn to enter, edit, sort, group and filter data.

In the second part, we will move on to creating project plan... In the lessons of this part, you will create own plan project and at the same time

MS Project: INTRODUCTION

practice planning will study the theory of project management. You will learn how to define the scope of work, how to allocate resources, plan costs and risks, how to distribute a file for approval, and compare project versions.

In the third part, you will learn how to track the project, that is, control the implementation of the project plan and make the necessary changes to the plan in the course of work. In this part of the book, you will learn how to work with MS Project Server and organize collaboration with it. As in the previous part, practical materials will be preceded by theoretical ones. You will learn how to save the original project plan, distribute tasks to employees, organize the collection of progress data, analyze the collected data, and prepare reports.

The fourth part tells about additional features of MS Project 2002. You will learn how to work with important, but not so often used tools

the standard edition of MS Project and how to use the most valuable features of the professional edition and MS Project Server.

Sample files

Each lesson is accompanied by example files, links to which are given in the text. The files are located on the CD that accompanies the book in the \ Bogdanov folder.

In order to use the examples, you need to go to the main menu and enter the EXAMPLES catalog. The examples themselves are in the Samples subfolder, and

after copying the \ Bogdanov folder to the disk, the path to it will look like C: \ Bogdanov \ Samples. Examples are located in subfolders with lesson numbers, for example, lesson 2 files are located in the C: \ Bogdanov \ Samples \ CH02 folder.

In the text of the lessons, links are given only to the file names without specifying the path. For example, if lesson 10 provides a link to example 1.mpp, then this file is located in the C: \ Bogdanov \ Samples \ CH10 folder. Where an author refers to a sample file from another lesson, the folder name is appended to the file name.

In preparing the examples, a step-by-step principle was used, that is, changes are made to the project sequentially from file to file. In addition, the files were created so that when they were opened appearance the project matched the illustrations in the book. We aimed to create such

MS Project: INTRODUCTION

examples that could be used in practice. You can copy the tables, filters, reports, groups, custom fields and views we have created into your project and use it to solve practical problems.

Sample files were prepared in the English version of Microsoft Project 2002 Standard and tested in the localized version. Therefore, when you open these examples in the Russian-language version of MS Project 2002, located on the CD-ROM attached to the book, duplicate names of some views and tables will be displayed in the menu. If you have no problems with English, then you can work with the localized version as if it were in English. To do this, after installing the program, close it and find the Global.mpt file on your disk. One copy will be located in the folder where you install MS Project 2002, and replace the second found copy with the Global.mpt file,

located in the \ Bogdanov \ Samples \ TEMPLATE folder.

There is a list at the end of each part of the book. control questions and assignments. They are grouped by lesson topic, and answers to them can be found in the lesson text. The task files are located in the C: \ Bogdanov \ Samples \ TEST folders with the addition of the part number, for example, the task files for the second part of the book are located in the C: \ Bogdanov \ Samples \ TEST2 folder.

Index file

For your convenience, we have created an index file with which you can quickly download the necessary files with examples. This file is called

index.mpp and is located in the C: \ Bogdanov folder. Opening this file loads the Project Guide panel with a link to view a list of examples for any of the lessons in the course. After selecting a lesson, you will see a list of examples with descriptions. When you click on the name of the example, the file with the example will open in MS Project (Fig. 1.1).

MS Project: INTRODUCTION

Rice. 1.1. After clicking the View button, a dialog for entering the lesson number opens, and after entering the lesson number in the table next to the Consultant panel, links to example files for the lesson with comments are displayed

In addition, using the Project Guide panel, you can view tables with links to the most important MS Project help pages and additional files. software, which can be installed along with MS Project (Fig. 1.2).

Basic terms

In the lessons of the first part of the book, you may come across some terms. We will dwell on them in detail at the beginning of the second part, when you will learn to plan a project, but so that you do not have any questions while reading the first part, we will list the main terms and give their definitions.

MS Project: INTRODUCTION

The project consists of tasks, that is, activities aimed at achieving a certain result. In order for the task to be completed, resources are allocated for it - material (equipment) and workers (employees). Allocating a resource to a task is called an assignment, and a task can have an unlimited number of assignments.

Tasks can be combined into groups (or phases), and a task that combines others is called summary. Completing tasks, that is, tasks whose completion leads to the achievement of an important project result or ends a phase, are called milestones.

A task has a duration, that is, the time it takes to complete it. In addition, the task is characterized by the amount of labor (workload) and the costs (or cost) required to complete it.

MS Project: INTRODUCTION

In a project plan, tasks are linked by dependencies that determine the order in which tasks are executed relative to each other. The duration of the project is the sum of the time intervals from the beginning of the earliest task to the end of the latest, taking into account the dependencies between tasks. If an increase in the duration of a task increases the duration of the entire project, the task is called critical.

If you come across other terms while reading the first part, you can find their explanations using the alphabetical index at the end of the book.

Microsoft Project courses at GTSDPO in Moscow - training in effective planning and project management at all stages: from tracking interrelated business processes to the allocation of resources (personnel, material, time) and preparation of reporting documentation.

Purpose of the course:

develop skills in managing small and large projects using the tools of the Ms Project 2010/2013/2016 application.

Course audience:

administrators and project managers;
employees of companies whose responsibilities include monitoring the implementation of business plans, sales, IT projects, etc.

Learning Outcome

Skill:

install and configure Microsoft program Project;
analyze, optimize, adjust various projects in terms of costs and terms;
implement resource and scheduling planning;

monitor the implementation of projects and prepare final reports;
resolve conflicts related to restrictions;
exchange Ms Project data with other applications;
administer a portfolio of projects in Microsoft Project Professional.
export web page data;
configure and administer the Project Server application.

Basic training requirements:

skills to work with Microsoft Word, Excel, Power Point.

Curriculum of the course

Topic 1. Projects and project management. Project creation.

Classification of projects

Project stages

Building a hierarchical work structure (WBS)

Development of network models

Scheduling by the method of critical path (MCP)

Resource planning of the project

Value analysis

Project execution and control

Creating a new project

Entering a set of works

Task list structure

Estimating task duration

Recurring tasks

Linking tasks

Leading and lagging tasks

Milestone tasks

Types of time constraints

Deadlines.

Topic 2 Project resources.

Resource list definitions

Additional resource characteristics

Resource calendars

Types of tasks

Fixed volume field

Assigning Resources to Project Tasks

Microsoft Project views.

Topic 3. Analysis and optimization of the project plan.

Time analysis

Resource load analysis

Analysis of the project cost.

Topic 4. Implementation and control of the project.

Fixing the baseline of the project

Entering real data on task execution

Monitoring the progress of the project

Print reports and views.

Topic 5. Management of multiple projects.

Inserting an external project into the current project

Creating a link between tasks in different projects

Creating a shared resource pool

Opening Projects Using a Shared Resource Pool

Modifying the shared resource pool file.

Topic 6. Export of the project plan.

Copying diagrams to MS Office files

Export of the plan to files of other formats.

We are ready to conduct training for Microsoft Project, as well as provide advice on using Project to solve your business problems. Moreover, you do not have to go for new knowledge in The educational center: we organize training over the Internet using modern means conference calls. You can order individual consultations, or training for a small group of specialists from your organization.

Why MS Project courses don't work

As a result of communication with many Brise clients, we have developed an understanding of why traditional Microsoft Project group courses are likely to be of little help to most of their participants.

The trainer has a standard course program in advance, in which it is impossible to take into account the different level of training of the group members, as well as the differences in learning goals that they set for themselves. This problem manifests itself especially sharply when training is not corporate, and a group of employees from different organizations gathers.
With a large number of students, the trainer does not have the opportunity to pay enough attention to work issues and the difficulties that arise in the learning process for each of them. It sounds paradoxical, but the more the trainer earns on teaching the group, the worse he will teach each of its participants.
Usually the courses are held only for several days in a row, during which the teacher tries to "load" a lot of information into the listener at once, with very limited practice and the impossibility of comprehending this information in practice. A stunned student may leave a happy comment immediately after the course, but after a while it turns out that he has learned very few skills, or not those that he will need in practice.
In the worst case, as part of a project management course, the training is not conducted in a computer classroom, but in front of a whiteboard and a projector screen, and students do not get any practice of using the Project program at all.

Which approach to learning is more effective

Several short workshops instead of one long one... Our seminars last no more than 2 hours. At the same time, the breaks between them should be several working days, so that the listener can master the acquired knowledge in practice.

Small groups... In group training, we only allow a maximum of five people per group, all from the same organization. This will allow employees to share their experience with each other and help develop common approaches to further work.

No trips to the training center... In the 21st century, with the general availability of the Internet, it is an unaffordable luxury to spend as much time on a trip to and from class as the seminar itself.

Who conducts the training: our experts

We offer one-on-one advice from Microsoft Project experts who do not specialize in training but have extensive experience in the practical use of the product. Brise experts:

Implement MS Project in organizations of various industries;
Write articles about using Project in project management, which are published, including on our website;
Answer numerous questions on one of the main Russian-speaking Project forums;
Solve complex technical problems, including when interacting with Project developers;
Additional components for MS Project are being developed.

Experts of such qualifications, according to our estimates, are no more than 30 people in the entire CIS, but we offer individual consultations for three of them with hourly payment at the price of an ordinary dentist's services.

Cost of education - 2 500 rubles per hour, regardless of the number of participants (from one to 5 people). Compared to other popular courses, one-to-one tuition of 3 hours or more may be more beneficial than a whole course.

Project training and consulting topics

The training program is individual for each student or group, and is drawn up based on the results of a preliminary interview. We offer the following popular and important topics that can be included in your training program:

Professional customization of Microsoft Project projects or their templates according to the needs of your organization:
- automatic indicators of the status of tasks (status, deviations in the rate of execution of volumes, delays);
- setting up formulas in custom fields for calculating the necessary task indicators (planned% completion and volume of work as of the report date, planned balance, deviations in terms and rates of completion);
- setting up views and tables of the Gantt Chart to group and display the necessary indicators of tasks and assigned volumes;
- setting for the manager for all indicators of the calendar plan (completed and remaining volumes, cumulative earned volumes, deviations by periods and cumulative, budget utilization, etc.);
- setting up project templates for accounting for settlements under contracts with contractors;
- setting up OLAP cubes templates for automatic creation of charts and Excel pivot tables for any indicators of MS Project tasks.
Consulting on the customizations of your examples of projects and problems arising in MS Project.
Configuring shared workspaces in cloud document repositories for remote contributors to access project data.
Data integration between Excel documents and MS Project.

How to get a consultation

To order a training or consultation, you need to complete the following steps.

If you need help with MS Project, contact us right now. So far, our experts together can allocate no more than 10 hours a week for consultations, so it is possible that in the future we will have to raise the cost of this service, or provide it by appointment.

Year of issue: 2010

Publishing house: BHV-SPb

ISBN: 978-5-9775-0582-6

Chapter 1. a brief description of project management techniques

Projects and project management
Organizational aspects of project management
Project management processes
Initiation processes
Planning processes
Execution processes
Monitoring and regulation processes
Completion Processes
Project Management Standard and Real Management Processes
Areas of knowledge in project management
Implementation of project management processes
Brief description of methods of network planning and management

Chapter 2. Quick Start

Description of the content of the first project
The first experience with MS Project 2010

Chapter 3. Brief description of the project management system MS Project

Project management systems
Project management system MS Project
Project management system versions MS Project
Project database
Controlling Project Timeline Information Views in Project
Quick Access Toolbar
Menu ribbon
Project timeline views
Timeline
Tables
Filters
Reports
Basic elements of the Project interface
Tasks and resources in Project
Types of tasks
Resource types
How to work with a table
Highlighting parts of a table
Formatting text elements
Managing table columns
Sorting tables
How to work with a Gantt chart
How to work with resource load tables
How to work with the resource graph
How to work with Calendar view
Calendar view context menu
How to work with filters
Additional Formatting Options for Chart Task Bars
Access to information about the main elements of the project
Description of project tasks
Description of project resources
Description of project assignments
reference system Project 2010
Managing user interface elements

Chapter 4. Using Project in the Pre-Planning Stage

Recommendations for project initiation
Features of initiating small projects
Preliminary project planning
Scope planning and definition of the structure of work at the stage of preliminary planning
Creating a new project file
Determination of the scope of tasks with an estimate of the duration of their execution
Formation of resource support - labor costs
Formation of relationships between tasks of the project schedule
Development of a preliminary project schedule
Estimating the cost of a project using Project
Project budget and work with it
How to create and format reports using Project
Principles of splitting a report into sheets
Screen printing
Formatting Printout Sheets
Standard reports
Grade financial solvency the project
Formation of the basic project plan
Defining the criteria for project success
Other project planning processes at the pre-planning stage
Planning the scope of the project and defining the structure of work at the stage of preliminary planning
Project Scope Planning
Planning the content of small projects
Determining the content of large projects
About deploying large projects
About decomposition of large projects
Features of high-tech projects
Formation of project success criteria
Quality planning
Organizational planning
Permanent organization and its impact on the project
The role of the project manager
Features of project management in matrix structures
Communication planning
Risk planning
Planning contracts
Planning and change management
Organization of work with documents in the project
Personnel management and the influence of the human factor at the stage of project initiation

Chapter 5. Scheduling Projects in Detail with Project

Design structures and data organization
Detailed project schedule
Recommendations for assessing the indicators of project tasks
Effort Estimation Guidelines
Tips for estimating task duration
Cost estimation guidelines
Analysis and regulation of the detailed project schedule
Features of scheduling the time of a detailed project plan
How to schedule resources with Project
Features of other planning processes at the detailed planning stage
Critical chain planning

Chapter 6. Supporting Project Execution and Analysis Processes with Project

How to track progress and results with Project
Advanced options for working with different versions of charts
Updating the graph based on progress and task results
Visualization of work progress and identification of deviations of the current state of work from the baseline
How to manage project cycle and resources
How to control the critical path
How to shorten the critical path
Resource demand control
Resource management in Project
Work cycle and resource load management - additional Project features
Interrupting tasks
Adjustment of the detailed execution plan of the sample project
Analyze financial resource needs with Project
Control financial resources during the project
Project Execution Management
Special situations in project management
Supporting Project Management Processes during the Project Execution Stage
Quality management at the stage of project implementation
Change management at the stage of project implementation
Problem solving management in projects
The human factor in project management
Scheduling complex projects with Project
Formation of complex graphs
Sharing resources in the implementation of different projects
Sequencing tasks that belong to different schedules
Work calendars in Project
Create and edit work calendars
Support for management functions working group project using Project
Support for data analysis processes using the Project interface
Using visual reports
Transferring project dates
Copying pictures for use in software products MS Office
Project support for project completion processes

Chapter 7. Concept of project portfolios and corporate project management systems

Project portfolios - a company management tool
Characteristics of the capabilities of MS Project 2010 in corporate governance projects
MS Project and corporate systems management
Appendix 1. List of algorithms
Chapter 3 algorithms
Chapter 4 algorithms
Chapter 5 algorithms
Chapter 6 algorithms
Chapter 8 algorithms
Chapter 9 algorithms
Appendix 2. Description of the CD
Recommended reading

It might be helpful to read: