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…

Mail Merge in MS Word

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet. When performing a Mail Merge, you will need a Word document (you can start with an existing one or create a new one) and a recipient…

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…

Table in MS Word

https://youtu.be/hHA1GGV2NQI A table is a structure of vertical columns and horizontal rows with a cell at every intersection. Each cell can contain text or graphics, and you can format the table in any way you want. Usually the top row in the table is kept as a table header and…

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…