Dptutorials

Apr 7, 20234 min read

Project Scheduling Glossary

Activity: A task or work item that needs to be completed as part of a project. Actual Finish Date: The date on which an activity was...

Mar 18, 20233 min read

10 Must to Know Excel Tricks to improve your productivity

Highlight activities using Filters and Spotlight feature in Primavera P6

Feb 10, 20232 min read

Highlight activities using Filters and Spotlight feature in Primavera P6

Primavera P6 is a comprehensive project management software that is widely used in construction, engineering, and other industries. It...

Jan 30, 20221 min read

Count Unique Numeric Values In A Range

In this tutorial, let us learn how to Count unique numeric values in a range using the combination of Frequency and Sum functions Let us...

How To Modify Activity ID Suffix In Primavera P6

Aug 27, 20212 min read

How To Modify Activity ID Suffix In Primavera P6

In this video, let us learn how to modify activity ID suffix In Primavera P6 In primavera p6 we can use the renumbering activity id...

How To Count Unique Values In A Range With COUNTIF In Excel

Aug 13, 20213 min read

How To Count Unique Values In A Range With COUNTIF In Excel

If you need to count the number of unique values in a range of cells in Excel, you can do that by using the combination of COUNTIF and...

May 12, 20214 min read

Schedule Reader Product Review

ScheduleReader is a software application that lets you open, print, and export projects in .xer, .xml, or .xls file formats, without...

How To Use Top Down Estimation In Primavera P6 || dptutorials

Nov 18, 20203 min read

How To Use Top Down Estimation In Primavera P6 || dptutorials

In Primavera, we have a function called "Top down estimation" which help us to calculate an estimated figure for labor and non-labor units.

3 Ways To Highlight Blank Cells In Excel || Use Of Conditional Formatting

Jul 17, 20202 min read

3 Ways To Highlight Blank Cells In Excel || Use Of Conditional Formatting

In this tutorials, let us know how to highlight blank cells in Excel using 3 ways. 1. Use of Conditional Formatting is the easiest way to...

How to Identify Activities That Do Not Exist In Baseline In Primavera P6

Jun 20, 20202 min read

How to Identify Activities That Do Not Exist In Baseline In Primavera P6

In this tutorials, let us see how we can identify the activities that do not exist in the project baseline in primavera p6.

Easiest Way To Strikethrough Cell in Excel || How To Do A Strikethrough In Excel || dptutorials

Jun 11, 20202 min read

Easiest Way To Strikethrough Cell in Excel || How To Do A Strikethrough In Excel || dptutorials

Easiest Way To Strikethrough Cell in Excel || How To Do A Strikethrough In Excel

Remove Relationships from All Activities in Primavera P6 In An Easier Way

Jun 6, 20202 min read

Remove Relationships from All Activities in Primavera P6 In An Easier Way

You might have known how to remove multiple relationships from activities in Primavera P6, but in this video let us see a faster and easier

May 16, 20202 min read

How to count colored cells in MS Excel

In this tutorial, let's learn How to count colored cells in MS Excel Here, we would be using the VBA method and this is the most easiest me

Project Schedule Compression Techniques In Primavera P6 Explained - Fast tracking and Crashing

May 16, 20202 min read

Project Schedule Compression Techniques In Primavera P6 Explained - Fast tracking and Crashing

In this tutorial, let's learn about schedule compression techniques, they are nothing but Fast tracking and crashing.

How To Create Pareto Chart In Excel || Pareto Analysis in Excel - 80/20 Rule or Pareto Principle

Apr 28, 20202 min read

How To Create Pareto Chart In Excel || Pareto Analysis in Excel - 80/20 Rule or Pareto Principle

In this tutorial, let us learn about Pareto chart and how to create this in Excel. Pareto chart is based on Pareto principle also known as 8

Easy Ways To Insert Bullets In Excel | Insert bullet points | Excel Tips |dptutorials

Mar 13, 20201 min read

Easy Ways To Insert Bullets In Excel | Insert bullet points | Excel Tips |dptutorials

Easy Ways To Insert Bullets In Excel | Insert bullet points

Create An Activity Report With List Of All Predecessors and Successors In Primavera P6 | dptutorials

Mar 13, 20201 min read

Create An Activity Report With List Of All Predecessors and Successors In Primavera P6 | dptutorials

Watch this tutorial to learn how to make an activity table report showing all the predecessors and successors of each activity in Primavera

How To Renumber Activity IDs For All Activities In An Ascending Order In Primavera

Mar 10, 20201 min read

How To Renumber Activity IDs For All Activities In An Ascending Order In Primavera

In this video tutorial, let us learn how we can renumber activity IDs in an ascending order perfectly.

Best Way To Create Plan Vs Actual Graph In Excel || dptutorials

Mar 10, 20202 min read

Best Way To Create Plan Vs Actual Graph In Excel || dptutorials

In this tutorial, let us learn the best way to create a plan vs actual graph in Excel.

How To Display Multi Categories In Excel Charts

Feb 22, 20202 min read

How To Display Multi Categories In Excel Charts

Do You Know that we can show the multi categories in an excel chart??

The Project Management Blog

DPTutorials

Learning Made Easy...

Subscribe to my YouTube channel | Copyright 2022 dptutorials.com | All Rights Reserved