How To Use Condition in SUMPRODUCT

how to use conditional sumproduct in excel

SUMPRODUCT is one of the powerful excel functions. And, today, I will show you one of its amazing powers. You will learn how can you write a conditional sumproduct function. Well, as you know you can use sumproduct to multiply and sum specified ranges or arrays. But, while using a conditional sumproduct you can you can […]

Check it out now

How To Create a Milestone Chart in Excel

how to create a milestone chart in excel

Tracking all the steps of a project is an important task. It’s as important as the execution of the each step. In fact, tracking makes execution easy. And, a milestone chart is a perfect way to track a project in a simple way. The basic idea in milestone chart is to track each step of your project on a […]

Check it out now

How To Create Barcode Generator Template In Excel

how to create a barcode template in excel featured image

Do you want to create a barcode in excel? So today, just for you, I will reveal the method to create barcode generator template in excel. In this post, I will show you how to generate code 39 barcodes. Code 39 is known as Code 3 of 9 which is the most used barcode and able to scan […]

Check it out now

How To Highlight Duplicate Values Using VBA

highlight duplicate values using vba

While working with huge data, Duplicate Values are always a concern. And, I am sure most of the time you remove them with remove duplicate option. But, removing duplicate values or just counting duplicate values never sort out the problem. The important thing is to review all the duplicate values before deletion. So, today I will […]

Check it out now

Add a Horizontal Line in a Chart

featured image to add horizontal line in excel chart

You can add a horizontal line in an Excel chart to use as a target line. All you need, 30 seconds to add a horizontal line to an excel chart. And, without much efforts. You know what, my company’s CEO told me these things a year back. It is better to have a comparison to […]

Check it out now
1 7 8 9 10 11 26