Technical Learnoji

16/04/2023

27/01/2023

😋😋😋

23/01/2023

Product function in Excel is used to calculate the product of a range of numbers. It is a built-in mathematical function that multiplies the values in a given range of cells. The syntax for using the product function is =PRODUCT(range), where "range" is the set of cells containing the numbers to be multiplied.
For example, if cells A1 through A5 contain the values 2, 3, 4, 5, and 6, respectively, the formula =PRODUCT(A1:A5) would return the product of 23456 = 720.
Drop ❤️ comment, follow and share...💖💖💖

21/01/2023

The SUMSQ function is used to calculate the sum of the squares of a range of cells. The syntax for the function is: =SUMSQ(range) where range is the range of cells to be squared and summed. For example, if the range of cells to be squared is A1:A5, the formula to calculate the sum of the squares would be =SUMSQ(A1:A5), or by selecting only one cell it provides the above result.
Drop ❤️ comment, follow and share...💖💖💖

21/01/2023

The SUMSQ function is used to calculate the sum of the squares of a range of cells. The syntax for the function is: =SUMSQ(range) where range is the range of cells to be squared and summed. For example, if the range of cells to be squared is A1:A5, the formula to calculate the sum of the squares would be =SUMSQ(A1:A5), or by selecting only one cell it provides the above result.
Drop ❤️ comment, follow and share...💖💖💖

20/01/2023

Coming back soon..

28/12/2022

Congrats

09/12/2022

How to insert random number/s in the selected cells with Excel =RANDBETWEEN(). Specify a bottom number, and a top number and the formula will return a random integer number within that range of numbers.
Drop ❤️ comment, follow and share...💖💖💖
Procedure :
1. Select only one cell and type =RANDBETWEEN(5, 1000) by pressing only ENTER, it will return any random number between 5 to 1000. e.g. refer to cell CC4.
2. Select the cells in which you want random numbers between 50 to 2500, and type =RANDBETWEEN(50, 2500) by pressing only CTRL+ENTER, it will return desired random numbers. e.g. refer cell CD4 to CD21.
3. Select the cells in which you want only one random number which will be any number between 100 to 4500, type =RANDBETWEEN(100, 4500) by pressing only CTRL+SHIFT+ENTER, it will return only one random number in all the selected cells. e.g. refer cell CE4 to Ce21.

09/12/2022

I've just reached 600 followers! Thank you for continuing support. I could never have made it without each one of you. 🙏🤗🎉

05/12/2022

Inserting numbers in Excel is a simple task, but it can be time-consuming. There are many ways to insert numbers into the spreadsheet, and they all have their pros and cons. Here I have shown a simple way to insert numbers by just selecting cells and pressing CTRL+ENTER.
Drop ❤️ comment, follow and share...💖💖💖