Skip to main content

Posts

Showing posts from February, 2019

How To Export Primavera Schedule To Show Only Lowest Level Summary Data

In this tutorial, let us understand how to export primavera schedule to show only lowest summary data Generally, to show summaries of the Primavera Schedule, we right-click on the Activity table and click on Group & Sort and then tick the checkbox "Show Summaries Only" and click Ok The problem with this is you will get to view summaries at all levels. But we want to view only the lowest level summaries only and with the high-level summaries as Zero. Here is the solution, watch this completely. Right-click and select Group & sort and deselect the option "Indent" and Click OK. Now you can view only the summary data at the lowest level with the higher level summaries showing zeroes in the duration column. so, friends, this is the trick to export primavera schedule to show only lowest summary data. 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 ...

How to Find and Remove Blank Cells, Rows and Columns In Excel || How to Delete Blank Rows in Excel

In this tutorial, let us learn how to find and remove blank cell, rows and columns in Excel. Let us consider an example with data range as shown here in the video. This Excel sheet is having some blank cells, rows and columns. Now, let us see how we can remove all these blank cells. Firstly, Select the data range Go to Find & Select feature in the menu bar and choose Go to Special function option and select Blanks. You can also use the keyboard shortcut Ctrl+G to arrive at this dialog box of Go To. Select blanks and Click Ok. Now all the blank cells will be selected. Now in the cells group, under delete function, click on Delete Cells Select any one of the options as per your convenience. I am selecting Shift cells up and click on OK. Again to remove the blank columns, select the data range, click Ctrl+G, click on special, select blanks, Click Ok. Under delete, select delete sheet columns. You can fund that all the blank cells have been removed completely now. So, ...

2.3 : Primavera Learning - Resources,Codes and Roles || Primavera tutorials || dptutorials

In this video, let us learn about Resources, Resource Codes, Roles in Primavera P6. This chapter describes how to use the Resources, Resource codes, and Roles in the Primavera P6. 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...

Excel Tricks - How to Sum Values Between Two Dates Using SUMIFS || Find Sum Between Two Dates

In this tutorial , let us learn How to Sum Values Between Two Dates using SUMIFS formula. Let us consider an example with some sales data by date wise and let us calculate some of values between 01st Jan 2018 to 31st Jan 2018. I enter formula in Cell D4 as shown in the video When you hit enter, this function will return the result as 58629 in the cell, which is the sum of the sales between 01-Jan-2018 to 31-Jan-2018. To verify this calculation, just filter the January dates in column A and select the Column B and check out the status bar for the sum of these values as 58629 which is the exact figure we got from the formula. So, friends in this way you can calculate sum of values falling between two dates in a range. 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 ...