DPTutorials

In some situations, you will be required to Inverse the data like the transpose function which does the switching of columns and rows,...

In this tutorial, Let us see how to create an awesome Organizational Chart in just 3 easy steps. Generally we prepare Organizational...

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

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

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

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

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

Let us see how we can set different currency formats in excel. In general , in excel we have the English group formatting like...

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

This function rounds the number to its nearest Whole Number. Syntax: =INT(num) Example: The Table has some Numbers, and In the right...

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

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

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

This function uses two sets of values to predict a single value.The predicted value is based on the relationship between the two original...

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

This function will show the last day of the month which is a specified number of months before or after a given date. Syntax:...

This function examines a list of information and produces the largest value from a specified column. Syntax: =DMAX(DatabaseRange,FieldNam...

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

This Function creates a random number between the given two numbers. The Number will change each time the worksheet recalculates or when...

This Function calculates the number of times a number can be divided by another number. It ignores any remainder. Syntax:...