Source: Safalta.com
1. Introduction to Digital Marketing
2. Website Planning and Creation
Top 5 Functions of MS Excel
1.Summation Function
When it comes to calculating data in Excel, the sum function is the most often utilised function. This function adds up a collection of integers in a certain set of cells. This implies that you don't have to create a lengthy, complicated formula in order to add up all the data you want. Newer versions of Microsoft Excel contain a button expressly for this function because of how popular it is. To use this function, type the formula in the function bar, highlight the cells you wish to sum, and press "Enter." Additionally, you must be cautious while highlighting cells since Excel will add everything you do. If this occurs, just click the "Undo" button to restore the settings to their initial state."=SUM" is the syntactic formula for the sum function (number1, number2, etc.).
2. The TEXT feature
A date (or number) may be transformed into a text string in a certain format using the text function, which is a helpful tool. It belongs to the class of string formulae that stringify numerical values. When people need to display numerical data in a comprehensible style, it is useful. Remember that the "TEXT" formula can only translate numerical numbers into text. As a result, its outcomes cannot be computed."=TEXT" (value, format text) is the syntactic formula for the text function.
Value is the specific number that you want to convert to text.
The format of the conversion is specified by "Format text".
3. The VLOOKUP Function
Excel's strong VLookup feature is frequently disregarded. When a user needs to locate certain data on a big table, it will be helpful. You may use VLookup to look up people's names, phone numbers, or other particular information in your spreadsheet. The VLookup function speeds up and streamlines this procedure rather than requiring laborious name-finding and scrolling through hundreds of data."=VLOOKUP" (lookup value, table array, col index num, *range lookup*) is the VLookup formula.
- The information you're looking for is "lookup value."
- The data column where you wish to focus your search is "table array."
- The column within the table that you wish to retrieve a value from is designated by "col index num."
- Without sorting the database, you may search for an exact match of your lookup value by using the optional input "range lookup.
4. Function CONCATENATE
When combining data from two or more cells, this function can help you save time. The concatenate function just combines the contents of the merged cells, as opposed to the merge tool, which physically merges two or more cells into a single cell. The concat function has taken the place of the concatenate function in the most recent (2016) version of Excel and will be added to other versions in the future.The syntax formula for the concatenate function is “CONCATENATE” (text1, [text2…text_n]),
- “Text1, Text2…text_n” are the data you want to combine.
5. The MEDIAN Operation
To determine the average value over a group of cells, use the average function. It is extensively used in spreadsheet computation and data analysis, much like the sum function. The "arithmetic mean" for a collection of cells is essentially what the average function attempts to determine. Excel also provides functions for the median and mode in addition to the average function.The average function's syntactic formula is "AVERAGE" (number1, number2, etc.).
- The first number in the range where the average is desired is referred to as "Number 1."
- The supplementary reference for the average range is "Number 2." An average of a maximum of 255 cells is possible.
The formula "=AVERAGE (A2:A10)" calculates the mean value for the data in cells A2 through A10.
B2: B10, 7 = AVERAGE - calculates the average of the values in cells B2 through B10 as well as 7.