"Concatenate" Function In Excel
This function joins separate pieces of text into one item. Syntax: =CONCATENATE(Text1,Text2,Text3...Text30) Example: Here is the video...
top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
Apr 22, 20181 min read
"Clean" Function In Excel
This function removes any nonprintable characters from text. These nonprinting characters are often found in data which has been imported...
Dp
Apr 22, 20181 min read
"Combin" Function In Excel
This function calculates the highest number of combinations available based upon a fixed number of items. This is nothing but the...
Dp
Apr 22, 20181 min read
"Average" Function in Excel
This function calculates the average from a list of numbers. If the cell contains zero 0, the cell will be included in the average...
Dp
Apr 22, 20181 min read
Autosum In Excel
Instead of using the Autosum function or the button from the toolbar You can press Alt and = to achieve the same result Just you have to...
Dp
Apr 22, 20181 min read
"AND" Function in Excel
This function tests two or more conditions to see if they are all true. It can be used to test that a series of numbers meet certain...
Dp
Apr 21, 20181 min read
Show only some portion of Excel sheet
Excel Sheet has 2^20 Rows and 2^14 Columns. Instead of Using the blank cells appearing. It is better to hide all the unwanted blank...
Dp
Apr 21, 20182 min read
How to Change the Calender in Primavera in the middle of the project
Hi, Lets see How we can change the Calendar once the schedule is prepared. As per the Scheduling Philosophy, Calendar has to be set...
Dp
Apr 21, 20181 min read
Export Schedule from Primavera P6 to Excel
Lets see How to export the P6 Schedule in to Excel in an easy way. Step 1: First Open the schedule and go to Activities layout, Which you...
Dp
Apr 21, 20181 min read
Claim Digger for Comparing Schedules in Primavera P6
You can Compare the schedule with an original schedule to know what changes have been made. You can use the claim digger function for...
Dp
Apr 21, 20181 min read
Drag and Drop Feature In Primavera P6
Instead of Cut and Paste you can use the Drag and Drop function in primavera which saves lot of time. If you would like to move one Item...
Dp
Apr 21, 20181 min read
Useful Hot Keys In Primavera
Hot Key/ Shortcuts commands In Primavera P6 are those which save valuable time that most of us are unaware of. Its very rewarding and...
Dp
Apr 20, 20181 min read
Chart View Feature In Primavera P6
This tutorial will help u in viewing the WBS/Schedule in Chart View layout. I use this function mostly for the reporting purpose,as it...
Dp
Apr 20, 20181 min read
Filldown Feature In Primavera P6
1. Select the Cell Which you want to copy and paste in the cells that were below the cell. 2. Press Shift Button and select the last cell...
Dp
Apr 20, 20184 min read
Microsoft Project Basics
Microsoft Project has a Gantt Chart View which is a Visual Tool to Help Plan, Manage and track a project or projects. Planning a Project...
Dp
Apr 20, 20181 min read
Formulae and Functions in Excel
A formula is an expression which calculates the value of a cell. Whereas the function is the predefined formula readily available in MS...
Dp
Apr 20, 20181 min read
What is S-Curve?
An S-Curve is the Graph of the Project costs over the time. It can also be typically plotted for the Resource hours over time. S-Curve is...
Dp
Apr 20, 20181 min read
Critical Path Method (CPM)
Find a Paper on Detail Critical Path Analysis Published in journal Download Here If you liked this tutorial, share it with your friends....
Dp
Apr 20, 20181 min read
Project Management Techniques
Two Fundamental Techniques are used throughout the Project Management: 1.Breakdown Complex items into Simple Parts, Solve Them, Roll them...
Dp
Apr 20, 20181 min read
Top Reasons for Success & Failure in a Project
Keys to Project Success: User Involvement Executive Management Support Clear statement of Requirements Proper Planning Realistic...
bottom of page