Free Project Management Tools - Tutorials,Ebooks and Setups

In this tutorial let us learn How to Refresh All Pivot Tables at Once in Excel When you have multiple pivot tables, it takes so much time to refresh each table. So, in this video let us see two simple ways to refresh all pivot tables at once automatically. 1. Using "Refresh All" Button "Refresh All" button is very simple and easy way to refresh all the pivots tables in a workbook with a single click. All you need to do it is Go to Data Tab and click the Refresh All button. 2. If you want to refresh all pivot tables on opening a workbook every time, you can use the following settings to make one time set up. Right-click on any pivot table and select “PivotTable Options" Go To Data Tab and Tick the Checkbox “Refresh Data When Opening the File” click Ok. In this way, you can refresh all the pivot tables automatically. I hope you have enjoyed this video tutorial. For Personalized detail learning, write to dptutorials15@gmail.com If you found this v...

In this tutorials, let us learn how we can quickly identify behind schedule activities with user-defined indicators in Primavera P6. Let us consider a sample project which is having a baseline. After updating the schedule, we can show these 2 additional columns to see whether an activity is behind schedule or not: • BL Project Finish  Variance – BL Project Finish: which is duration between BL Project Finish date and current Finish date. i.e., L Project Finish – Finish Now let us create an Indicator. Go to menu bar and under Enterprise, Click on User Defined Fields. Click Add button to create new. Enter Title as ‘On Schedule Indicator’ and Select Data Type: Indicator from the drop down menu. Close the dialog box. Now Go to menu bar again and under Tools, select Global Change. Click New. Enter data as: Where Variance-BL Project Finish Date is greater than or equals 0d then, On Schedule Indicator = Green else On Schedule Indicator = Red Click on Change button, to vie...

In this tutorial, let us learn how to apply filter based on WBS dates in Primavera P6. In Primavera P6, we generally can apply filter only for the activities and there is no specific function to filter WBS. Let us understand this with an example now. Let us consider a simple project which is containing 3 Cities like this as shown. Now, if we need to filter which City will start in next 2 month (Nov, Dec). Usually, we create a filter based on Activity as Start or Finish is within range of 1st Nov’18 to 31st Dec’18. And when you click OK, P6 will show this result like this as City 1 and City 2 will start, as these are the only two cities having activities which are either starting or finishing in next two months. However, the Finish date of City 1 and City 2 WBS is wrong. Because P6 only show the WBS dates based on filtered activities, so that summarize information in WBS is wrong. Now how can we show right start and finish date for the WBS. P6 does not provide any fe...

Excel Trick#55 : How to Highlight the Most Recent Date in MS Excel || Excel Tips || dptutorials In this tutorial, let us learn how to highlight the most recent/ latest date in a data range. To perform this, we are going to use the conditional formatting in MS excel. In this example, we have the data of some issues closed dates by persons. So, from the column C, where we have the issue closed dates, we need to highlight the latest recent date. As the date range is very small here, we could able to identify easily that C10 is the recent one. But, if we have a large database, it would be difficult to identify. Now, let us see how we can highlight, • Select date range, column C • Go to Conditional formatting, Click on New Rule • Click on “Format only cells that contain” • Select equal to and Cell Value equal to =MAX($C:$C) • Click on Format & Select any color and font as per your wish • Click ok button Now, we can see that the latest date is highlighted as ...