Microsoft Project Advanced 2019

Video Description

This expert MS Project 2019 course is for advanced project managers

About This Video

  • Learn how to import and export project data
  • Discover how to manage cost rate changes
  • Understand the effective use of budgets and tracking costs
  • Learn to split projects into sub-projects
  • Create a variety of helpful reports for your project team and management
  • Consolidate multiple projects

In Detail

This course picks up from where the Microsoft Project Beginners 2019 course left off. It assumes that you already have a good understanding of MS Project 2019 and are looking to unlock more advanced features to help you manage projects more effectively.

If your projects have grown complex and you require more automation and structure from your project management software than ever before, then this MS Project 2019 advanced course will help you develop your skills further.

You'll explore shared resource pools in Project before moving on to understanding how to consolidate multiple projects into one. In addition to this, you'll get to grips with setting up recurring tasks, custom tables, and WBS code. As you progress, you'll discover techniques for customized reporting, and importing and exporting data from Excel and Word into Project, along with covering macros in MS Project.

By the end of this course, you'll have gained a comprehensive understanding of the more complex aspects of MS Project 2019 and have developed the skills you need to apply your knowledge to manage your projects efficiently.

Publisher Resources

Download Example Code

Table of Contents

  1. Chapter 1 : Introduction
    1. Introduction to Project 2019 Advanced Course 00:05:07
    2. Course Structure 00:04:44
  2. Chapter 2 : Consolidation and Resource Sharing
    1. Indexing and Lookups 00:11:10
    2. Resource Sharing 00:09:40
    3. Project Consolidation 00:14:25
    4. Exercise 1 00:03:00
    5. Practical Sharing and Consolidation - Part 1 00:15:21
    6. Practical Sharing and Consolidation - Part 2 00:10:56
  3. Chapter 3 : Recurring Tasks
    1. Setting Up Recurring Tasks 00:12:00
  4. Chapter 4 : Custom Fields
    1. Creating a Custom Field 00:14:47
    2. Calculated Custom Field - Part 1 00:11:48
    3. Calculated Custom Field - Part 2 00:04:23
    4. Exercise 02 00:03:35
  5. Chapter 5 : Outline Codes and WBS Codes
    1. What are Outline Numbering and WBS Codes 00:14:50
    2. Problems in Outline Numbering and WBS Codes 00:09:13
    3. Outline Codes 00:11:59
    4. Exercise 3 00:04:33
  6. Chapter 6 : Costs
    1. Fixed Task Costs 00:08:10
    2. Cost Accrual 00:06:55
    3. Budget Costs 00:10:00
    4. Cost Rates and Rate 00:10:21
    5. Overtime 00:06:32
    6. Variable Material Costs 00:05:52
    7. Exercise 04 00:03:35
  7. Chapter 7 : Custom Tables
    1. Customization of Tables 00:12:51
    2. Management of Custom Table Definitions 00:07:23
  8. Chapter 8 : Custom Views
    1. Use of Custom Views 00:11:16
  9. Chapter 9 : Sorting, Filtering, and Grouping
    1. Sorting 00:08:45
    2. Filtering 00:14:02
    3. Grouping 00:14:22
    4. Exercise 05 00:03:03
  10. Chapter 10 : Reports
    1. Reporting Overview 00:13:03
    2. Creating and Customizing Reports - Part 1 00:11:58
    3. Creating and Customizing Reports - Part 2 00:14:07
    4. Targeted Reporting - Part 1 00:12:42
    5. Targeted Reporting - Part 2 00:14:54
    6. Exercise 06 00:03:39
    7. Comparing Projects 00:08:05
  11. Chapter 11 : Visual Reports
    1. Visual Reporting using Excel 00:09:30
  12. Chapter 12 : Earned Value Analysis
    1. Earned Value Analysis Basic Terminology 00:15:25
    2. Example of Earned Value Analysis 00:10:17
    3. Exercise 07 00:04:21
  13. Chapter 13 : Import and Export
    1. Importing Data to Project 00:11:30
    2. Exporting Data from Project 00:14:00
    3. Exercise 08 00:02:10
  14. Chapter 14 : Macros
    1. Recording a Macro 00:11:08
    2. Writing a Macro 00:11:18
    3. Exercise 09 00:05:04
  15. Chapter 15 : Conclusion
    1. Closing 00:00:37

Product Information

  • Title: Microsoft Project Advanced 2019
  • Author(s): Simon Sez IT
  • Release date: July 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781839215452