Here I am having a list of dates. Now I will show how to count cells in Excel having values between two dates. So I made here a list of months from Jan-18 to Dec-18. Then I have put this …
Lesson#67: Count cells in Excel having values between two dates 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 »
Can you count rows by color? Yes, It’s very easy and simple. Here I have a data table that has different colors in rows. I have counted rows by color in these simple steps. 1. I will add a Filter …
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 »
This is a project schedule format where I have a list of dates and works. I need to color all the Sundays in the list of dates and for that, I will use a simple trick. Select all the dates …
Lesson#53: Simple trick to color all the Sundays in the list of dates at once 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 »
This character “*” (Asterisk) is used to denote any text within a cell. 1. If you use the formula =COUNTIF(range, “*”) then it will count the numbers of cells having any text within range. 2. If you use =COUNTIF(range, “CEMENT*”) …
Lesson#46: Count cells that contain any text or part of that text Read more »
Sometimes it needs to paste a list in reverse then a simple trick should keep in mind. A simple trick to paste in reverse order. Copy the list and paste it. Add an extra column beside this column. Add digits in …
Lesson#44: A Simple trick to paste in reverse order Read more »
Showing a random example worksheet where I have used conditional formatting and color formatting. Now I will make a switch that will trigger the Conditional Formatting ON or OFF. Besides the table, I have made a drop-down list of ON/OFF …
Lesson#43: Make an ON/OFF switch for Conditional Formatting in your excel sheet Read more »