Excel Tricks with Tejraj

We have already learned about Inserting Shapes as well as Inserting Images in excel. Now, in this blog post we will learn about inserting images in shapes in excel. We will learn to insert an image (which is logo of our website “ Excel Tricks with Tejraj ”) into various shapes. First we will insert the shape in excel and then we will insert the logo into inserted shape. Insert Image in Oval Shape: First, click on “Insert” tab and then click on “Shapes” command. Once we click on “Shapes” command, we can see various shapes available in excel. Out of these, you can select any shape as per your choice. In this case, we want to select the “Oval” shape. If you are not aware about the names of these shapes, then you can just place the mouse cursor on any shape which will automatically show the name of that shape. Once we click on the “Oval” shape, the shape of mouse cursor will change from doctor symbol to plus symbol. As soon as the mouse cursor symbol changes to plus symbol, we can draw ...

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...