Skip to main content

Posts

Showing posts from April, 2018

Excel Tricks : Generate Unique Values in a Column In Excel || Excel Tutoring || dptutorials

Hi Friends, You are aware of the filter key function in Excel, but very few people use the advanced filter, which can be used to filter unique values from data in a column. So, lets see how to generate unique values in a column in Excel. Lets get into example now. Here we have different names in Column B 1. Go to Data tab in the menu bar, click on Advanced Filter. 2. Under Action : select Copy to another location. 3. Under list range : select B4:B16 4. Under Copy to : select F4 5. Tick the checkbox: Unique records only. 6. Click OK. Excel will copy the unique names from the source column into the new location. It will even paste those entries with the same formatting as shown. 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.  *****************

How To Filter Activities Based On Relationship Type In Primavera P6 || P6 Tutorials || dptutorials

Sometimes we need to filter activities based on relationship type. For example, if we want to show only activities with relationship type Start to Start. The default filter function doesn't support this. I will show you how to do this in this video now. We will be using the Report Function in this example. 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 *************************************************

Excel Tricks - How To Select Visible Cells Quickly In Excel || Copy & Paste || dptutorials

Excel Tricks - How To Select Visible Cells Quickly In Excel || Copy & Paste || dptutorials Excel Tricks - How To Select Visible Cells Quickly In Excel || Copy & Paste || dptutorials Watch this video to learn two tricks on how to select only the visible cells and copy them to paste only the selected visible cells. 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 Activities Using Filters And Spotlight Feature In Primavera P6 || dptutorials

You can use Primavera P6's numerous features for highlighting and filtering to highlight activities that fall within a range of dates or some other criteria. Watch this video to know how to use primavera p6 filters to highlight various activities and also how to use the spotlight feature to highlight activities. 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 *****************************************