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 →
Previously I had discussed how to make an analog clock with piechart in excel. I am sharing the post link below. Lesson#61: Making a semi-analog clock with a pie chart Now I will add some simple VBA to make the …
Lesson#81: Making an automatic analog clock in excel with a pie chart 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 →
OK friends! How is everyone? Now in this post, we will learn an unusual trick to make a semi-analog clock with Pie Chart. Let’s see. First I have made a 3X3 table for the hour, minute, and second of the …
Lesson#61: Making a semi analog clock with pie chart Read more →
This sheet can calculate the value of your name or any word by summing every letter in alphabetical order. Here I have created a box to input a word. I have put this formula =LEN(B2) to calculate the length of the …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more →
Here I am having an employee database and I have to make a birthday reminder in excel from it. It needs a few tricks to make it. I have inserted two columns beside the DOB column, Upcoming Birthdays this Month and Birthday …
Lesson#56: How to make birthday reminder in excel Read more →
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by WHO. Let’s check where are we in our lifeline by this sheet. Let’s take an input of the date of birth from the user. …
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 →
Hi, friend today I will show you how to make an automatically updating Gantt chart without using an Excel chart. Here I am making a program schedule with this criteria Activity no, Description, Start Date, End Date, and Days (shown …
Lesson#39: Cool tricks to make automatically updating Gantt chart Read more →
AND function is used to satisfy multiple conditions. This function checks whether all arguments are TRUE then it returns TRUE. Syntax of that function is AND(logical1, logical2, ….) Example: Here I have shown an example where the values of the …