Working with dates in Excel can be tricky—especially when you’re using COUNTIFS to count records before or after a certain date. Many users make the common mistake of hardcoding the date directly into the formula, like this: At first glance, …
Lesson#260: How a Simple Excel Formula Can Revolutionize Your COUNTIFS for Date Values Read more »
Here I shall show you to make alphabet numbering formula. Like A, B, C, D…. or a, b, c, d…. Before starting that I want you to memorise that in ASCII code A starts from 65 and a starts from …
Lesson#154: How to make Alphabet numbering formula in Excel Read more »
Hello buddies! In this post, I am going to share a unique trick about how to insert blank rows after every row in the sheet. Definitely no formula, no functions needed for this. It’s so easy that I will use …
Lesson#153: How to insert blank rows after every row in sheet, No Formula method Read more »
Hey fellas! I am going to discuss some tricks to make a formula to repeat serial numbers. You may think how? Yes, these are easy formulas. Let’s say how about a formula that will continuously repeat the number 5 times …
Dear all, again welcome to my site with another simple trick discussion. Here I am going to discuss how to hide data without hiding cells or deleting data. Let’s assume that you are having a simple table like this. There …
Lesson#151: How to hide data without hiding or deleting cells Read more »
Hello Friends! Today I have brought some new problems with Excel. Today we are going to build an easy formula to copy multiple cell values multiple times in rows. I will explain this to you. Let’s see in the above …
Lesson#148: Copy multiple cell values multiple times in rows Read more »
Hello guys! I am back with a new lesson. Here I will show you to make a formula that can make a mirror of an excel table. Here I have made a table with some data. I will make a …
Lesson#143: How to make a mirror of a table in excel Read more »
This one is really a master method. Now I will show you a master method to rename all files in a folder at once using Excel. I am sure this solution is going to ease your huge workload at the …
Lesson#141: Master method to rename all files in a folder at once using Excel Read more »
Here I will make a formula in Conditional Formatting. This formula will color cells if the cell value is found in another column. For example, I am showing this picture below. If the value is present in column A then …
Lesson#140: Color cells if cell value found in another column – Conditional formatting Read more »
We have discussed working with PivotTable in previous lessons. Here I am going to share a small tip about GETPIVOTDATA in PivotTable. How to get rid of GETPIVOTDATA in PivotTable. When we are making some calculations on the Pivot data …
Lesson#139: How to get rid of GETPIVOTDATA in PivotTable Read more »