top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
May 3, 20182 min read
How To Set The Global Calendar In MS Project 2010
In the earlier tutorial we have learnt How to create a new calendar for a project in Microsoft Project 2010. The problem we generally...
0
Dp
May 2, 20181 min read
How To Color Only Visible Cells In Excel
We do face this problem when we want to color only the visible cells, we generally select all the cells and color them.Later, when we...
1
Dp
May 1, 20181 min read
How to get Excel 2013 to show a comma after millions (English format) or Thousands (Indian format)
Let us see how we can set different currency formats in excel. In general , in excel we have the English group formatting like...
0
Dp
May 1, 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...
0
Dp
May 1, 20181 min read
Causes of Project Failure
Ranked Causes of Project Failure: Incomplete Requirements Lack of User Involvement Lack of Resources Unrealistic Expectations Lack of...
0
Dp
May 1, 20181 min read
Top Reasons for Successful Project
Keys to Project Success: User Involvement Executive Management Support Clear statement of Requirements Proper Planning Realistic...
0
Dp
May 1, 20181 min read
10 Tips In Project Management
These are the Ten Tips for prospering in the Project Management 1. Break down the Project Details in to minute detail 2. Know the Project...
0
Dp
May 1, 20181 min read
Create Instant Chart In Excel
You can create a Instant Chart in Excel, without using the Chart Button in the Insert tab on the Toolbar by pressing the function key F11...
0
Dp
May 1, 20181 min read
Interesting Facts About Construction Productivity
Following are the Few Facts about construction productivity studied by Adrian (1990) Tuesday is the most Productive day of the week....
0
Dp
May 1, 20182 min read
Labor Productivity
Productivity in General expresses the relation between inputs and Outputs. Labor is the basic resources requirement in the construction...
0
Dp
May 1, 20181 min read
"INT" Function In Excel
This function rounds the number to its nearest Whole Number. Syntax: =INT(num) Example: The Table has some Numbers, and In the right...
0
Dp
May 1, 20181 min read
"IF" Function In Excel
This function tests a condition / Logic If the condition is met it is considered to be TRUE.If the condition is not met it is considered...
0
Dp
May 1, 20181 min read
"HLOOKUP" Function In Excel
This function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down...
0
Dp
May 1, 20181 min read
"FREQUENCY" Function In Excel
This function compares a range of data against a list of intervals.The result shows how many items in the range of data fall between the...
0
Dp
May 1, 20181 min read
"FORECAST" Function In Excel
This function uses two sets of values to predict a single value.The predicted value is based on the relationship between the two original...
0
Dp
May 1, 20181 min read
"FIND" Function In Excel
This function looks for a specific letter in a word and gives the result as number of the position of the letter in a word. If the text...
0
Dp
May 1, 20181 min read
"EOMONTH" Function In Excel
This function will show the last day of the month which is a specified number of months before or after a given date. Syntax:...
0
Dp
May 1, 20181 min read
"DMAX" Function In Excel
This function examines a list of information and produces the largest value from a specified column. Syntax: =DMAX(DatabaseRange,FieldNam...
0
Dp
Apr 30, 20181 min read
Funny Walking Trick In Microsoft Project
Here is a funny geeky trick you can learn in the Microsoft project where the gantt chart can be made walking as shown in the video below....
0
Dp
Apr 30, 20181 min read
"RANK" Function In Excel
This Function calculates the position of a value in a list relative to the other values in the list. It can be very much used while...
0
bottom of page