Microsoft project reports tutorial

Thousands of people who tried to learn MS Project from YouTube failed to use the software properly at work. Especially, if you are a professional or already involved in project scheduling, you must make sure that you learn the software thoroughly and that anything that you learn is correctly taught. YouTube can never be the proper source to learn the software perfectly.

So, you should go for a paid MS Project online tutorial from a reputed leading training academy. At Master of Project Academy , we specialize in project management training, and our MS Project instructors are Microsoft certified professionals who impart high quality and advanced level training. They have conducted numerous training to date and our MS Project online tutorial has been purchased and liked by thousands of happy customers.

If you search the Internet, you will even find free Microsoft Project online tutorial options on many websites.

These MS Project online tutorials include free videos, discussion forums, blogs, and articles. However, these will not be comprehensive and are not the easy and preferred way of learning MS Project.

Especially, if you want to master MS Project, and learn the software completely, then you should go for a paid MS Project online tutorial. Nobody wants to risk their money on a course that would not be effective or price worthy. That is why there should be a free Microsoft Project online tutorial that you can enroll in and analyze its quality, before purchasing the complete course. If you like the free parts of the course, you may then purchase from the same vendor the paid MS Project online tutorial for advanced topics.

This free Microsoft Project online tutorial is carefully created to teach you in a very easy way the basics of the software. You will even get a course completion certificate upon completing this free Microsoft Project online tutorial. From these videos, you will learn how to acquire MS projects, how to open and close the projects. Furthermore, you will learn how to enter new tasks and change task properties. You will be taught how to create a real-world like project through an example.

If you need any help with what is taught to you, you can write to us. Our instructors will reply to you within 24 hours. There is no fee for obtaining support from us. At the end of the training videos, there are quizzes as well to allow you to test your MS Project skills. If you hold a PMI certification, you will earn 0. We encourage you to enroll in our free Microsoft Project online tutorial. This tutorial is best suited for project engineers, planners, team leads, and all other professionals who want to learn MS Project.

Those who have enrolled in our free MS Project online tutorial left positive feedback on our website. Some wrote this:.

This was a good experience to see the short training videos from their comprehensive course before I decided to enroll in the complete course. I learned the fundamentals about how to add tasks and change their attributes in the project plan. Using Microsoft is not beneficial only for your projects, it is beneficial for you too.

For example, it makes it easy for you to organize the project work by creating a perfect project schedule with assigned resources. Outline level box lets you select how many levels in the project outline the table should show. The look of the table can be changed by clicking on Table Tools tabs, Design, and Layout tabs. Charts will have the same data at first. You can click one of the charts and pick the data you want in the Field List pane to begin differentiating them.

Pavan Lalwani. Saatya Prasad. Gowthami Swarna. Akshay Magre. I prefer selecting weeks and have the total duration of roughly one month as I prefer to see the free capacity for next month. Select the Remaining Availability from work option. Finally, after creating all the above graphs by following the tutorial you can save the Sample.

You can also use the copy report option in the design tab to copy the output to the clipboard and then to any other document or email you want. This option is handy when you want to paste from Microsoft Project to another application. If you like this tutorial then please share it with your friends and your colleagues. It is recommended that you read the below articles before you proceed with creating the reports. This is the most important step as it will lay the foundation for the dashboard to be generated.

You will need to create one filter each for the teams and a group on Resource Groups. Also, a group based on Resources Group and Resource Name.

Please see the below articles on how to add filters and groups. We will now look at how we can create 3 different sets of reports for resource management dashboard. Team Work Load Report - A report which will provide a view of the team workload.

Resource Allocation Report - This report will help in understanding how the resources are allocated. Resource Availability Report - This report will show if any resources are available.

To add the team workload dashboard click on Design and add a new Chart. Select the type of report you need to use. And select the fields as shown to the image to the right to see the report which is based on resource groups.

The report will be based on the group that you select. You can add formatting options by right-clicking on the report. You can add legends, chart titles, data values etc. Team Workload Report. The resource allocation report on the dashboard will give a view of how much work each resource has been assigned. Two values are shown for each resource - Work and Remaining Work. Work is the work assigned and the remaining work is the work still remaining.

This report will help a project manager in deciding if any of the resources are overloaded. Select the fields as shown in the image to the left. The key is to select the options right as that will decide what is displayed on the report.

The above report on the dashboard gives you a good idea about how all the resources are allocated. The report is a very high-level report and does not tell you when the resource is free. To find out when the resource is free we will use the Time option. Also, remember that if you try to do this with the entire resource pool the report or the chart might get very big and become difficult to read.

In this example , I have used the IT Team filter and the group by ResourceName which will group the data by resource names. Resource Allocation Report. Add effects to pictures. Configure and tweak tables, like you would in other Office programs. Configure and tweak charts. Click the Chart Styles button to quickly change the color or style of a chart. Pick a new style from the Chart Styles group.

This style removes the lines and adds shadows to the columns. Give the chart some depth. Add a background color. Change the bar colors. Just a few clicks make a big difference. And we only scratched the surface of the formatting options. Blank Creates a blank canvas. Use the Report Tools Design tab to add charts, tables, text, and images.

Use the Field List pane to pick different fields to compare, and use the controls to change the color and format of the chart. The Outline level box lets you select how many levels in the project outline the table should show. Comparison Sets two charts side-by-side.

The charts have the same data at first. Click one chart and pick the data you want in the Field List pane to begin differentiating them. Any of the charts you create from scratch are fully customizable.

You can add and delete elements and change the data to meet your needs. Tip: You might need to resize and line up the report when you paste it into its new home.

You can also print the report to share it the old-fashioned way. Use the Organizer to copy a new report into the global template for use in future projects. Compare actual work against your estimates with burndown reports. Create a timeline of key tasks and milestones.

Set the status date for project reporting. Visual reports allow you to view Project information graphically using enhanced PivotTables in Excel Once Project information has been exported to Excel, you can customize the reports further with Excel enhanced PivotTable features, such as filter slicers, searching within PivotTables, sparklines within PivotTables to show trends instantly, and OLAP write-back improvements. The report templates in Project are divided into six categories in the Visual Reports - Create Report dialog box, which you can access by clicking Visual Reports in the Reports group of the Project tab.

The following sections provide descriptions of the visual reports in each category. You can also create your own custom reports. Custom reports will appear in the category for the type of data used.

The following table describes the visual reports in the Task Usage category. These reports are based on timephased task data. Note: Timephased assignment data is available in reports in the Assignment Usage category. Use this report to view a chart that plots AC actual cost of work performed , planned value budgeted cost of work scheduled , and earned value budgeted cost of work performed over time.

The following table describes the visual reports in the Resource Usage category. These reports are based on the timephased resource data.

Use this report to view a diagram that shows planned and actual costs for your project over time. Costs are broken down by resource type work, material, and cost. An indicator shows if planned costs exceed baseline costs.