Previous Microsoft Project Tips
Fill in duration, work, and dates quickly
(04:32)
Create a hammock task
(04:07)
Rename column headings
(03:58)
Display a calendar's nonworking time
(02:21)
Prevent duplicate resource names
(04:08)
Eliminate hashtags in table columns
(02:56)
Count tasks that meet a criterion
(04:13)
Sort resources by type and name
(02:28)
Fast access to your Project files
(03:56)
Save a new view
(05:53)
Compare individual and group allocation
(03:47)
Populate a lookup table with existing values
(03:10)
Summarize resource utilization
(03:00)
Hide non-working days on task bars
(01:45)
Find hidden task bars
(04:56)
Set additional baselines
(05:06)
Store customized elements where you want
(05:52)
Calculate work hours in a formula
(04:34)
Record costs from an external system
(04:52)
Change the date format in a specific view
(04:00)
Find a command
(04:29)
Edit multiple tasks simultaneously
(03:34)
Track ancillary project costs
(11:33)
When leveling doesnt eliminate overallocations
(09:18)
Update parts of a baseline
(04:04)
Open and save file shortcuts
(06:02)
Create a cross-project dependency
(04:56)
Use hyperlinks in reports to navigate to details
(01:57)
Reuse lookup tables and formulas
(05:23)
Customize and share the Quick Access Toolbar
(04:31)
Calculate separate critical paths for several projects
(03:14)
Shortcuts for reapplying and clearing filters
(02:44)
Compare Microsoft Project editions
(03:12)
Shortcuts for viewing primary and detail panes
(02:47)
Flag key tasks with custom bar styles
(06:45)
Designate who reports status
(03:21)
Keep important fields visible in a table
(04:13)
Control how a view prints
(05:42)
Identify projects in a master file
(03:49)
Schedule for maintenance or system switchover
(06:06)
Manage negative slack in a schedule
(06:40)
Build an excel report that updates dynamically from project
(04:53)
Add a custom sort to the ribbon to reapply it quickly
(04:18)
Evaluate management timeframes
(03:35)
View progress as a percentage
(03:41)
Schedule approval during next meeting
(05:41)
Create a work shift that spans two days
(05:28)
Display tasks that should have status
(03:42)
Model scenarios with inactive tasks
(05:52)
Summarize tasks in resource usage view
(02:02)
Display labor cost by project section
(03:57)
Copy values from one baseline to another
(02:52)
Switch date constraints
(02:21)
Data entry shortcuts
(02:46)
Display the Task Details form in the Details pane
(03:44)
Add overall project notes to project summary task
(02:31)
Choose AutoSave options wisely
(03:57)
Create a WBS graph with a visual report
(09:25)
Find all tasks with estimated durations
(03:26)
Attach an image to a timescale task bar
(04:19)
Custom view, part 1: Set up a custom view
(04:39)
Custom view, part 2: Set up dashboard icons
(08:50)
Custom view, part 3: Group tasks by variance
(03:52)
Custom view, part 4: Filter troubled incomplete tasks
(04:01)
Find summary tasks with dependencies
(05:12)
Dependencies, part 1: Setup to review link types
(06:07)
Dependencies, part 2: Evaluate link types
(06:34)
Find tasks with date constraints
(08:15)
Find dependencies with lag or lead
(04:40)
Find tasks with excessive float
(08:06)
Find incomplete tasks with negative float
(05:01)
Find tasks with invalid dates
(04:45)
Find incomplete tasks without resources
(04:03)
Graphical report, part 1: Create a table
(05:26)
Graphical report, part 2: Build a graph
(03:05)
Graphical report, part 3: Fine-tune graph axes
(01:48)
Find in-progress assignments
(03:13)
Find when a resource is available
(05:49)
Report work by resource and project
(04:04)
Beware the Autolink option
(03:48)
Schedule part of a project from the finish date
(02:47)
Make exporting data easy
(05:22)
Simplify importing with a map
(03:48)
Merge data into existing rows
(03:48)
Turn off screen tips before presentations
(03:15)
Use indicators and option buttons
(05:20)
Set currency options
(01:47)
Prevent Project from calculating actual cost
(03:56)
Update OLE links
(03:58)
Assign resources with different schedules
(03:59)
Ignore resource schedules on a task
(04:29)
Use the Timeline view to control dates in a Gantt Chart view
(02:51)
Remove tasks from a summary task without deleting them
(02:46)
Set the fiscal year for a project
(03:56)
Update assignment status from task status
(03:59)
Restore window scroll bars if they go missing
(01:25)
Make linked cells visible in a view's table
(01:34)
Remove personal information from a Project file
(02:12)
Select predecessors easily in a dropdown list
(02:00)
Set up a calendar day with partial nonworking time
(03:42)
Share customized elements
(03:31)
Document your customizations
(04:23)
Working days, part 1: Calculate the days between two dates
(04:31)
Working days, part 2: Add error test for missing dates
(04:41)
Add multiple hyperlinks to a task or resource
(02:54)
Add a hyperlink to a file in a custom field
(03:05)
Tips for importing names from Excel
(06:00)
Format numbers, part 1: Formatting in a text field
(04:45)
Format numbers, part 2: Fine-tune number formats
(04:51)
Ancillary costs, part 1: Track with Fixed Cost fields
(05:24)
Ancillary costs, part 2: Track with cost resources
(04:58)
Change requests, part 1: Flag change requests
(04:26)
Change requests, part 2: Document change requests
(02:07)
Key tasks, part 1: Add flags to key tasks
(04:09)
Staffing plan, part 1: Assign generic resources
(02:38)
Staffing plan, part 2: Display plan in a spreadsheet
(07:31)
Master project links, part 1: When subprojects go missing
(03:05)
Master project links, part 2: Move a resource pool
(05:08)
Format duration, part 1: Display whole hours
(02:53)
Format duration, part 2: Add minutes to display
(03:54)
Contingency funds, part 1: Set up custom fields
(05:01)
Contingency funds, part 2: Calculate used funds
(04:12)
Project profit, part 1: Set up custom fields
(03:51)
Project profit, part 2: Calculate profit percentage
(06:09)
Open and save file shortcuts
(04:31)
Progress comparisons, part 2: Update and compare
(05:25)
View upcoming work, part 1: Create two-week filter
(06:44)
View upcoming work, part 2: Display upcoming work
(03:36)
Tasks with no dependencies, part 1: Create filter
(02:15)
Tasks with no dependencies, part 2: Evaluate unlinked tasks
(04:08)
Tasks with no dependencies, part 3: Count work tasks
(03:29)
Tasks with no dependencies, part 4: Calculate percent
(07:18)
Find summary tasks with dependencies
(05:20)
Finish-to-start links, part 1: Setup
(06:09)
Finish-to-start links, part 2: Calculate FS percentage
(04:21)
Calculate percentage of tasks with date constraints
(06:57)
Find tasks with lead time
(03:46)
Calculate the percentage of tasks with lag or lead
(05:32)
Count tasks with excessive float
(04:23)
Calculate the percentage of tasks with excessive float
(04:38)
Count tasks with negative float
(04:07)
Adjust a schedule to remove negative float
(03:13)
Find and correct tasks with invalid dates
(04:58)
Avoid invalid dates
(04:16)
Find incomplete tasks without resources
(04:27)
Create a schedule quality dashboard
(05:21)
Create schedule assessment report
(04:47)
Add best practice values to table
(03:41)