ICT and Security Management · MSD2838

Advanced Microsoft Project: Beginner to Expert

Dealing with large projects can be daunting through the whole project lifecycle. In this course, Microsoft Project, you will learn foundational knowledge of defining and creating a project, resources, assignments, as well as tracking and reporting. First, you will learn how to create a work breakdown structure, link tasks and then display and print the project's Critical Path. Next, you will discover the different resource types and how these, and costs, can be assigned to the project. Finally, you will explore how to how to formally close the project and create a template from the existing schedule. When you are finished with this course, you will have the skills and knowledge of Microsoft Project needed to use the Agile capabilities in the subscription version of Project, and how to print and communicate different aspects of the project plan using custom and pre-defined reports.

The course is peppered with best practices and examples, which will take your knowledge to the next level to make you a project superstar. Some of the major topics that we will cover include creating the task list and dependencies. Assigning resource is and costs updating on tracking the project and producing great looking project reports

Advanced Microsoft Project: Beginner to Expert
Online fee from
$200 USD
Standard: $300 · Save $100
Course Outcomes

Expected learning outcomes

By the end of this workshop, participants should be able to:

  • Split the view
  • Sort, group, and filter tasks
  • Use zoom
  • Overlap, delay, or split tasks
  • Set task deadlines and constraints
  • Understand task types
  • Assign a task calendar
  • Understand task indicators
  • Assign a resource calendar
  • Customize a resource calendar
  • Apply predefined resource contours
  • Specify resource availability
  • Group resources
  • Enter resource rates and overtime rates
  • Specify pay rates for different dates
  • Apply a different pay rate to an assignment
  • Use material resource consumption rates
  • Entering task fixed costs
  • Schedule resource overtime
  • Identify and balance resource overallocation
  • Save a baseline plan
  • Update project, actual task values, actual work and actual costs
  • View project statistics and costs
  • Check duration variance, work variance, and cost variance
  • Identify slipped tasks
  • Save an interim plan
  • Customize a basic or visual report
  • Create a custom report
  • Sort a report
  • Inserting a subproject
  • Consolidate multiple projects
  • View multiple project critical paths
  • View consolidated project statistics
  • Create a resource pool
Curriculum

Course modules and outline

Module One: Getting Started.

  • Workshop Objectives.
  • Pre-Assignment Review..

Module Two: Viewing the Project.

  • Using Split Views.
  • Sorting Information.
  • Grouping Information.
  • Filtering Information.
  • Using AutoFilters.
  • Using Zoom..
  • Module Two: Review Questions.

Module Three: Working with Tasks (I).

  • Overlapping Tasks.
  • Delaying Tasks.
  • Setting Task Deadlines.
  • Setting Task Constraints.
  • Splitting Tasks.
  • Module Three: Review Questions.

Module Four: Working with Tasks (II).

  • Understanding Task Type.
  • Assigning a Task Calendar.
  • Understanding Task Indicators.
  • Module Four: Review Questions.

Module Five: Working with Resources.

  • Assigning a Resource Calendar.
  • Customizing a Resource Calendar.
  • Applying Predefined Resource Contours.
  • Specifying Resource Availability Dates.
  • Grouping Resources.
  • Module Five: Review Questions.

Module Six: Working with Costs.

  • Adding Pay Rates for a Resource.
  • Specifying Pay Rates for Different Dates.
  • Applying a Different Pay Rate to an Assignment.
  • Using Material Resource Consumption Rates.
  • Entering Task Fixed Costs.
  • Module Six: Review Questions.

Module Seven: Balancing the Project.

  • Scheduling Resource Overtime.
  • Identifying Resource Overallocation.
  • Setting Leveling Options.
  • Balancing Resource Overallocations Automatically.
  • Balancing Resource Overallocations Manually.
  • Module Seven: Review Questions.

Module Eight: Updating Project Progress.

  • Saving a Baseline Plan.
  • Updating the Entire Project.
  • Updating Task Actual Values.
  • Updating Actual Work.
  • Updating Actual Costs.
  • Module Eight: Review Questions.

Module Nine: Checking Project Progress.

  • Viewing Project Statistics.
  • Viewing Project Costs.
  • Checking Duration Variance.
  • Checking Work Variance.
  • Checking Cost Variance.
  • Identifying Slipped Tasks.
  • Saving an Interim Plan.
  • Module Nine: Review Questions.

Module Ten: Working with Reports.

  • Customizing a Basic Report.
  • Creating a Custom Report.
  • Customizing a Visual Report.
  • Sorting a Report.
  • Module Ten: Review Questions.

Module Eleven: Working with Multiple Projects.

  • Inserting a Subproject.
  • Consolidating Projects.
  • Viewing Multiple Project Critical Paths.
  • Viewing Consolidated Project Statistics.
  • Creating a Resource Pool
  • Module Eleven: Review Questions.

Module Twelve: Wrapping Up.

  • End of Course Assessment
  • Words from the Wise  
Target Audience

Who should attend?

Microsoft MS Project

Why Attend

Key course benefits

Practical capacity building approach
Designed for government, NGOs and public institutions
Real-world African case studies
Certificate of completion
Applicable tools and templates
Interactive facilitation and exercises
Course Enquiry

Need more information?

Ask Magna Skills about this course

Use the PHPMaker enquiry form to request a quotation, proposal letter, invoice, group training package, online access, or face-to-face training arrangement.

Debug

sql: SELECT COUNT(*) FROM `userlevels` WHERE `userlevelid` = -2, executionMS: 0.0006110668182373

sql: SELECT `userlevelid`, `userlevelname` FROM `userlevels`, executionMS: 0.00034904479980469

sql: SELECT COUNT(*) FROM `userlevelpermissions` WHERE `userlevelid` = -2, executionMS: 0.00078201293945312

sql: SELECT `tablename`, `userlevelid`, `permission` FROM `userlevelpermissions` WHERE `userlevelid` IN (-2), executionMS: 0.0024039745330811

sql: SELECT c.*, cc.Category_Name, cc.Summary AS CategorySummary, cc.Category_Description FROM courses c LEFT JOIN course_categories cc ON cc.id = c.Category WHERE c.id = 2838 LIMIT 1, executionMS: 0.0008540153503418

sql: UPDATE courses SET Views = IFNULL(Views,0) + 1 WHERE id='2838', executionMS: 0.001450777053833

sql: SELECT * FROM course_modules WHERE CourseID = 2838 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 20, executionMS: 0.00041508674621582

sql: SELECT * FROM course_highlights WHERE CourseID = 2838 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 8, executionMS: 0.00027108192443848

sql: SELECT * FROM course_learning_outcomes WHERE CourseID = 2838 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 10, executionMS: 0.00037789344787598

sql: SELECT * FROM course_target_audience WHERE CourseID = 2838 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 8, executionMS: 0.00031781196594238

sql: SELECT * FROM resources WHERE CourseID = 2838 AND Status IN ('Published','Active','1') ORDER BY id DESC LIMIT 5, executionMS: 0.0003211498260498

sql: SELECT * FROM reviews WHERE CourseID = 2838 AND CanPublish = 1 AND Status IN ('Approved','Published','1') ORDER BY id DESC LIMIT 4, executionMS: 0.00035691261291504

sql: SELECT * FROM gallery_albums WHERE CourseID = 2838 AND Status IN ('Published','Active','1') ORDER BY IsFeatured DESC, AlbumDate DESC, id DESC LIMIT 3, executionMS: 0.00037407875061035

sql: SHOW COLUMNS FROM `venues` LIKE 'id', executionMS: 0.0007178783416748

sql: SELECT v.*, v.`id` AS VenueKey, (SELECT COUNT(*) FROM apply a WHERE a.Venue = v.`id` AND a.Course_Title = 2838) AS CourseApplications, (SELECT COUNT(*) FROM apply a WHERE a.Venue = v.`id`) AS TotalApplications FROM venues v ORDER BY CourseApplications DESC, TotalApplications DESC, v.Venue ASC, executionMS: 1.6448409557343

sql: SHOW COLUMNS FROM `courses` LIKE 'Category', executionMS: 0.001533031463623

sql: SELECT id, Course_Title, Course_Code, Short_Description FROM courses WHERE Category = 809 AND id <> 2838 ORDER BY id DESC LIMIT 6, executionMS: 0.0010600090026855

sql: SELECT COUNT(*) FROM apply WHERE Course_Title = 2838, executionMS: 0.084677934646606

sql: SELECT COUNT(*) FROM enroll WHERE Course = 2838, executionMS: 0.00057005882263184

sql: SELECT ROUND(AVG(Rating),1) FROM reviews WHERE CourseID = 2838 AND CanPublish = 1, executionMS: 0.00043392181396484

sql: SELECT COUNT(*) FROM course_modules WHERE CourseID = 2838, executionMS: 0.00033807754516602

sql: SELECT COUNT(*) FROM course_lessons cl INNER JOIN course_modules cm ON cm.id = cl.ModuleID WHERE cm.CourseID = 2838, executionMS: 0.00038599967956543

sql: SELECT COUNT(*) FROM course_highlights WHERE CourseID = 2838, executionMS: 0.00031685829162598

sql: SELECT COUNT(*) FROM course_learning_outcomes WHERE CourseID = 2838, executionMS: 0.0002748966217041

sql: SELECT COUNT(*) FROM course_target_audience WHERE CourseID = 2838, executionMS: 0.00023293495178223

sql: SELECT COUNT(*) FROM resources WHERE CourseID = 2838, executionMS: 0.00020408630371094

sql: SELECT COUNT(*) FROM reviews WHERE CourseID = 2838, executionMS: 0.00021600723266602

sql: SELECT COUNT(*) FROM gallery_albums WHERE CourseID = 2838, executionMS: 0.00019693374633789

sql: SELECT COUNT(*) FROM course_enquiries WHERE CourseID = 2838, executionMS: 0.00021505355834961