Often we need to find the duplicate values in an Excel worksheet. Here in this post, I will discuss 4 Ways to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT The Excel MODE function returns the …

Lesson#103: 4 Ways to find duplicate values in a worksheet Read more »

Hello Friend! I am back again with my other post. This post is about Conditional Formatting. Here I will show how to highlight a column value depending on the column values next to it. In the above picture, I am …

Lesson#92: How to highlight a column value depending upon the other column values Read more »

So here I will show you a simple but very useful trick with Conditional Formatting. This is about how to highlight a particular number in an array automatically. So in the above picture, I have a number array where I …

Lesson#90: How to highlight a particular number in an array automatically Read more »

Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating Gantt chart without using an excel chart It was a day-wise scheduling format. Here I will show how to make a month-wise scheduling format. First I …

Lesson#87: How to make month wise auto-updating program schedule Read more »

We will learn how to make an automatically refreshing bar clock in excel. 1. First I made three merged cells by putting these formulas =HOUR(NOW()) =MINUTE(NOW()) =SECOND(NOW())   2. Select those cells one by one and click on Conditional Formatting>Data …

Lesson#80: Make an automatically refreshing bar clock in Excel Read more »

Here I have got a case where my colleague was working with a project schedule. He had a schedule with a start date, end date, and scope and he had to break up the scope month-wise. With a long schedule, …

Lesson#77: Scope the breakup program schedule and explain the formula Read more »

Here I have to make a parent Gantt chart from a data table. It is a Gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value …

Lesson#49: Make a parent Gantt chart from a data table Read more »