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 *******************************************************...

In this Video Tutorial, let us learn how to insert pictures in excel comments box. Whenever you hover the mouse over a cell that has a comment, it would show the picture within it. In this example, I have list of some Actress of Bollywood, with their picture in the cell's comment box as shown here. Now, let's watch the video and see how to do this trick. 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://if...

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 :  https://twitter.com/dptutorials15 Facebook :  http://ift.tt/2kfRnDi Blogspot :  http://ift.tt/2kB14dh

1. Sometimes you would like to hide your worksheets. that means you don't want others to see some of your sheets in your excel workbook 2. To do that, we generally hide the sheets by simply right clicking and choosing hide option. 3. If I want to hide multiple sheets, i select the multiple sheets by pressing the Ctrl button and then right click to select hide option. 4. To unhide these hidden sheets, we again right click on any of the sheet tab and select the option unhide to unhide the sheets one by one. 5. So, Even Others can do the same of unhiding your sheets, which you have thought of hiding  from other users. 6. So, if your friend gets to know that you are hiding some important sheets in the workbook that your are sharing, he might always right click and get the hidden sheets easily. 7. Now, lets see how we can hide the sheets more securely. First, Press ALT+F11 or right click on any sheet and choose the view code option. you will be landing to the Visual Bas...

In this tutorial, follow Step-by-Step Tutorial and learn How To Create A Funnel Chart In Excel In A Simpler Way: This is very useful in preparing dashboards to depict your valuable data in a easier way 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 : https://twitter.com/dptutorials...

If we want to make a copy of any sheet, we generally right click and select move or copy. By doing this, we can move to other workbooks. But here, if I want to have in this same sheet, hold down the ctrl key and start dragging the sheet away, you will see the + sign in it.   So if you move now towards the leftward or right side you will notice a little black pointer, if you release mouse first, we get a copy. I'll do it again. Get the Control key held down drag to the right, and release the mouse to make a copy. 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 *************************************************************...

We know it is easy to copy and paste the data, but there is a technique to enter data in multiple cells so quickly. Select the range of cells, where you would like to enter a value. Holding the CTRL key, click on any cell and then type the value as per your wish, say “DP”.   And don’t press enter now, instead press Ctrl+Enter and then you will get the entire series with the same name DP. This works with the numbers as well, it doesn’t have to be in the same row or same column. Let’s see, if I want to type 100 in these 4 cells, I simply select these 4 cells by pressing Ctrl key and selecting a cell of these and I type 100 and press Ctrl+Enter. So, you can use this trick for numbers, text and also for formulas. Let’s see an example for using the formulas as well.   Here, I have got some numbers and let us find the sum of all these columns. First, let me select all the cells here, type the formula as = Sum (select the range in the first column) and press...

  In order to see a formula in a cell, we generally double click a cell.   But sometimes, we may want to see all the formulas at once. To do that, there is a key stroke shortcut and also a menu command that will allow you to display all the formulas. The key below the Esc key on your keyboard having the Tilde & accent grave can be used along with the Ctrl key as a key stroke shortcut now. So, let’s try now by pressing the Ctrl+` key on your keyboard to see that all the formulas in the sheet, getting displayed and columns width has been increased. If you press the Ctrl+` again you will be back to the normal display. You can also find this feature from the menu bar, Go to the Formulas tab and select the option called show formulas Now, let’s see the other trick of highlighting all the cells that contain formula Go to the Menu bar and in the extreme right, you will see the Find & Select button, click it and choose formulas and then all cells th...

How To Change The Data Without Using The Formula In Excel || MS Excel Tricks And Tips 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. In this example, I have some numbers 1 to 10 in this column and if I suppose to multiple each cell by 2, what would everyone generally do? Using formula in the next column, we multiple each cell by 2 but let’s see how we can do this without using the formula. I type 2 in a cell and then copy the cell.(CTrl+C) now select the entire range which needs to be changed and then press CTRL+ALT+V and under operations select the multiply option and click OK, you will see the result getting exactly the way u wished. Let us see one more example, here you will notice that using the formula is no better than using our new feature. Here I have targets for 4 regions by month wise and what if your boss ask...

·          Flash fill is the most powerful tool that has been introduced in MS Excel 2013. Using this feature, we can combine multiple columns and separate the data from a column. Now let’s see with an example. ·          In the first column, I have Full names (First name separated by last name) and if I would like to reverse the order of first name and last name, we generally do that by using the Text to columns / concatenate functions. But using this new feature of flash fill, we don’t’ need to do this anymore. ·          In the adjacent column, I type the last name of the first entry, comma and type the first name and then go to the menu bar and go to the Data tab and click on flash fil (either u can press Ctl+E as a shortcut) and you will notice that the names populated as per your wish. It’s nice right. ·        ...

In Excel, from any particular cell if you would like to move to last row, we generally press Ctrl + Down arrow and to move to last column, we press Ctrl + Right arrow . Similarly for first row and first column, we press Ctrl + up arrow & Ctrl+ left arrow respectively. This is all we knew til now. But there’s a shortcut even for this?? Let’s see how it is now. Go to any cell and from here if you would like to move to the last row, simply double click the bottom edge of the cell. Similarly double click on right edge of the cell to move to last column. You can try with other two edges to move to the first row and first column.  Similarly to select the entire column, go to the first cell, hold shift and double click the bottom edge of the cell. You can do the same logic for selecting entire row as well. 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...

How To Change The Shape Of Comment Boxes In Excel | Insert and Edit Comments in Excel. ·          When you go to any cell in Excel and upon right click, you will be seeing the option called “ Insert Comment ”, by clicking this you can insert your comment for that particular cell. ·          Once you are done with the inserting of comment into the cell. Now, whenever you place the cursor on the cell, you could notice that the comment is becoming visible. ·          If you would like to reshape this comment box, right click on the cell and choose edit comment, then hold any corner of the box and drag to make it wider, taller to adjust the content. ·          But, sometimes you would like to even have different shapes altogether. So, in order to do this, we need to activate a feature that is not availa...

Hello Friends, Welcome to dptutorials. In this video, let's learn about one of Excel's most powerful and creative tool that is called as Pivot Table, when you work with large amounts of data, i.e list type data. Pivot table is great for coming up with quick summary information. Watch this video completely for better understanding of the awesome new trick which will make you more productive and efficient. In this example, I am considering a small amount of data for clear understanding. I am going to create a Pivot table based on this data now. It has got some multiple rows of data that we are tracking sales, amount, customer count, population by state and region wise. Generally we go to insert tab in the ribbon and create a pivot table in excel. but I would suggest you a new trick of using the new feature called " Recommended Pivot tables" because sometimes the layouts that you see here might be the exact or at least close to something that you want. ...

Are you still using Vlookup? This Microsoft Excel tutorial will teach you how to use the INDEX and MATCH functions, which can provide a better solution. 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. 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/2j...

Watch this video to learn the excel Shortcuts for Formatting the data. these are very useful and helpful in formatting which saves lot of time of yours. 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. 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/2jH3...

In this tutorial let us learn about an interesting tool in Excel.With this tool, one can join pieces of text together into a single line and vice versa. Let us consider an example here with text in different cells and now we want to bring this together in a single cell. You may think that we can do this by using the CONCATENATE function but I would be showing the more simpler and smarter way to do this. Did you ever here the Justify function in excel?? Now lets use this tool to perform this trick. Step 1: Select all the text in different cells Step 2: Now extend your selection towards right, so as to accommodate all the text into a single line Step 3: Now in the Home tab of menu bar, in the Fill option's drop down menu select the justify command. Now the text appears in a single row...its simple right... Now lets see the working vice versa. let us break the same text into pieces into different rows Step 1. Select the Row which is having the text, along with so...

In this video tutorial, I will show you How To Add Direct Legends To the Chart Itself, directly in the Excel. 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. 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 *************************************...

Watch this video to learn How To Create Waterfall Chart in Excel. Clear demonstration and explanation is given in this video tutorial for better understanding. 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. 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 ************************************************************ 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, s...

Hello Friends, In this video tutorial we will see how we can prevent users from deleting rows and columns in Excel Sheet. This is the smart way of creating the access control on your spreadsheet trackers, reports, dashboards other than the normal routine method of protecting the entire worksheet/spreadsheet. 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 :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://ift.tt/2kB14dh

In this Tutorial, Let us see How To Unhide Multiple Sheets In Excel Quickly, with a single click. copy the code mentioned below and paste in the view code sheet and then Run to unhide all the hidden sheets Sub Unhideallsheets() For Each Wrksheet In ActiveWorkbook.Worksheets Wrksheet.Visible = True Next Wrksheet End Sub  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 **********...

Sparklines are types of graphs that show trends and variation of data. Sparklines are awesome and quick to create. This even saves space and can be used for rough estimations. 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 :  https://twitter.com/...

In this video tutorial, let us learn how to easily generate serial numbers in excel data range. This is very quick and easy to perform. This is the auto generated serial number system in excel. ROWS and ROW function have been used for this purpose, which gets automatically updated. 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 :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://ift.tt/2kB14dh

In this video tutorial, let us learn how to apply copy formatting from any chart and apply the same to other unformatted charts in Excel. This can be done using the paste special option to copy and apply formats. This is superb easy trick with which we can save lot of time and efforts. 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 :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://ift.tt/2kB14dh

In this video tutorial, let us learn how to apply borders to a table in MS Excel. I Prefer this method which makes our data speak out because sometimes the table borders lead to distraction. 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 :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://ift.tt/2kB14dh

In this tutorial, you will learn how to clean the excel data in to right matrix. sometime when you copy paste the data from other sources, all the pasted data comes into a single column. Now let us see how to arrange the data into correct columns using the formula. 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 : https://twitter.com/dptutorials15  Facebook : http://ift.tt/2kfRnDi  Blogspot : http://ift.tt/2kB14dh

How to Inverse the Data Range in Excel : Turn Data upside down. In some situations, you will be required to Inverse the data like the transpose function which does the switching of columns and rows, there is no direct formula like invert to inverse the complete data range upside down. Watch this video tutorial on how to inverse the data range in MS Excel. 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 :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://i...