The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function…
If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet. Freeze Top Row To freeze the top row, execute the following steps. Step1. On the View tab,…
Addition in Excel Choose the cell where you want the result to appear as cell C6 in this example. Then type = sign in the cell, now select first cell C3 then type “+” sign then select second cell C4, again type + and select third cell C5. Now press…
Filtering, or temporarily hiding, data in a spreadsheet is simple. This allows you to focus on specific spreadsheet entries. To Filter Data Step 1: Click the Filter command on the Data tab. Drop-down arrows will appear beside each column heading. Step2: Click the drop-down arrow next to the heading you would like to filter.…
Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order. To Sort in Alphabetical Order Select a cell in the column you want to sort (In this example,…
Operators in Excel specifies the type of calculation to be performed on a given set of values. Excel has a rich variety of operators to perform calculative actions on a given set of data. Types of Operators in Excel Basically, there are 4 crude types of operators in Excel, mentioned as…
Microsoft Excel is one of the most suitable spreadsheet functions that help us manage data, create optically logical charts, and thought-provoking graphs. Microsoft Excel is supported by both Mac and PC platforms. Microsoft Excel can also be used to balance a checkbook, create an expense document, build formulas, and edit…