top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
Apr 17, 20192 min read
How To Inverse the Data Range in MS Excel || Turn Data Upside Down in Excel
In some situations, you will be required to Inverse the data like the transpose function which does the switching of columns and rows,...
0 comments
Dp
Apr 8, 20192 min read
How To Create Organizational Chart in Just 3 Steps
In this tutorial, Let us see how to create an awesome Organizational Chart in just 3 easy steps. Generally we prepare Organizational...
0 comments
Dp
Mar 29, 20192 min read
How to Highlight MAX and MIN Values in MS Excel Chart || MS Excel ||
Hi, In this tutorial, let us learn how to highlight special data points in the Chart that we create in MS Excel. Let's see how to do it...
0 comments
Dp
May 26, 20182 min read
Compare Two Spreadsheets With Excel Inquire Addin
If your are using the Excel 2013, then you can have access to the mentioned Inquire Feature that allows you to compare two workbooks to...
0 comments
Dp
May 13, 20182 min read
How to Name a Cell and Range of Cells in EXCEL using "Name Manager"
In this tutorial, Let us see and learn how to use the "Name Manager" Feature in Excel, which make it easier to create, use and understand...
0 comments
Dp
May 5, 20181 min read
How To Unprotect An Excel Sheet Without Password
If an Excel spreadsheet is password protected, we are unable to edit the data in the sheet. If you do not remember the password or if you...
0 comments
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 comment
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
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 comments
Dp
Apr 29, 20181 min read
"RAND" Function In Excel
This Function creates a random number between the given two numbers. The Number will change each time the worksheet recalculates or when...
0 comments
Dp
Apr 29, 20181 min read
"QUOTIENT" Function In Excel
This Function calculates the number of times a number can be divided by another number. It ignores any remainder. Syntax:...
0 comments
bottom of page