Excel Tricks with Tejraj

In this blog post we will learn to about SUBTOTAL function in excel. SUBTOTAL function will return subtotal from the list or database. Where to find SUBTOTAL function on Excel Screen: SUBTOTAL function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. SUBTOTAL function is highlighted in blue in below image. Once we click on SUBTOTAL option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of SUBTOTAL Function: The Syntax of SUBTOTAL function is as below: =SUBTOTAL(function_num,ref1, ref2, …) Arguments of SUBTOTAL Function: SUBTOTAL function takes arguments as listed below: function_num : In this argument we have to enter 1 to 11. Each number represents different function as listed below: 1: AVERAGE 2: COUNT 3: COUNTA 4: MAX 5: M...

In this blog post we will learn about PRODUCT function in excel. PRODUCT function can be used when we want to multiply multiple values provided in the arguments. Importance of PRODUCT Function? In mathematics, PRODUCT of a number is calculated by multiplying all the input numbers. So in case we want to multiply the numbers then we can use the PRODUCT function. Usage of this function is more effective whenever we want to multiply huge numbers together. Where to find PRODUCT function on Excel Screen: PRODUCT function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. PRODUCT function is highlighted in blue in below image. Once we click on PRODUCT option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of PRODUCT Function: The Synt...