Free Project Management Tools - Tutorials,Ebooks and Setups

Consider this project as an example here in this tutorial. Let us try to show only activity which finish on 04-Jul-18. What we generally do is, we create a filter like this: But you will notice that the screen goes blank without showing any activity. But why does this happen? Let us know the solution now. You need to show the time of activity by going to Edit, User Preferences , Dates tab, In “Time” section, click on “24 hour” Now you can see the date format showing the Time for start and finish. You should have noticed by now that when we created a filter, primavera will treat the time as 00:00 by default. That’s why P6 can not find any activity. So let us modify the filter again to cover the entire day like this. Now, P6 will  show  the activity which has finish date of 04-Jul-18. That's it friends. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, sha

How to remove all Hyperlinks in Excel Hyperlinks help users to go to another place instantly in the excel.  You can hyperlink to various places wherever you wish to land. One can link to Existing file or web page, place in the document, create a new document or  email address. It is very easy to remove a single hyperlink by just right clicking on the cell and select remove hyperlink. But, if you want to remove multiple hyperlinks, it would be a tedious job to do one by one. You can do that in a single go using the following trick. Select the column or range where you want to remove all the hyperlinks and then Go to Home tab, in the editing group, in the clear drop-down menu click Remove hyperlinks . That's it, in this way you can remove all the hyperlinks in the excel sheet in a second. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a commen

In Primavera when we use the default Filter called “Critical”, it will show the critical path for the entire project ending with the last activity of the project. If we want to show critical path for an specific activity which is somewhere in middle of project, but not the last one. Now, let us see in this tutorial how to do that? We will be using “Multiple float paths” feature. Press F9 or go to Tool and then Schedule Click on Options and then go to Advanced tab Tick the Checkbox “Calculate multiple float paths” Check “Free Float” In “Display multiple float paths ending with activity”, you choose the activity you want the critical path ending with. In “Specify the number of paths to calculate”, Choose “1” Click Close and Run Schedule. Now in the Activity Table, Right click and select on Group and Sort. Under Group by, select “Float Path” . To hide all unnecessary activities, you can also create a Filter like Float Path 1. That's it Friends, Now we have the Criti

Combine Multiple Worksheets Into A Single Workbook In Ms Excel |Excel | dptutorials If you have got two excel files to merge, you can simply copy or move sheets from one file to another manually by using the right click option. But if you have multiple excel files that have to be merged or combined into one file, the easier and faster way would be using the VBA macro as an automated process. Below is the code that copies all the sheets from excel files that you select into a single workbook. please be remember that we should not open any of these files which need to be merged. Download the code from here: https://ift.tt/2sK4aRH  Consider this as an example, that we have got some 10 files in a folder like this and let us combine these sheets into one single workbook. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thou

In this video , let us learn about EPS Enter prise project structure and OBS Organization Breakdown structre. This video describes how to define EPS, that will be used to Organize and manage the projects in any organisation. EPS is nothing but hierarchical structure that identifies the company vide projects and enables organizing and management of those projects. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR