Working with dates in Excel can be tricky—especially when you’re using COUNTIFS to count records before …
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 …
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 …
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 …
Dear all, again welcome to my site with another simple trick discussion. Here I am going …
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 …
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 …
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 …
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 …
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 …
Lesson#139: How to get rid of GETPIVOTDATA in PivotTable Read more →