Hello friend. In this post, I will show how to get a new fresh formatted sheet …
Lesson#75: Get a new fresh formatted sheet every time when you click the button Read more →
Here I am having a list of dates. Now I will show how to count cells …
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 …
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 …
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 …
Here I am having an employee database and I have to make a birthday reminder in …
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 …
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 …
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 …
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 …
Lesson#44: A Simple trick to paste in reverse order Read more →