Excel Tricks with Tejraj

31/10/2024

Happy Diwali 🪔 🪔

11/09/2024

07/09/2024

Amazing fact about Excel Sheet.

20/08/2024

Don’t waste your time to manually type dates for respective days.. Instead try this amazing excel trick👇🏻 Follow Excel Tricks with Tejraj

20/01/2024

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 will return subtotal from the list or database.

02/10/2023

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

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.

19/09/2023

Ganpati Bappa Morya 🙏🙏

30/07/2023

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

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

19/05/2023

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 will return value of Pi which is mathematical constant which has value of 3.14.

19/04/2023

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 can be used when we want to multiply multiple values provided in the arguments.

09/03/2023

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 will return random numbers between the two numbers provided by the user.

04/03/2023

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.