Hello readers! In this post, we shall learn about the 25 most useful Excel Functions everyone needs to know. Newcomers who start to learn Microsoft Excel gets easily confused with hundreds of excel formulas and functions. So today we shall …
Lesson#155: 25 most useful Excel Functions everyone needs to know Read more »
RANDBETWEEN(bottom, top) this function generates random numbers in integer value. But if you want to generate random numbers in fraction then do this. Suppose need to generate random numbers between 100.56 to 125.36 Then I shall make the formula like …
Short Tips#0084: How to use RANDBETWEEN function to generate random numbers in fraction? 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 »
Today I am going to discuss how to write all numbers in a minimum of four digits or three or five. It’s a very common question that people often ask on Excel forums. I shall share two easy methods to …
Lesson#150: how to write all numbers in a minimum of four digits? Read more »
Hey friends! I have just published a new video explaining how to make auto numbering formulas that can generate serial numbers automatically. Please do watch this video and share if you like it. Don’t forget to subscribe the channel Excelabcd.
Hello and welcome to my blog Excelabcd. Today in this post we are going to have a lesson on How to reduce excel file size. I shall discuss 11 ways to reduce Excel file size. Sometimes we have to work …
Lesson#149: 11 ways to reduce Excel file size. How to reduce excel file size? Read more »
Hey friends! I have just published a new video explaining how to make auto numbering formulas that can generate serial numbers automatically. Please watch this video and share it if you like it. Don’t forget to subscribe to the channel Excelabcd.