Microsoft I ; Excel

 

Microsoft Excel is a spreadsheet programme that is part of the Office product group for business applications. In a spreadsheet, Microsoft Excel allows users to arrange, organise, and calculate data. Data analysts and other users can make information easier to examine as data is added or altered by organising data using tools like Excel. Excel has a lot of boxes called cells, which are arranged in rows and columns. These cells are used to store data.

Excel is the most widely used spreadsheet programme in the business world. It's utilised in business analysis, human resource management, operations management, and performance reporting, to name a few applications. Excel organises and manipulates data and solves mathematical calculations by using a vast collection of structured cells. Graphing tools, pivot tables, and formulas can be used to organise data in the spreadsheet. Visual Basic for Applications is a macro programming language included with the spreadsheet application.

example of  excel spreadsheet

Here are 5 important Excel functions you should learn today :

The SUM Function - When it comes to processing data in Excel, the sum function is the most commonly utilised function. This function sums a set of numbers in a certain set of cells.

The syntax formula for sum function is “=SUM” (number1, number2, etc.).

The TEXT Function - The text function is a handy tool for converting a date (or a number) to a text string in a certain format. It belongs to the string formulas group because it turns numerical values to strings. When users need to see numeric data in a comprehensible style, it comes in helpful. 

The syntax formula for text function is “=TEXT” (value, format_text). 

• “Value” refers to the particular number you wish to convert to text.
• “Format_text” defines the format of the conversion.

The VLOOKUP Function - VLookup is a useful Excel feature that is frequently missed. It will come in handy when users need to locate certain data in a vast table. VLookup can also be used to search your sheet for people, phone numbers, or specific data.

The VLookup formula is “=VLOOKUP” (lookup_value, table_array, col_index_num, *range_lookup*). 

• “lookup_value” is the data you want to find.
• “table_array” is the data column where you want to limit your search.
• “col_index_num” is the column number within the table that you want to return a value from.
• “range_lookup” is an optional argument that allows you to search for the exact match of your lookup value without sorting the table.

The AVERAGE Function - The average function is a fantastic tool for calculating the average value of a group of cells. It's similar to the sum function in that it's widely used in spreadsheets to compute and analyse data. The average function is used to calculate the "arithmetic mean" of a bunch of cells.

The syntax formula for the average function is “AVERAGE” (number1, number2, etc.).

• “Number 1” refers to the first number in the range where you want the average.
• “Number 2” is the additional reference of the average range. You can get an average of up to a maximum of 255 cells.

The CONCATENATE Function - When you need to combine data from two or more cells, this function comes in handy. The concatenate function, unlike the merge tool, which physically merges two or more cells into a single cell, just mixes the contents of the merged cells.

The syntax formula for the concatenate function is “CONCATENATE” (text1, [text2…text_n])

• “Text1, Text2…text_n” are the data you want to combine.