DPTutorials

10 Must to Know Excel Tricks to improve your productivity

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

If you need to count the number of unique values in a range of cells in Excel, you can do that by using the combination of COUNTIF and...

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

Easiest Way To Strikethrough Cell in Excel || How To Do A Strikethrough In Excel

In this tutorial, let's learn How to count colored cells in MS Excel Here, we would be using the VBA method and this is the most easiest me

In this tutorial, let us learn about Pareto chart and how to create this in Excel. Pareto chart is based on Pareto principle also known as 8

Easy Ways To Insert Bullets In Excel | Insert bullet points

In this tutorial, let us learn the best way to create a plan vs actual graph in Excel.

Do You Know that we can show the multi categories in an excel chart??

In this tutorial let us learn about an interesting tool in Excel. With this tool, one can join pieces of text together into a single line an

In this tutorial, I will show you an interesting trick in Excel on How To Add Direct Legends To the Chart Itself.

Let us learn How To Create Waterfall Chart in Excel. This kind of chart looks like a waterfall and that's the reason why it has been calle

In this video tutorial we will see how we can prevent users from deleting rows and columns in Excel Sheet.

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

In this tutorial, let us learn about sparklines in Excel. Sparklines are types of graphs that show trends and variation of data....

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

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

In this video tutorial, let us learn how to apply borders to a table in MS Excel. I Prefer this method which makes our data speak out...

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