Excel Tricks with Tejraj

Happy Diwali 🪔 🪔

SUBTOTAL function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group.

Let's learn in details about this:
https://www.exceltrickswithtejraj.com/2023/06/subtotal-function-in-excel.html

SUBTOTAL Function in Excel SUBTOTAL function will return subtotal from the list or database.

Whenever we want to calculate SUM based on multiple criteria's, we can use SUMIFS function in excel.

Visit below link to learn in detail 👇👇

https://www.exceltrickswithtejraj.com/2023/05/sumifs-function-in-excel.html

SUMIFS Function in Excel In this blog post we will learn to calculate the sum based on set of criteria’s or conditions, with the help of SUMIFS function.

Let's learn about SUMIF function in excel. Visit below link👇👇
https://www.exceltrickswithtejraj.com/2023/05/sumif-function-in-excel.html

SUMIF Function in Excel Whenever we want to calculate the SUM based on certain criteria or condition, we can use the SUMIF function.

Let's learn about PI Function in excel. Visit below link 🔗 to learn in detail:

https://www.exceltrickswithtejraj.com/2023/04/pi-function-in-excel.html

PI Function in Excel PI function will return value of Pi which is mathematical constant which has value of 3.14.

Let's learn about the PRODUCT function in excel.

Visit below link 🔗
https://www.exceltrickswithtejraj.com/2023/04/product-function-in-excel.html

PRODUCT Function in Excel PRODUCT function can be used when we want to multiply multiple values provided in the arguments.

Let's learn about entering random numbers using RANDBETWEEN function in excel.

https://www.exceltrickswithtejraj.com/2023/03/randbetween-function-in-excel.html

RANDBETWEEN Function in Excel RANDBETWEEN Function will return random numbers between the two numbers provided by the user.

Let's learn to restrict cells to accept only "Time" using "Data Validation"

👉🏻Visit: www.exceltrickswithtejraj.com
👉🏻Go to "Topics" section
👉🏻Click on topic "restrict cells to accept only time using data validation"

Follow to learn more excel tricks.