#ExcelFreeLearning

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...

0 comments

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...

0 comments

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...

0 comments

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...

0 comments

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.

0 comments

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...

0 comments

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.

0 comments

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

0 comments

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

1 comment

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

0 comments

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.

0 comments

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

0 comments

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

0 comments

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

0 comments

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.

0 comments

The Project Management Blog

DPTutorials

Learning Made Easy...

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