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…

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…

Undo and Redo Operations in MS Word

Microsoft word provides two important features called the Undo and the Redo. The Undo feature is used to undo the previous action and the Redo feature is used to repeat the previous action. For example, if you mistakenly delete some text, you can use the Undo feature to recover it. In a similar fashion, if you delete…

MS Word: Inserting Special Symbols

Our keyboard may not have many characters available but you want to use those characters in your document; in such situations, you have the option to insert Special Symbols. Step 1 − To insert a special symbol, bring your cursor at the place where you want to insert the symbol. Click the Insert tab.…

MS Word: Spell Check

Microsoft Word provides a decent Spelling and Grammar Checker which enables you to search for and correct all spelling and grammar mistakes in your document. Word is intelligent enough to identify misspelled or misused, as well as grammar errors and underlines them as follows: A red underline beneath spelling errors.…