Microsoft Project® Training Advanced- 8 Hours Online MS Project Advanced Course

Microsoft Project Advanced Course Chapter #3: Recurring Tasks

Some tasks might be recurring in a project. For instance, sending project report to executive management every month, meeting with project team every week, testing major features of the product every week are examples of recurring tasks.
You will learn how to set up a task to recur at a specified interval

Microsoft Project Advanced Course Chapter #4: Custom Fields

You will learn how to setup a custom field for the project in order to display additional information not included in the standard views.

• Automate the calculation of values for a custom field
• Automate the calculation of values for a custom field using advanced formulas
• Create a custom field for a new project

Microsoft Project Advanced Course Chapter #5: Outline Codes and WBS Codes

You will learn how to manage the structure of your project by applying outline numbering and WBS Codes. You will explore and understand some of the issues that you may come across when using outline numbering and WBS Codes in a project.

• Setting up outline codes to define the structure of a project.
• Set up a new custom outline code to define the structure of the web development project

Microsoft Project Advanced Course Chapter #6: Costs

Cost management is one of the top critical aspects of project management. You will learn the following during this chapter of the MS Project Advanced course:

• Setting a fixed cost for a task
• Understanding Cost Accrual and how it affects the overall project costs
• Create a budget costs group and assign it to resources and tasks.
• Add multiple costs rates to tasks and resources
• Assigning overtime to resources in order to shorten the length of the overall project
• Set up variable material costs and assign then to a task in a project
• Practice how to distribute work between internal and external resources

Microsoft Project Advanced Course Chapter #7: Custom Tables

You will learn creating and editing custom tables and applying them to the project. You will see how to use the Organizer to delete, edit and manage custom table definitions.

Microsoft Project Advanced Course Chapter #8: Custom Views

Creating Custom Views and applying them to the project in order to tailor the information you are looking at

Microsoft Project Advanced Course Chapter #9: Sorting, Filtering, and Grouping

You will learn how to sort tasks and resources in ascending and descending order using Custom Sort feature.

• Applying basic filters and creating custom filters
• Creating custom groups and applying them to various elements in the project
• Practice setting up and applying custom view and grouping to the exercise file

Microsoft Project Advanced Training Chapter #10: Reports

Reports are the crucial tools to show information, progress and details about the project to project stakeholders. Actually, reports and visual reports show the control level of the project manager. You will learn the following during this chapter:

• An Overview of the different reports available in Microsoft Project and customizations that can be made to each element
• Customizing individual elements of a report including text boxes, fonts and fields
• Customizing tables and charts in a report
• Using and customizing the Cost Overview Targeted Report
• Learn how each of the standard and custom reports work and how to edit them
• Customise a report in line with the example
• Comparing the latest version of a project with an older one and understanding the comparison report

Microsoft Project Advanced Training Chapter #11: Visual Reports

Visual reports show the project progress and information in graphs, charts and tables. You will see how to export data from Microsoft Project to Excel using Visual Reports.

Microsoft Project Advanced Training Chapter #12: Earned Value Analysis

Earned Value Analysis is a project management concept to measure how project is progressing compared to planned values. Earned Value Analysis is abbreviated as EVM and measures the actual values of the project cost and schedule and compares them against the planned values to understand how the project is progressing.

• Understand the basic terminology and formulas behind Earned Value Analysis Tables
• Add a task into the baseline and run an updated Earned Value Analysis report
• Make changes to the project file and update the status to see how that reflects in the Earned Value Analysis Report

Microsoft Project Advanced Training Chapter #13: Import and Export

Microsoft Project has its own profile file types and the data in the Microsoft Project Plans might not be easy to read for project stakeholders if they do not have advanced project management knowledge. Therefore, the information in the Microsoft Project files are exported & imported to and from other file types for the use of relevant project stakeholders. You will learn:

• Import data from Excel and Word into Project
• Exporting data from Project into Word, Excel and Notepad files
• Export Project data to a csv file excluding the fields in the instructions

Microsoft Project Advanced Training Chapter #14: Macros

A macro (which stands for "macroinstruction") is a programmable pattern which translates a certain sequence of input into a preset sequence of output. Macros can be used to make tasks less repetitive by representing a complicated sequence of keystrokes, mouse movements, commands, or other types of input. You will learn:

• Automating tasks using macros
• Make edits to the macro in the Visual Basic Editor to change how it runs
• Create a macro based on the instructions in the Exercise

Microsoft Project Advanced Training Chapter #15: Conclusion

We will summarize what we learned and close the Microsoft Project Advanced Course.