Hey friends in this article we will learn Excel SUM function. Using the Excel sum function you can add numbers easily without using plus sign. You can add numbers using sum function in two ways so let’s see: 1. Type =SUM(1,2) this will give you answer “3” 2. Type =SUM(A2:A3) this will give sum of […]
Hey friends here you can learn Excel and practice online free of cost. If you like this content then don’t forget to share it with your friends. Basic – Maths (=,+,-,/,*) How to perform basic maths functions in Excel like how to add two numbers, how to subtract two numbers, Multiplication, and division. Sum Hey […]
Extract PAN from GST number: Friends in this article we will learn how to extract PAN from GSTIN (Goods and Service Tax Identification Number). so let’s get started because if you don’t start you will always only be stuck in your thoughts. With the help of excel we can eaisly extract PAN from the goods […]
CTRL + SHIFT +L: Do you know what is the use of this shortcut? If you know this then write your reply in the comment box. It is related to filter in excel. It can be difficult to find information quickly if your worksheet contains a lot of content. Excel Filter, is used to narrow […]
In this article, we will learn about various ways to use excel filter shortcuts. Like how to apply filter, how to open the drop-down menu in excel filter etc. so let’s start… 1. How to apply Filter in Excel? In the below-given example, we will take data from a list of top billionaires. Friends when […]