Free Project Management Tools - Tutorials,Ebooks and Setups

How To Renumber Activity IDs For All Activities In An Ascending Order In Primavera P6 | dptutorials In this video tutorial, let us learn how we can renumber activity IDs in an ascending order perfectly. 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 ************************************************************** You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6 Twitter :  http...

Excel Tricks : Best Way To Create Plan Vs Actual Graph In Excel || Excel Tips || dptutorials In this tutorial, let us learn the best way to create plan vs actual graph in Excel. This chart as shown on left side is what generally people tend to use. Now see on to the right side this is what i prefer the most, because this adds value to your visual reports. Now let's get into the working file to see how it is done. 1. First, Select the entire data set. 2. Go to Insert tab 3. In the charts section, click on the 2D clustered Column Chart 4. Chart gets created, To Change the look of the Plan values. Click on any of the bars of Plan values. Right click and select 'Change Series Chart type'. 5. In the dialog box, Select the 'Line Chart with markers'. This will change the plan value bars into the line with markers. 6. Click Ok 7. Now, your chart looks like this as shown. 8. Select the line and right click to select the 'Format Data Series' opti...

Excel Tricks : How To Display Multi Categories In Excel Charts || Excel Tips || dptutorials Do You Know that we can show the multi categories in an excel chart?? like shown here... Let's see this trick in detail in this tutorial. 1. Let's consider an example of my grocery list and expenditure spent on those items, like shown here. 2. Using this data, let's create a chart showing the expenses by category wise. 3. Just arrange the data as shown here. And add the category name in the column left to the items list. 4. I categorize these as Fruits for the first 3 items, and then dairy as next category for next three items, and then meat for the next 3 items. So Iam dividing these into 3 broad categories fruits, dairy and meat. 5. Now, Select the entire data set. 6. Go to Home tab, Click Insert, under charts, select 2D column chart. This one. 7. You will get a chart. Format it the way you want. 8. That's all friends, you can see the categories in the c...

Excel Tricks : How To Convert Text To Speech In Excel | Excel Tips || dptutorials Hello Friends, you would have heard about text to speech converting softwares. But did you ever notice that the same feature is also available in Microsoft Excel? Excel has a great feature that converts text into speech and can read out loud to you. Now, let's see how we can enable and use this feature now in detail. 1. This feature is not readily available in the Quick Access Toolbar or the ribbon. 2. Right click on any of the tabs in the ribbon and select the 'Customize Quick Access Toolbar'. It will open the excel options dialog box. 3.In the Choose commands from the drop down menu, select 'All commands' 4. Scroll down the list to find the Speak Cells options. 5. You will find five options here, you can select any one of your choice. 6. I would be selecting the 1st option, Speak Cells, click on Add button. 7. Click Ok. 8. Speak Cells icon, will be added i...

Introduction To Project Management And Primavera Project management life cycle includes 5 phases initiation planning execution controlling and closing. The main purpose of the project management is to achieve all the project goal while taking into account of all the constraints Typical constraints associated with the projects are time scope and budget. The main objective of the project management is to ensure that all these processes are streamlined to make sure that the project is completed on time and within budget and within scope. 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 *******************************************************...