
Download and organize course and exercise files, using start and complete files as references, and mirror Project 2021 settings, including default view gantt with timeline and calendar options.
Acknowledge that there is no exercise one folder and we won't use project files. Download and save the course and exercise files, review dates, and review project options.
Create a resource pool to share resources across projects, save an MPP, and link projects to the pool to resolve over allocations using pool precedence and the resource usage view.
Automate rag status in Microsoft Project by calculating cost variance with a nested if formula in a new custom field, plus switching to text display and using the cost table.
Learn to replace nested if statements with the switch formula for rag auto field, evaluate cost variance thresholds, and apply graphical indicators with tooltips in Project.
Create a flag custom field and mark tasks with a finish variance of five days or more, including the summary task, then graphically indicate these variances in the Gantt chart.
Learn outline numbering and WBS codes with a house build project, see automatic renumbering, and customize WBS codes via project code prefix, code mask, and unique task identifiers.
Explore how outline numbering and WBS codes react to restructuring, and learn to adjust codes manually or reset numbering to restore consistency.
Define and implement outline codes to create a charge code structure that distinguishes internal and external resources, chargeable and non-chargeable, enabling cost center reporting and resource cost analysis.
Practice configuring a custom outline code field for a web project, set a web dev project code field with five levels, and assign codes to tasks in the gantt chart.
Explore how to enter and manage fixed task costs in a project, including accrual at start, notes for fixed costs, and one fixed cost per task alongside resource costs.
Learn cost accrual in Microsoft Project 2021, including prorated, start, and end accruals, applying fixed and resource costs, assigning resources, and updating project status.
Set up budget costs by creating a budget resource assigned to project summary task, and compare budget versus actual costs; note that baselines differ.
Learn how cost rates work in Microsoft Project 2021, including the default A rate, B rate schedules, cost rate tables, and how to schedule rate changes.
Apply overtime to the testing task to finish earlier, while tracking cost increases, and explore redistribution among resources and calendar options to shorten the overall project duration.
Explore managing variable material costs by modeling materials as resources—concrete by volume, pump by day-use with per-use charges, and fuel by liter with prorated accrual—applied to a footing task.
Analyze exercise five in advanced Microsoft Project 2021 to split 1634 hours of work into 894 external and 740 internal hours, using budget work and code-based resource grouping.
Explore how to customize tables in Microsoft Project, including selecting, editing, and saving custom table views to boost efficiency.
Learn to manage custom table definitions in Microsoft Project 2021 by creating, editing, and organizing task and resource tables, and using the organizer to copy to the global template.
Create and customize project views by copying default views (like the gantt chart), selecting the display table, applying filters and groups, and saving named single or combination layouts.
Sort tasks and resources in Microsoft Project 2021 by cost, dates, and IDs. Apply and customize filters to hide data, reset sorts, and view tasks that meet specific criteria.
Learn to group tasks and resources in Microsoft Project 2021 by duration, weeks, completion status, and create two levels of resource grouping with formatting and the resource usage view.
Practice exercise six in a building project using initials in a combination view with task details, grouping by duration, highlighting critical tasks, and a custom cost table in Arial Rounded.
Explore how to access and customize project 2021 reports from the report tab, including dashboards, report templates, custom reports, themes, and layout options.
Create and customize the project overview report in Microsoft Project 2021 by adjusting themes, page breaks, header formatting, and applying the field list, filters, and charts.
Explore how to style reports in Microsoft Project 2021 by applying themes, customizing colors and fonts, and saving custom themes while adjusting chart and table visuals.
Create a fresh report from scratch in Microsoft Project 2021, adding charts, tables, images, and shapes, and apply themes and z-order adjustments for a polished overview.
Targeted reporting tailors project reports for audiences and stakeholders, showing progress against baselines and dashboards like cost overview and project overview.
Learn to compare two project versions in Microsoft Project 2021 using the Compare Projects feature, view differences in selected tables, and save the comparison report.
Replicate the look and feel of a project report by formatting a landscape chart and a hierarchical table showing remaining work for external resources, with custom sorts and headings.
**This course includes downloadable instructor files and exercise files to work with and follow along.**
Are you an experienced project manager or PMO who knows your way around MS Project 2021 but who would like to build your confidence with the application’s more sophisticated tools? If so, this is the course for you.
In fourteen jam-packed sessions, we will cover a broad range of features that you can put to immediate use, learning to visualize, plan, and execute your projects in a whole new way.
We will explore advanced topics like splitting, consolidating, and sharing projects and creating shared resource pools. We’ll have you managing variable costs, overtime, budgets, and WBS codes in no time. Creating customized tables, views, and reports lets you look at your projects in the ways that are most helpful to you, and recording macros and modifying VBA macro code will save you valuable time, reducing repetitive tasks. We’ll also cover importing and exporting data between Project and other applications to give you maximum flexibility. Each session ends with hands-on exercises to reinforce the new skills.
This course is for the project manager who wants to hone their abilities and gain greater insight into and control over the projects they manage, using this powerful Microsoft tool as effectively as possible. Mastery of Project 2021 is among the most valuable tools in every project manager’s professional toolkit, and we’re here to make sure it’s in yours.
By the end of this course, you will feel confident:
Splitting and consolidating projects.
Creating shared resource pools.
Setting up recurring tasks and creating custom fields.
Customizing outline numbering.
Understanding and creating unique WBS codes.
Assigning fixed costs to tasks and resources.
Understanding cost accrual and different accrual methods.
Working within budgets.
Making changes to cost rates.
Working with overtime in a schedule.
Working with variable material costs.
Creating custom tables and views.
Sorting, filtering and grouping Project data.
Creating, modifying, and running custom reports.
Comparing different versions of a project to highlight the differences.
Creating Excel and Visio reports from Project data.
Understanding Earned Value Analysis and interpreting the EVA tables.
Importing and exporting data between Project and other applications.
Recording a macro to automate repetitive tasks.
Learning the basics of modifying VBA Macro code.
This course includes:
5+ hours of video tutorials
49 individual video lectures
Course and exercise files to follow along
Certificate of completion