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...
top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
- Jul 17, 2020
- 2 min
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...
Dp
- May 2, 2019
- 2 min
How To Quickly Unhide Multiple Sheets In Excel At Once
In this Tutorial, Let us see How To Quickly Unhide Multiple Sheets In Excel At Once, with a single click. Generally, to unhide any sheet...
Dp
- Apr 26, 2019
- 2 min
How To Quickly Generate Serial Numbers In Excel
In this video tutorial, let us learn how to easily generate serial numbers in excel data range. This is very quick and easy to perform....
Dp
- Apr 23, 2019
- 1 min
How To Copy and Apply Formatting For Any Chart With Paste Special Option
In this video tutorial, let us learn how to copy formatting from any chart and apply the same to other unformatted charts in Excel. This...
Dp
- Apr 17, 2019
- 2 min
Adjust Copy Pasted Excel Data into Correct Columns
In this tutorial, you will learn how to clean the excel data into the right matrix. Sometimes when you copy paste the data from other...
Dp
- Apr 17, 2019
- 2 min
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,...
Dp
- Mar 29, 2019
- 2 min
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...
Dp
- May 5, 2018
- 1 min
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...
Dp
- May 1, 2018
- 1 min
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...
Dp
- Apr 22, 2018
- 1 min
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 21, 2018
- 1 min
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...
bottom of page