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...
top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
- Aug 27, 2021
- 2 min
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...
Dp
- Aug 13, 2021
- 3 min
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...
Dp
- May 12, 2021
- 4 min
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...
Dp
- Nov 18, 2020
- 3 min
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.
Dp
- Jul 17, 2020
- 2 min
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...
Dp
- Jun 20, 2020
- 2 min
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.
Dp
- Jun 11, 2020
- 2 min
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
Dp
- Jun 6, 2020
- 2 min
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
Dp
- May 16, 2020
- 2 min
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
Dp
- May 16, 2020
- 2 min
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.
Dp
- Apr 28, 2020
- 2 min
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
Dp
- Mar 13, 2020
- 1 min
Easy Ways To Insert Bullets In Excel | Insert bullet points | Excel Tips |dptutorials
Easy Ways To Insert Bullets In Excel | Insert bullet points
Dp
- Mar 13, 2020
- 1 min
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
Dp
- Mar 10, 2020
- 1 min
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.
Dp
- Mar 10, 2020
- 2 min
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.
Dp
- Feb 22, 2020
- 2 min
How To Display Multi Categories In Excel Charts
Do You Know that we can show the multi categories in an excel chart??
Dp
- Feb 22, 2020
- 2 min
How To Join Texts Together To Form A Single Line In MS Excel and Vice Versa || Justify Tool in Excel
In this tutorial let us learn about an interesting tool in Excel. With this tool, one can join pieces of text together into a single line an
Dp
- May 8, 2019
- 1 min
How To Add Legends To the Chart Itself In Excel; Smart way to show legends in chart
In this tutorial, I will show you an interesting trick in Excel on How To Add Direct Legends To the Chart Itself.
Dp
- May 7, 2019
- 2 min
How To Create Waterfall Chart in MS Excel
Let us learn How To Create Waterfall Chart in Excel.
This kind of chart looks like a waterfall and that's the reason why it has been calle
bottom of page