Dale Howard Microsoft Project MVP
Dale Howard Microsoft Project MVP
  • 104
  • 459 600
Secret Filters in Microsoft Project!
Did you know that Microsoft introduced 11 new task filters back in the 2013 version of Microsoft Project, but NEVER announced it? Among those were powerful date-sensing filters that can detect the current week and month. In this episode of 'Microsoft Project Secrets,' I'll guide you through these hidden filters and show you how to leverage them to keep your schedule on track. 🚀
These date-sensing filters allow you to easily view tasks due this week, milestones due this month, and even tasks starting soon-automatically adjusting based on the current date. This makes managing your project timeline far more dynamic and insightful. With over 20 years of experience as a Microsoft Project MVP, I'll show you exactly how to make the most of these powerful filters and why Microsoft should have bragged about them long ago.
For more Microsoft Project tips and tricks, check out my blog:
📰 www.dalehowardmvp.com/microsoft-project-tips-and-tricks/
💎 Download your Quick Access toolbar for Free Here:
www.dalehowardmvp.com/free-quick-access-toolbar
✅ Download your Free Quality filters here:
www.dalehowardmvp.com/free-microsoft-project-quality-filters/
If you find this guide helpful, be sure to give the video a thumbs up, leave a comment, and subscribe for more Microsoft Project tips and tricks! 👍💬
✉ If you have a topic or question you'd like me to create a video about, you can submit your questions at:
www.dalehowardmvp.com/contact-dale/
#MicrosoftProject #DateSensingFilters #ProjectManagement #HiddenFeatures #DaleHowardMVP
มุมมอง: 3

วีดีโอ

Automatic Gantt Bar Colors in Microsoft Project
มุมมอง 134 ชั่วโมงที่ผ่านมา
Want to make your Gantt chart pop with custom colors in Microsoft Project? In this video, I'll show you how to automatically format Gantt bar colors based on different tasks in your project schedule. 🚀 Whether you're managing design, construction, or specialized tasks, having Gantt bars color-coded by role or type helps you quickly understand your schedule at a glance. With over 20 years of exp...
2-Week Lookahead: Two Options in Microsoft Project
มุมมอง 334 ชั่วโมงที่ผ่านมา
Have you ever wanted to filter for ONLY the tasks starting in the next 2 weeks? What about 3, 4 or any number? In this video, I'll show you two different ways; one that takes a little bit to setup and the other is leveraging the out of the box features. Let's go! 🚀 Here's the formula you'll need: ProjDateAdd([Current Date],"10d","Standard") For more Microsoft Project tips and tricks check out m...
Keep Your Project Files Safe: Automate Backups in MS Project
มุมมอง 154 ชั่วโมงที่ผ่านมา
Did you know that you can set up automatic backups for your Microsoft Project files to keep your work safe and secure? In this quick tip video, I'll show you how to easily create automatic backups so you never lose your important project data. 🚀 With over 20 years of experience as a Microsoft Project MVP, I understand the importance of safeguarding your hard work. In this guide, I'll walk you t...
Quick Tip: Find Missing Baselines in MS Project
มุมมอง 364 ชั่วโมงที่ผ่านมา
Did you know that missing baselines in Microsoft Project can be easily flagged using a simple formula? In this quick tip video, I'll show you exactly how to find and flag tasks that are missing baselines, so you can keep your project on track! 🚀 This method is straightforward and only requires a single formula to get the job done: Formula: IIf([Baseline Start] = ProjDateValue("NA"), True, False...
Summarize Resource Work in Microsoft Project
มุมมอง 899 ชั่วโมงที่ผ่านมา
Have you ever wondered if it's possible to create a Resource Work Summary for every summary task section in Microsoft Project? Well, I thought it wasn't possible too-until I dug in and found the solution! 🌟 In this video, I'll show you step-by-step how to create a Resource Work Summary for your Microsoft Project schedules. I came across this question in the forums, and what seemed impossible at...
Why Are My Dates Moving in Microsoft Project?
มุมมอง 4419 ชั่วโมงที่ผ่านมา
Did you know that unexpected date changes in Microsoft Project can often be traced back to how calendars are set up? In this video, I'll explain why your dates might be moving and how to use Project, Task, and Resource calendars to take back control of your schedule. With over 20 years of experience as a Microsoft Project MVP, I understand how crucial Project, Resource, and Task calendars are f...
How Project Calendars Work in Microsoft Project
มุมมอง 5921 ชั่วโมงที่ผ่านมา
Did you know that there are 3 different types of calendars in Microsoft Project? In this video, I'll show you how calendars work in Microsoft Project, including the different types of calendars and their uses. Having worked extensively with Microsoft Project, I understand how crucial Project, Resource, and Task calendars are for effective scheduling. In this guide, I'll show you how to use Proj...
How to Delete Projects in Project for the Web (It's Not Obvious!)
มุมมอง 179หลายเดือนก่อน
In this video, I'll show you how to delete unwanted projects in Microsoft Project for the Web. As a new user myself, I struggled to find this hidden feature, but I've discovered the step-by-step process to clean up your project list. Don't let old test projects clutter your workspace - watch now as I guide you through streamlining your Project for the Web experience! I'll walk you through each ...
Creating and Using Task Dependencies in Project for the Web
มุมมอง 2162 หลายเดือนก่อน
Did you know that effectively managing task dependencies can make or break your project schedule? Hi, I’m Dale Howard, a 21-time Microsoft Project MVP. In this video, I'll show you how to create and manage task dependencies in Project for the Web. You’ll learn the different types of dependencies, how to link tasks efficiently, and avoid common pitfalls that can derail your projects. Join me to ...
Change the Project Owner in Project Online or Project Server
มุมมอง 2372 หลายเดือนก่อน
If you're using Microsoft Project Server or Project Online, you'll sooner or later need to change the owner of a project. Don't forget this is a two-step process. Don't forget to change the Task Status Manager. In this video, I'll show you how to change both so you get all of your updates on your schedule. If you find these tips helpful, please leave a comment or if you have other topics/questi...
Quickly Create a Master Project in Project Online or Project Server
มุมมอง 1353 หลายเดือนก่อน
Sooner or later, you'll need to create a Master Project in Microsoft Project Online or Project Server. In this video I'll show you the quick way to create a 'Read Only' or editable Master Project. Wait until you see how EASY this is! For more Microsoft Project tips and tricks check out my blog 📰 www.dalehowardmvp.com/microsoft-project-tips-and-tricks/ 💎Download your Free Ribbon and Quick Access...
Free Ribbon and Toolbar for Microsoft Project Professional
มุมมอง 1243 หลายเดือนก่อน
If your organization uses Microsoft Project Online or Project Server then I have a FREE custom Quick Access Toolbar and a Ribbon to speed up your scheduling and save you a ton of time. In this video I'll show you how to import and configure them. *Prerequisite* - Before you watch the whole video, go here 💎www.dalehowardmvp.com/free-ppm-microsoft-project-ribbon-and-toolbar/ to download your file...
Create Custom Columns in Project for the Web
มุมมอง 1063 หลายเดือนก่อน
Did you know that you can create custom columns in Project for the Web? In this video, I'll show you just that with a few tricks you'll be able to do this. Bonus: In addition, I'll show you the trick to save it as a Template to use for other projects in the future. For more Microsoft Project tips and tricks check out my blog 📰 www.dalehowardmvp.com/microsoft-project-tips-and-tricks/ 🖋️ If you f...
Filter for Critical Milestones in Microsoft Project
มุมมอง 1633 หลายเดือนก่อน
Have you ever wanted to filter tasks that are both Milestones AND Critical? In this video, I'll show you just that with a few tricks you'll be able to do this with no problem across ALL of your projects. For more Microsoft Project tips and tricks check out my blog 📰 www.dalehowardmvp.com/microsoft-project-tips-and-tricks/ 💎Download your Quick Access toolbar for Free Here www.dalehowardmvp.com/f...
Filter Tasks That Span Across a Weekend in Microsoft Project
มุมมอง 873 หลายเดือนก่อน
Filter Tasks That Span Across a Weekend in Microsoft Project
Using the Split Task Tool in Microsoft Project
มุมมอง 2474 หลายเดือนก่อน
Using the Split Task Tool in Microsoft Project
How to Create a Master Project in Microsoft Project
มุมมอง 2224 หลายเดือนก่อน
How to Create a Master Project in Microsoft Project
Entering Task Progress in Microsoft Project
มุมมอง 4564 หลายเดือนก่อน
Entering Task Progress in Microsoft Project
Using Expense Cost Resources in Microsoft Project
มุมมอง 1704 หลายเดือนก่อน
Using Expense Cost Resources in Microsoft Project
How to Use Budget Cost Resources in Microsoft Project
มุมมอง 4144 หลายเดือนก่อน
How to Use Budget Cost Resources in Microsoft Project
Using Fixed Costs in Microsoft Project
มุมมอง 1844 หลายเดือนก่อน
Using Fixed Costs in Microsoft Project
What is "Effort Driven" in Microsoft Project?
มุมมอง 4324 หลายเดือนก่อน
What is "Effort Driven" in Microsoft Project?
What should my Start date be? MS Project
มุมมอง 1334 หลายเดือนก่อน
What should my Start date be? MS Project
Alternate Cost Rates in Microsoft Project
มุมมอง 784 หลายเดือนก่อน
Alternate Cost Rates in Microsoft Project
What Are Task Types in Microsoft Project?
มุมมอง 3175 หลายเดือนก่อน
What Are Task Types in Microsoft Project?
Save a Project as a Template..Easy Peasy!
มุมมอง 5838 หลายเดือนก่อน
Save a Project as a Template..Easy Peasy!
Dynamic Task and Gantt Bar Formatting
มุมมอง 4268 หลายเดือนก่อน
Dynamic Task and Gantt Bar Formatting
Formatting Summary Tasks and Milestones - EASY!
มุมมอง 1.2K8 หลายเดือนก่อน
Formatting Summary Tasks and Milestones - EASY!
Show/Hide Summary Tasks and Outline Numbers
มุมมอง 1K8 หลายเดือนก่อน
Show/Hide Summary Tasks and Outline Numbers

ความคิดเห็น

  • @youme9523
    @youme9523 4 วันที่ผ่านมา

    It is Great.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP วันที่ผ่านมา

      Thank you for that kind comment. And thanks for watching my TH-cam channel! :)

  • @dandanahy8841
    @dandanahy8841 9 วันที่ผ่านมา

    Hi Dale - Is there a way to add more options to choose from in the "Text Styles" and then the drop down box called "Items to Change". I have used this section in the past but I have always found it to be very limited. I guess, I would love to see a method, if it exists, to add a Custom Field or two to the drop down box, as I use the Marked Tasks field for a variety of cases and so I wouldn't want to tie it to a format. Great video and Thanks!!!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP วันที่ผ่านมา

      No, there is no way to add more items to the Text Styles dialog. Sorry, but thanks for your kind comments!

  • @dandanahy8841
    @dandanahy8841 9 วันที่ผ่านมา

    Hi Dale - The Gantt Bars are kinda hard to see. Is there a way to change the color of each bar for the respective 4 options (ie Driving Predecessors, etc) so they stand out better? I believe there is a way but it must not be obvious. Great video. Thanks!!!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP วันที่ผ่านมา

      Excellent question! Yes, there is a way to change the colors. First of all, open any project and then select a task. On the Gantt Chart Format ribbon, click the Task Path pick list button and select ALL FOUR of the options, so that all four Gantt bar colors are displayed. Then double-click anywhere in the white part of the Gantt Chart pane to display the Bar Styles dialog. Down near the bottom of the list of the bar styles, you should see the definition for the four Task Path items. Change the colors there. Let me know how this works for you. Thanks for asking!

  • @sepuk
    @sepuk 11 วันที่ผ่านมา

    This filter is no more present in MP

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 11 วันที่ผ่านมา

      Hmmm. I can still see the Critical filter in the Critical Path section of the Filters menu, so I'm not sure what is going on with your Project for the Web instance. If this issue continues, you might want to reach out to Microsoft Support and open an incident with them. Sorry, but hope this helps.

  • @udayanbhanot2509
    @udayanbhanot2509 19 วันที่ผ่านมา

    Yet another brilliant video. Really super useful.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 18 วันที่ผ่านมา

      Thanks for that nice comment, and thanks for watching my TH-cam videos!

  • @milner267
    @milner267 21 วันที่ผ่านมา

    Hey Dale, thank you for sharing. How would you advise someone who has a director's request to reset the baseline, to the originally agreed dates, keeping in mind that back then, the schedule was at level 2, whereas til today, you now have a level 5 schedule?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 21 วันที่ผ่านมา

      Thanks for your question and thanks for watching my TH-cam videos. There is a lot of information missing in your question, such as whether the level 3, 4, and 5 tasks have already been baselined, whether you reset Baseline 0 to the new current dates and not the original dates, and whether you backed up your original baseline into one of the numbered Baseline sets of fields, such as Baseline 1 for example. If Baseline 0 contains the original dates of the level 1 and 2 tasks, then select only the new tasks added at levels 3, 4, and 5, and then baseline only the selected tasks. Doing so will maintain the original baseline for the level 1 and 2 tasks, while setting the current baseline Start and Finish dates for the level 3, 4, and 5 tasks. That's probably the best I can do for you without being able to look at your project. Hope this helps.

  • @kyleself3645
    @kyleself3645 23 วันที่ผ่านมา

    I check for your answers all the time. They are super helpful. This one saved me a lot of anguish.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 22 วันที่ผ่านมา

      Thanks for your kind comment, my friend! And thanks for watching my TH-cam videos as well!

  • @udayanbhanot2509
    @udayanbhanot2509 25 วันที่ผ่านมา

    Brilliant. Thanks. Keep it up.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 25 วันที่ผ่านมา

      Thanks for the kind comment, and for watching my TH-cam videos! And you are more than welcome.

  • @udayanbhanot2509
    @udayanbhanot2509 25 วันที่ผ่านมา

    You are a genius! Why aren't there more videos on TH-cam that cover the subject comprehensively and clearly? Yes it is 6 minutes and yes the Universe will age 6 minutes but at least I learnt all the elements I needed with this issue. Keep it up. I've subscribed and I will go through your training.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 25 วันที่ผ่านมา

      Wow, thanks! Such kind comments. Thanks so much for watching my TH-cam videos!

  • @pankajkeshari1050
    @pankajkeshari1050 28 วันที่ผ่านมา

    Nice

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 28 วันที่ผ่านมา

      Thanks for that kind comment, and thanks for watching my TH-cam videos!

  • @dimitriskotrogiannis9749
    @dimitriskotrogiannis9749 28 วันที่ผ่านมา

    Very detailed!!!!!!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 28 วันที่ผ่านมา

      Thanks for that kind comment, and thanks for watching my TH-cam videos!

  • @dimitriskotrogiannis9749
    @dimitriskotrogiannis9749 28 วันที่ผ่านมา

    Ευχαριστούμε!

  • @TG-ck2jg
    @TG-ck2jg หลายเดือนก่อน

    Thank you. This is very helpful

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 29 วันที่ผ่านมา

      Glad it was helpful! Thanks for watching my TH-cam channel!

  • @faridsaliba3530
    @faridsaliba3530 หลายเดือนก่อน

    Hi Dale, please help me adjust a task duration to 1year period noting that the other tasks in my project are set in days. Thanks for your channel

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      Good question. For the task in question, take note of its current Start date, and then calculate what the Finish date should be that is one year from the Start date. For example, today is 09/18/24, so one year from today would be 09/18/25. Enter a "starter" Duration value in days that approximates one year of time. For example, if I enter a "starter" Duration of 240 days, the Finish date is 09/04/25. Then continue increasing or decreasing the Duration until the Finish date is the desired one-year date. In my case, considering my company holidays, the Duration value I need is 250 days. Since Microsoft Project does not allow us to enter a Duration value in Years, the process I documented in how I recommend you do it. Hope this helps.

    • @faridsaliba3530
      @faridsaliba3530 29 วันที่ผ่านมา

      @@DaleHowardProjectMVP, Thank you for your response and explanation. It is the same procedure that I use to add a one-year period. In fact, I thought that I missed a detail. I hope that the Microsoft Project will add this feature. Sometimes, tasks must be finished in one year or more disregarding the holidays. Thank you for your channel 💐

  • @marcialfalconi7658
    @marcialfalconi7658 หลายเดือนก่อน

    Hi Dale, thanks for the video. If want to do Enterprise project in Project Online how I can to the same? Additionally is possible to create a Enterprise project and site project template a link together?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      Yes, you can accomplish both of these objectives, but you will need to be a Project Online application administrator. First, create a project in Microsoft Project, then click File > Save As > Save. In the Save to Project Web App dialog, click the Type pick list and select the Template item, and then click the Save button. This will save the project as an enterprise project template. Next, you will need to create the Project Site template in SharePoint. Finally, you will need to create a new Enterprise Project Type (EPT) that utilizes both your enterprise project template and your new Project Site template. All projects created in PWA from this new EPT will meet your objective. Hope this helps.

  • @kojooffeihammond510
    @kojooffeihammond510 หลายเดือนก่อน

    Thank you very much sir for the information shared

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      You are more thank welcome, my friend! And thanks for watching my TH-cam channel!

  • @thomasmoen3749
    @thomasmoen3749 หลายเดือนก่อน

    Thank you, you just saved me lots of trouble!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      You are more than welcome for the help, my friend! Thanks for that kind comment, and thanks for watching my TH-cam videos. :)

  • @jefffuhr2393
    @jefffuhr2393 หลายเดือนก่อน

    Instant *Subscribe* and *Like*. Best wishes for your channel, Dale. God bless!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      Wow, THANKS for this very kind comment! And thank you for watching my TH-cam videos. :)

  • @abiraazhar2
    @abiraazhar2 หลายเดือนก่อน

    My print view was showing extra months, the zoom feature instantly helped. Thank you for this video!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      You are more than welcome for the video, my friend! Thanks so much for watching my TH-cam videos, and for letting me know how much help it provided for you. That makes me feel REALLY good! :)

  • @jmck1960ful
    @jmck1960ful หลายเดือนก่อน

    Thank you Dale!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      You are very welcome, and thanks for watching my TH-cam channel!

  • @dimitriskotrogiannis9749
    @dimitriskotrogiannis9749 หลายเดือนก่อน

    Thanks for sharing your knowledge, this video it helps me to a project with 2000 tasks............Project have very slow loading with enable Automatic Recalculation😀

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      Glad it helped! Thanks again for watching my TH-cam channel!

  • @dimitriskotrogiannis9749
    @dimitriskotrogiannis9749 หลายเดือนก่อน

    Hello, I am a graduate student and I would like your help. I have a project with 2000 tasks. I insert the tasks with their links and I'm having trouble assigning resources. The program is slow to process the data I enter, about 3-4 minutes each time. Am I doing something wrong or is the amount of data large?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      Thanks for this good question! And thanks for watching my TH-cam videos. When you manage a large project, you can run into a significant amount of slowdown as Microsoft Project recalculates the project. That is why I recommend you turn off automatic recalculation when editing the project, and then manually recalculate the project whenever you are ready to do so. Take a look at the following TH-cam video on this subject: th-cam.com/video/SEZcTz7WLHQ/w-d-xo.html

  • @jmck1960ful
    @jmck1960ful หลายเดือนก่อน

    Okay - finally i find a resource that explains step by step - the how and why - so many of these guys muse click to music, or speed through critical info - Thanks Dale for a practical and rational guide to POL - I'll look but if you haven't already please do a video on the setting up of POL Pages such as detail project info etc and how to edit these...Thank you!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      Wow, that you so VERY MUCH for that extraordinarily kind comment and for watching my TH-cam videos. Regarding your idea for a future video, I may produce a video like that in the future, but I am spending most of my time on videos of enter users, such as project managers. However, let me give you an excellent reference for you to use as a Project Online app admin. It is a book which I co-authored, writing about 400 pages out of the total of 900 pages. If you do not already have this book, but it and start reading it. You will see the same step by step approach repeated in this book: www.amazon.com/Ultimate-Application-Administrators-Project-Online/dp/099124642X

    • @jmck1960ful
      @jmck1960ful หลายเดือนก่อน

      @@DaleHowardProjectMVP book ordered and thank you for the redeeence!

  • @emwhite6796
    @emwhite6796 หลายเดือนก่อน

    thanks Dale for making this quick and easy for me!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      You are very welcome. Thanks for that kind comment and thanks for watching my TH-cam videos!

  • @policani
    @policani หลายเดือนก่อน

    I'm managing an international project plan with teams in the United States and Australia where each team has different holidays and working hours. How do I manage two different calendars across different time zones with different holidays based on location of the team resource?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      Thanks for watching my TH-cam channel and for asking this excellent question! Create the US calendar with your US holidays and working schedule. Create the Australia calendar with Australian holidays, BUT enter the Working Schedule for each day based on the conversion from Australian time to YOUR time zone. For example, I am in the Eastern time zone, and suppose I am creating an Australian calendar. 8:00 AM in Sydney, Australia is actually 6:00 PM in the Eastern time zone, so I would set the Start time of each day as 6:00 PM in the Australian calendar. You need the times on each of these calendars to be based on YOUR time zone in the US. Make sense? Hope this helps.

  • @HeidiSutherland-n4t
    @HeidiSutherland-n4t หลายเดือนก่อน

    Couple questions. Can you progress on checklist items? How is checklist different from Sub-Tasks? How to know which one to use when?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP หลายเดือนก่อน

      Wow, really good questions! Thanks for watching my TH-cam videos, and thanks for leaving your questions. To answer your questions: 1. No, there is no way to enter progress on a check list item. It is either done or not done, with no progress options in between. 2. Regarding when to use checklists and when to use subtasks, I follow a methodology of not using tasks with a Duration of less than 1 day. So, suppose that my project needs a series of 8 tasks, each of which will take only one hour. In that situation, I would create a single task with a Duration of 1 day, and then add those 8 tasks as checklist items. Hope this helps.

  • @DanTaylor-f9k
    @DanTaylor-f9k 2 หลายเดือนก่อน

    Love your videos, Dale. Is there a way you can view a specific dependency chain clearly? I know you can get the tasks in a chain to highlight.. But say for example you have a master project, with multiple sub projects. There are over 7k tasks in the whole project. Is there a way you can pick one task, and easily view the whole dependency chain for that item without it keeping the noise of all the other tasks? Appreciate every thing you do, Dale!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Thanks for the question and thanks for watching my TH-cam videos! From your question, it sounds like you already know about the Task Path feature in Microsoft Project. It is a shame that Microsoft implemented this feature by changing the Gantt bar color of Predecessors, Driving Predecessors, etc. instead of filtering to show only the tasks in question. If that feature does not work for you, you might want to try out the Project VBA macro referenced in the following blog post article: www.thepmoprofessionals.com/2018/08/03/trace-predecessors-and-successors-in-ms-project/ Those are the only options I am aware of that might be able to address your needs. Hope this helps.

  • @doodle7639
    @doodle7639 2 หลายเดือนก่อน

    I had to put 1.25 times the playback LoL!!...now i know why people talk of Agile

  • @MrMauro9101
    @MrMauro9101 2 หลายเดือนก่อน

    Muchas gracias por tu ayuda, y asistencia, fue muy útil. Thanks for all your information. Very helpful.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      You are more than welcome, my friend! Thank you for that kind compliment and thanks for watching my TH-cam videos!

  • @dronepilot1840
    @dronepilot1840 2 หลายเดือนก่อน

    Excellent as always. Thanks Dale!!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      You are more than welcome, my friend! And thanks for watching my TH-cam channel. :)

  • @soooomagy
    @soooomagy 2 หลายเดือนก่อน

    Thank you

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      You are more than welcome, my friend! And thanks for watching my TH-cam videos.

  • @gkprojectmanagement
    @gkprojectmanagement 2 หลายเดือนก่อน

    Just discovered this channel, thankyou. MS Project seems like a dying app these days, what with Monday and all the other mini apps, but I use MS Project all the time in my work, maybe it's just the level of projects one deals with.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Thanks for watching my TH-cam videos! Yes, you are at least partially right about Microsoft Project, as it has not gotten much attention from Microsoft, in favor of the web-based Project for the Web (now called Planner Premium). However, after nearly 5 years of development, Project for the Web cannot even come close to the features and functionality offered by the Microsoft Project desktop app. Many of us have told Microsoft that we ARE NOT going to abandon Microsoft Project, and hopefully, their leaders will get the message and begin spending money on Microsoft Project again. And you are right that the tool we should use depends on the level of projects that we have to deal with. Thanks also for this very nice comment. I appreciate it!

    • @gkprojectmanagement
      @gkprojectmanagement 2 หลายเดือนก่อน

      @@DaleHowardProjectMVP I've been trying to do MS Project videos om my channel, well, 4 years ago, but landed on general project management as that seemed the way to go to get noticed. Just began again after Covid stuff and wondering whether to do MS Project again. You seem t be doing well! Keep doing what you're doing! I have a lot of your videos to go though. :)

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Thanks for that very kind comment, my friend! :)

  • @dandanahy8841
    @dandanahy8841 2 หลายเดือนก่อน

    Dale - great video. One question. Will the Unique IDs start over at say 0 or at least 1 every time you call up your template to use and save as a new project or does the numbering sequence for the Unique IDs continue from the last Unique ID created in your template? I hope this makes sense.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Good question! No one has ever asked me this question before. Yes, when a new project is created from a template, Microsoft Project DOES maintain the Unique ID numbers from the project template in the new project. In other words, each project created from the template is a "mirror image" of everything in the template. Thanks for asking your question, and for watching my TH-cam videos!

    • @dandanahy8841
      @dandanahy8841 2 หลายเดือนก่อน

      ​@@DaleHowardProjectMVP - Hi Dale - I tested the process based on my question and you're correct. I also tried it with a Sanitized version (ie all tasks removed except for UID "0") for a Template in order keep the structure of the file for future use on other projects. When I did it that way, then, the first new task that I added, after calling up the Template, has a UID that is "1" which I'm happy to see (otherwise mine would have been 17000+). Thanks again for all your great videos and responses. Let me know when you make it back to St Louis.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Thanks for your kind comments! :)

  • @joseph60jordan
    @joseph60jordan 2 หลายเดือนก่อน

    Just did this on a MS Project Gantt Chart for a proposal. I never would have known how to do this without your video, Dale!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Such a kind comment. Thanks for sharing and thanks for watching my TH-cam videos!

  • @ThangTranVan-NT
    @ThangTranVan-NT 2 หลายเดือนก่อน

    Thank you very much.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      You are welcome! Thanks for watching my TH-cam videos.

  • @KatherineWhan
    @KatherineWhan 2 หลายเดือนก่อน

    Thanks for this video. Trying to determine the number of subscriptions needed for a large grant with about 20 direct resources working on tasks and an additional 25 stakeholders interested in tracking the progress/roadmap. Would you recommend 1 power user get Plan 5 and the other direct users get plan 3? Or could we get away with 5 power users at plan level three enabled to edit and mark task % complete? In the latter scenario, could the rest of the team view the project with Office 365? Or would they need a subscription?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Oh, good question! Thanks for asking and thanks for watching my TH-cam videos. In your situation, I do not think that the one "power user" would need a Project Plan 5 license. Instead, get a Project Plan 3 license for your power users. For the team members who are working on tasks in the project, each of them would need a Project Plan 1 license to be able to view and update their tasks in Project Web App. Hope this helps.

    • @KatherineWhan
      @KatherineWhan 2 หลายเดือนก่อน

      @@DaleHowardProjectMVP Thanks! Very helpful

  • @alphastarconsultant
    @alphastarconsultant 2 หลายเดือนก่อน

    can you have it "show on card" like you are able to in planner?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      No, that is not possible. You can only see the Checklist items in the Details pane on the right side of the project. But thanks for asking! And thanks for watching my TH-cam videos!

    • @alphastarconsultant
      @alphastarconsultant 2 หลายเดือนก่อน

      @@DaleHowardProjectMVP Thanks Dale! Sucks we can't do that with Project but we can with Planner

  • @Abdulrahman-yb7mn
    @Abdulrahman-yb7mn 2 หลายเดือนก่อน

    How to create a bar chart without assigning particular calendar day ( Ex : Task A : Duration 2 days : Start day 1 )

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Thanks for watching my TH-cam videos! Yes, there is a way to hide the day of the week as well. Double-click the Timescale bar and then select the Bottom Tier tab. Click the Label pick list button and select a choice such as D1, D2, D3... (From Start). Hope this helps.

  • @cticeh
    @cticeh 2 หลายเดือนก่อน

    Excellent video Dale as always thank you. Just one question I have my schedules saved in a SharePoint document library does the functionality still work or do I need to save the schedules locally somewhere? I have the Project Managers saving all their schedules in the SharePoint document library?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Thanks for watching my TH-cam videos! You will need to save all of your projects locally, such as on a shared network drive. Cross-project dependencies will not work in a SharePoint document library. Thanks for asking. Hope this helps.

  • @abayomiayodeji-s6w
    @abayomiayodeji-s6w 3 หลายเดือนก่อน

    can i use Microsoft project to create a master project for approximately 100 projects?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 2 หลายเดือนก่อน

      Thanks for watching my TH-cam videos! Yes, it is possible to create a master project consisting of about 100 subprojects in Microsoft Project. However, you would need a TON of memory in your computer, probably the maximum amount of RAM your computer can take. Plus, even with lots of memory, I think you will find that Microsoft Project is pretty slow in responding to changes you make in any of the subprojects. Take a look at my TH-cam video on turning off the automatic recalculation feature, which is probably what you would want to do with a master project of this size. Good luck! And hope this helps.

  • @geoffreymutegi4918
    @geoffreymutegi4918 3 หลายเดือนก่อน

    Rather interesting and a wonder.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 3 หลายเดือนก่อน

      Thanks for watching my TH-cam videos and for making this interesting comment! :)

  • @geoffreymutegi4918
    @geoffreymutegi4918 3 หลายเดือนก่อน

    Extremely enlightening

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 3 หลายเดือนก่อน

      Thanks for watching my TH-cam channel, and thanks for that nice comment! :)

  • @dandanahy8841
    @dandanahy8841 3 หลายเดือนก่อน

    Hi Dale, I ran through several scenarios with the initial setup as you show and seeing also that their Peak % is at 100% for the original Work Resource. When I add a helper Work Resource everything works as you say it should. Which is great, however, when I start with a single work resource or multiple ones, with their Peak % greater than 100%, I don't get a proportional split with the addition of a helper work resource using an Assignment value of 100%. Can you help me understand why that happens as it doesn't seem to match a real world situation. The setup I'm referring to is when someone is using Fixed Duration with Effort Driven On. Thanks in advance.

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 3 หลายเดือนก่อน

      Hi, Dan - Thanks for the question. Fellow TH-camrs, because of the complexity of Dan's question, I asked him to send me the project via e-mail, and I answered his question through e-mail. The answer is WAY TOO LONG to post in his forum.

  • @dandanahy8841
    @dandanahy8841 3 หลายเดือนก่อน

    Dale - another great video. Question - is there any problem or issues that might arise if a PM decides to change either the task type and/or effort driven selection after a task has already started? Thanks, Dan Danahy

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 3 หลายเดือนก่อน

      Dan -- Changing the Task Type on a task after the task has already started CAN change the behavior of the task if you change one of the three variables in the Microsoft Project scheduling engine. But the change in behavior will exactly match what I document in this video. Thanks for asking, and thanks for watching my TH-cam channel!

  • @dandanahy8841
    @dandanahy8841 3 หลายเดือนก่อน

    Dale - another great video. Thank you for sharing!!!

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 3 หลายเดือนก่อน

      Glad you enjoyed it! Thanks for watching my TH-cam channel.

  • @dandanahy8841
    @dandanahy8841 3 หลายเดือนก่อน

    A great video on this topic. Question - would having more than one Resource assigned make a difference in the way MS Project calculates, for instance, Peak %?

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 3 หลายเดือนก่อน

      No, having multiple resources on the task will not impact how Microsoft Project calculates the Peak value, since this value is calculated for each resource individually. Thanks for asking, and thanks for watching my TH-cam videos!

  • @m55m.
    @m55m. 3 หลายเดือนก่อน

    Nice one 💯

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 3 หลายเดือนก่อน

      Thanks for that kind comment and for watching my TH-cam channel!

  • @carterjoseph78
    @carterjoseph78 3 หลายเดือนก่อน

    Excellent and clear explanation… Few of the mandatory videos to see in the way of mastering MS projects … Thanks so much

    • @DaleHowardProjectMVP
      @DaleHowardProjectMVP 3 หลายเดือนก่อน

      You're very welcome! Thanks for sharing such nice comments and for watching my TH-cam videos!