VLookUP in MS Excel

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…

Filtering Data in MS Excel

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 in MS Excel

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 MS Excel

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…

Introduction of MS Excel

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…