Free Project Management Tools - Tutorials,Ebooks and Setups

To Count unique numeric values in a range, you can use a formula based on the frequency and sum functions. 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

In Primavera, we can use " Renumbering Activity ID" function to modify Activity ID Prefix. How about we want to modify Suffix. We watch this video to know how to do this. 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:

Excel Trick - How To Count Unique Values In A Range With COUNTIF In Excel || dptutorials If you need to count the number of unique values in a range of cells, you can do by using the countif and sumproduct functions 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://twitte

How To Use Top Down Estimation In Primavera P6 To Calculate Labor Units Required || dptutorials In Primavera, we have a function called "Top down estimation" which help us to calculate an estimated figure for labor and non-labor unit based on "estimation weights". It can apply to WBS and activity 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 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 **************************************

How To Highlight Blank Cells In Excel || Use Of Conditional Formatting || dptutorials Watch this video to know how to highlight blank cells in Excel using 3 ways. 1. Use of Conditional Formatting is the easiest way to highlight cells based on its value. It is the dynamic function., which automatically highlights the blank cells. 2. Use of Go to Feature you can select all the blank cells at a single go. 3. Using the VBA, copy and paste the mentioned code in the VBA module and run the 'highlight blank cells' macro in your excel workbook. 'Code by dptutorials Sub HighlightBlankCells() Dim Dataset As Range  Set Dataset = Selection Dataset.SpecialCells(xlCellTypeBlanks).Interior.Color = vbyellow 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