From the course: Microsoft Project Tips Weekly
Unlock this course with a free trial
Join today to access over 24,200 courses taught by industry experts.
Count tasks with excessive float
From the course: Microsoft Project Tips Weekly
Count tasks with excessive float
- [Instructor] Hi, I'm Bonnie Beuford. One scheduling best practice is the tasks with high float should represent 5% or less of the project tasks, because they're hard to track and manage. In this tip, we'll start by finding tasks with excessive float. I'm going to start by inserting the total slack field into this table. I'm going to right click the Duration heading and then choose Insert Columns. I'll start to type the name of the field, Total Slack. And when I see it, I can click it to add it to the table. Now, what is high float? That depends on the length of the project. This project is about seven months duration. So I'm going to use one month as high float. We're going to look for tasks with float greater than one month or 20 workdays. We're going to calculate this with a custom number field. So I'm going to right click the heading for Total Slack and choose Insert Column again. I want to add a number field.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
- 04_05_owner.zip
- 03_11_Event.zip
- 05_01_mgttime.zip
- 04_04_staffing.zip
- 03_12_Event.zip
- 04_03_flagkey.zip
- 02_03_addlbase.zip
- 03_08_hyperlink.zip
- 01_12_populatelookup.zip
- 05_03_nextmtg.zip
- 03_09_lookup.zip
- 01_13_resource_utilization.zip
- 05_02_delay.zip
- 03_10_qat.zip
- 05_05_datefilter.zip
- 02_01_hidenonwork.zip
- 05_04_workshift.zip
- 02_02_hiddenbars.zip
- 04_06_duplicate.zip
- 03_06_change.zip
- 03_07_kickoff.zip
- 04_10_switchover.zip
- 04_09_Event.zip
- 04_08_minutes.zip
- 04_07_printview.zip
- 01_11_compare_allocation.zip
- 03_02_cost.zip
- 01_06_hashtags.zip
- 03_03_level.zip
- Ex_Files_Microsoft_Project_Tips.zip
- 03_04_editbase.zip
- 01_08_sort_resources.zip
- 01_07_counttasks.zip
- 01_10_saveview.zip
- 04_11_negative.zip
- Ex_Files_Microsoft_Project_Tips_2018_Q2.zip
- 05_11_profit.zip
- 03_01_multiple.zip
- 05_10_copybase.zip
- 04_13_sort.zip
- 04_12_excel.zip
- 01_04_nonstd_calendar.zip
- 01_05_duplicate_resources.zip
- 02_10_append.zip
- 05_13_dateentry.zip
- 02_11_formatnum.zip
- 01_01_dataentry_shortcuts.zip
- 05_12_asap.zip
- 02_12_dateformat.zip
- 01_02_hammock.zip
- 02_13_findcmnd.zip
- 01_03_rename_columns.zip
- 05_06_scenarios.zip
- 02_09_acctcost.zip
- 02_08_workcalc.zip
- 05_08_dataentry.zip
- 02_04_storecustom.zip
- 03_13_filter.zip
- 05_07_summary.zip
- 02_05_sharecustom.zip
- 05_09_contingency.zip
- 02_06_calcworkdays.zip
- 05_08_laborcost.zip
- 02_07_hyperlink.zip
- 06_01_changerpt.zip
- 06_02_details.zip
- 06_03_sumnotes.zip
- 06_04_2wkfilter.zip
- 06_05_autosave.zip
- 06_06_wbs.zip
- 06_07_estimated.zip
- 06_08_image.zip
- 06_09_pt1_newcustom.zip
- 06_10_pt2_dashboard.zip
- 06_11_pt3_group.zip
- 06_12_pt4_filter.zip
- 06_13_pt5_flag.zip
- 07_01_nolinks.zip
- 07_02_sumlinks.zip
- 07_03_linksetup.zip
- 07_04_reviewlinks.zip
- 07_05_constraints.zip
- 07_06_laglead.zip
- 07_07_float.zip
- 07_08_negfloat.zip
- 07_09_invaliddates.zip
- 07_10_noresources.zip
- 07_11_newtable.zip
- 07_12_newgraph.zip
- 07_13_axes.zip
- 08_01_inprogress.zip
- 08_02_available.zip
- 08_03_appdev.zip
- 08_04_autolink.zip
- 08_05_fromfinish.zip
- 08_06_export.zip
- 08_07_taskinfo.zip
- 08_08_merge.zip
- 08_09_screentips.zip
- 08_10_indicators.zip
- 08_11_currency.zip
- 09_01_actualcalc.zip
- 09_02_estimate.zip
- 09_03_ressched.zip
- 09_04_ignorecal.zip
- 09_05_timeline.zip
- 09_06_movesubs.zip
- 09_07_fiscal.zip
- 09_08_taskstatus.zip
- 09_09_scroll.zip
- 09_10_estimate.zip
- 09_11_personal.zip
- 09_12_pred.zip
- 09_13_partialday.zip
- 10_01_sharecustom.zip
- 10_02_doccustom.zip
- 10_03_calcworkdays.zip
- 10_05_hyperlink.zip
- 10_06_hyperfile.zip
- 10_07_commas.zip
- 11_01_formatnum.zip
- 11_02_tuneformat.zip
- 11_03_fixedcost.zip
- 11_04_costresource.zip
- 11_05_flagchange.zip
- 11_06_documentchange.zip
- 12_01_flagkey_pt1.zip
- 12_02_flagkey_pt2.zip
- 12_03_staffing_pt1.zip
- 12_04_staffing_pt2.zip
- 12_05_Event.zip
- 12_06_Event.zip
- 13_01_durhours.zip
- 13_02_durminutes.zip
- 13_03_contfields.zip
- 13_04_contcalc.zip
- 13_05_profitfields.zip
- 13_06_profitcalc.zip
- 14_01_progresschg.zip
- 14_02_progresscmp.zip
- 14_03_setup2wk.zip
- 14_04_display2wk.zip
- 14_05_filterlinks.zip
- 14_06_evallinks.zip
- 15_01_skedsetup.zip
- 15_02_percentnolinks.zip
- 15_03_sumlinks.zip
- 15_04_totallinks.zip
- 15_05_FSPercent.zip
- 15_06_Constraint.zip
- 16_01_laglead.zip
- 16_02_lagleadpercent.zip
- 16_03_findfloat.zip
- 16_04_floatpercent.zip
- 16_05_negfloat.zip
- 16_06_fixnegfloat.zip
- 17_01_invalid.zip
- 17_02_dateoptions.zip
- 17_03_noresources.zip
- 17_04_dashboard.zip
- 17_05_schedrpt.zip
- 17_06_values.zip
- 17_07_instruction.zip
Contents
-
-
-
(Locked)
Fill in duration, work, and dates quickly4m 32s
-
(Locked)
Create a hammock task4m 7s
-
(Locked)
Rename column headings3m 58s
-
(Locked)
Display a calendar's nonworking time2m 21s
-
(Locked)
Prevent duplicate resource names4m 8s
-
(Locked)
Eliminate hashtags in table columns2m 56s
-
(Locked)
Count tasks that meet a criterion4m 13s
-
Sort resources by type and name2m 28s
-
(Locked)
Fast access to your Project files3m 56s
-
(Locked)
Save a new view5m 53s
-
(Locked)
Compare individual and group allocation3m 47s
-
(Locked)
Populate a lookup table with existing values3m 10s
-
(Locked)
Summarize resource utilization3m
-
(Locked)
Hide non-working days on task bars1m 45s
-
(Locked)
Find hidden task bars4m 56s
-
(Locked)
Set additional baselines5m 6s
-
Store customized elements where you want5m 52s
-
(Locked)
Calculate work hours in a formula4m 34s
-
(Locked)
Record costs from an external system4m 52s
-
(Locked)
Change the date format in a specific view4m
-
(Locked)
Find a command4m 29s
-
Edit multiple tasks simultaneously3m 34s
-
(Locked)
Track ancillary project costs5m 24s
-
(Locked)
When leveling doesn’t eliminate overallocations9m 18s
-
(Locked)
Update parts of a baseline4m 4s
-
(Locked)
Open and save file shortcuts6m 2s
-
(Locked)
Create a cross-project dependency4m 56s
-
(Locked)
Use hyperlinks in reports to navigate to details1m 57s
-
(Locked)
Reuse lookup tables and formulas5m 23s
-
(Locked)
Customize and share the Quick Access Toolbar4m 31s
-
(Locked)
Calculate separate critical paths for several projects3m 14s
-
Shortcuts for reapplying and clearing filters2m 44s
-
(Locked)
Compare Microsoft Project editions3m 12s
-
(Locked)
Shortcuts for viewing primary and detail panes2m 47s
-
(Locked)
Flag key tasks with custom bar styles6m 45s
-
(Locked)
Designate who reports status3m 21s
-
(Locked)
Keep important fields visible in a table4m 13s
-
(Locked)
Control how a view prints5m 42s
-
(Locked)
Identify projects in a master file3m 49s
-
(Locked)
Schedule for maintenance or system switchover6m 6s
-
(Locked)
Manage negative slack in a schedule6m 40s
-
(Locked)
Build an excel report that updates dynamically from project4m 53s
-
(Locked)
Add a custom sort to the ribbon to reapply it quickly4m 18s
-
(Locked)
Evaluate management timeframes3m 35s
-
(Locked)
View progress as a percentage3m 41s
-
(Locked)
Schedule approval during next meeting5m 41s
-
(Locked)
Create a work shift that spans two days5m 28s
-
(Locked)
Display tasks that should have status3m 42s
-
(Locked)
Model scenarios with inactive tasks5m 52s
-
(Locked)
Summarize tasks in resource usage view2m 2s
-
(Locked)
Display labor cost by project section3m 57s
-
(Locked)
Copy values from one baseline to another2m 52s
-
(Locked)
Switch date constraints2m 21s
-
(Locked)
Data entry shortcuts2m 46s
-
(Locked)
Display the Task Details form in the Details pane3m 44s
-
(Locked)
Add overall project notes to project summary task2m 31s
-
(Locked)
Choose AutoSave options wisely3m 57s
-
(Locked)
Create a WBS graph with a visual report9m 25s
-
(Locked)
Find all tasks with estimated durations3m 26s
-
(Locked)
Attach an image to a timescale task bar4m 19s
-
(Locked)
Custom view, part 1: Set up a custom view4m 39s
-
(Locked)
Custom view, part 2: Set up dashboard icons8m 50s
-
(Locked)
Custom view, part 3: Group tasks by variance3m 52s
-
Custom view, part 4: Filter troubled incomplete tasks4m 1s
-
(Locked)
Find summary tasks with dependencies5m 12s
-
(Locked)
Dependencies, part 1: Setup to review link types6m 7s
-
(Locked)
Dependencies, part 2: Evaluate link types6m 34s
-
(Locked)
Find tasks with date constraints8m 15s
-
(Locked)
Find dependencies with lag or lead4m 40s
-
(Locked)
Find tasks with excessive float8m 6s
-
(Locked)
Find incomplete tasks with negative float5m
-
(Locked)
Find tasks with invalid dates4m 45s
-
(Locked)
Find incomplete tasks without resources4m 3s
-
(Locked)
Graphical report, part 1: Create a table5m 26s
-
(Locked)
Graphical report, part 2: Build a graph3m 5s
-
(Locked)
Graphical report, part 3: Fine-tune graph axes1m 48s
-
(Locked)
Find in-progress assignments3m 13s
-
(Locked)
Find when a resource is available5m 49s
-
(Locked)
Report work by resource and project4m 4s
-
(Locked)
Beware the Autolink option3m 48s
-
(Locked)
Schedule part of a project from the finish date2m 47s
-
(Locked)
Make exporting data easy5m 22s
-
(Locked)
Simplify importing with a map3m 48s
-
(Locked)
Merge data into existing rows3m 48s
-
(Locked)
Turn off screen tips before presentations3m 15s
-
(Locked)
Use indicators and option buttons5m 19s
-
(Locked)
Set currency options1m 47s
-
(Locked)
Prevent Project from calculating actual cost3m 56s
-
(Locked)
Update OLE links3m 58s
-
(Locked)
Assign resources with different schedules3m 59s
-
(Locked)
Ignore resource schedules on a task4m 29s
-
(Locked)
Use the Timeline view to control dates in a Gantt Chart view2m 51s
-
(Locked)
Remove tasks from a summary task without deleting them2m 46s
-
(Locked)
Set the fiscal year for a project3m 56s
-
(Locked)
Update assignment status from task status3m 59s
-
(Locked)
Restore window scroll bars if they go missing1m 25s
-
(Locked)
Make linked cells visible in a view's table1m 34s
-
(Locked)
Remove personal information from a Project file2m 12s
-
(Locked)
Select predecessors easily in a dropdown list2m
-
(Locked)
Set up a calendar day with partial nonworking time3m 42s
-
(Locked)
Share customized elements3m 31s
-
(Locked)
Document your customizations4m 23s
-
(Locked)
Working days, part 1: Calculate the days between two dates4m 31s
-
(Locked)
Working days, part 2: Add error test for missing dates4m 41s
-
(Locked)
Add multiple hyperlinks to a task or resource2m 54s
-
(Locked)
Add a hyperlink to a file in a custom field3m 5s
-
(Locked)
Tips for importing names from Excel6m
-
(Locked)
Format numbers, part 1: Formatting in a text field4m 45s
-
(Locked)
Format numbers, part 2: Fine-tune number formats4m 51s
-
(Locked)
Ancillary costs, part 1: Track with Fixed Cost fields5m 24s
-
(Locked)
Ancillary costs, part 2: Track with cost resources4m 58s
-
(Locked)
Change requests, part 1: Flag change requests4m 26s
-
(Locked)
Change requests, part 2: Document change requests2m 7s
-
(Locked)
Key tasks, part 1: Add flags to key tasks4m 9s
-
(Locked)
Staffing plan, part 1: Assign generic resources2m 38s
-
(Locked)
Staffing plan, part 2: Display plan in a spreadsheet7m 31s
-
(Locked)
Master project links, part 1: When subprojects go missing3m 5s
-
(Locked)
Master project links, part 2: Move a resource pool5m 8s
-
(Locked)
Format duration, part 1: Display whole hours2m 53s
-
(Locked)
Format duration, part 2: Add minutes to display3m 54s
-
(Locked)
Contingency funds, part 1: Set up custom fields5m 1s
-
(Locked)
Contingency funds, part 2: Calculate used funds4m 11s
-
(Locked)
Project profit, part 1: Set up custom fields3m 51s
-
(Locked)
Project profit, part 2: Calculate profit percentage6m 9s
-
(Locked)
Open and save file shortcuts4m 31s
-
(Locked)
Progress comparisons, part 2: Update and compare5m 25s
-
(Locked)
View upcoming work, part 1: Create two-week filter6m 44s
-
(Locked)
View upcoming work, part 2: Display upcoming work3m 36s
-
(Locked)
Tasks with no dependencies, part 1: Create filter2m 15s
-
(Locked)
Tasks with no dependencies, part 2: Evaluate unlinked tasks4m 8s
-
(Locked)
Tasks with no dependencies, part 3: Count work tasks3m 29s
-
(Locked)
Tasks with no dependencies, part 4: Calculate percent7m 18s
-
(Locked)
Find summary tasks with dependencies5m 20s
-
(Locked)
Finish-to-start links, part 1: Setup6m 9s
-
(Locked)
Finish-to-start links, part 2: Calculate FS percentage4m 21s
-
(Locked)
Calculate percentage of tasks with date constraints6m 57s
-
(Locked)
Find tasks with lead time3m 46s
-
(Locked)
Calculate the percentage of tasks with lag or lead5m 32s
-
(Locked)
Count tasks with excessive float4m 23s
-
(Locked)
Calculate the percentage of tasks with excessive float4m 38s
-
(Locked)
Count tasks with negative float4m 7s
-
(Locked)
Adjust a schedule to remove negative float3m 13s
-
(Locked)
Find and correct tasks with invalid dates4m 58s
-
(Locked)
Avoid invalid dates4m 16s
-
(Locked)
Find incomplete tasks without resources4m 27s
-
(Locked)
Create a schedule quality dashboard5m 21s
-
(Locked)
Create schedule assessment report4m 47s
-
(Locked)
Add best practice values to table3m 41s
-
(Locked)
Add instructions and menu entries3m 36s
-
Conclusion1m 52s
-
(Locked)