Excel has so many formula that you never feel satisfied learning them, and hence a good tutorial is a must. “Excel Experts” are the best of its kind. Some of the basic formulas include:
Have you thought that there could be certain formula like this? Still, it does what you think it would. Any formula called “Now” deserves to get in simply because it is called “Now”. It simply returns today’s date and time as of just type “now”, and see the magic.
The Top excel training Rept formula takes a text string as an input, and repts it out as many times as you like.
c) The Roman:
The Roman formula returns the Roman value of an Arabic integer. But it’s a useful thing to know, the Roman formula in many other cases and this function would surely going to help you out. Arabic integers are the good old numbers that we always end up using. 543. it’s DXLIII, for what it’s worth.
Fret not just enter “=Combin (50, 2)” in any cell and hit enter. Learn that there are 1225(!) ways of choosing 2 objects out of 50. Then you will surely get Goosebumps by reading the question which you once have solved it long back may be in 6th grade and now you hardly remember anything of it. Probability, permutations, and combinations will surely give Goosebumps isn’t it? Suppose you have how many ways can you choose 2 objects out of, say, 50 or 150, or even 2000?