Sorting data in Microsoft Excel allows you to arrange information in a worksheet in a specific order based on the values in one or more columns. Select the Data Range: Before sorting, select the range of cells that contain the data you want to sort. You can click and drag to select a range, or […]
Data Shorting in MS Excel Read More »
A reference is a way to identify and locate data in a worksheet. References are used to perform calculations, create formulas, and build relationships between different cells, ranges, or worksheets. There are three primary types of references in Excel: relative references and absolute references and Mix. Relative Reference: A relative reference in Excel is
What is Reference in Excel? Read More »
“PMT” stands for “payment”, hence the function’s name. The PMT Function is categorized under financial functions in MS Excel. This function helps you to calculate the EMI (principal and interest) required to settle a loan or an investment with a fixed interest rate over a specific time period. Syntax: =PMT(rate, nper, pv, [fv], [type]) Arguments:
PMT Function in Excel Read More »
the PROPER function is a text function used to capitalize the first letter of each word in a text string, while converting all other letters to lowercase. This function is helpful when you want to format text so that it follows standard capitalization rules, such as making the first letter of names, titles, or sentences
PROPER Function in Excel Read More »
The LOWER function is a text function used to convert all the letters in a text string to lowercase. This function is helpful when you need to ensure that text is consistently in lowercase format, regardless of how it was originally entered. Syntax =LOWER(text) text: This is the text string that you want to convert
LOWER function in excel Read More »
the UPPER function is a text function that is used to convert all the letters in a text string to uppercase. This can be useful in various situations where you need to ensure that text is consistently in uppercase format, regardless of how it was originally entered. Syntax =UPPER(text) text: This is the text string
UPPER Function in Excel Read More »
When you invest your money such, you can earn interest on your investment amount. for example, you invest $3,000 with a 10% annual interest rate, compounded annually. One year from the initial investment (called the principal), you earn $300 ($3,000 x 0.10) in interest, so your investment is worth $3,300 ($3,000 + $300). For the
Compound Interest Calculator in Excel Read More »
Len function is used to measure the length of text in excel. Len function… measures the length of the text by counting all the characters. Along with the characters inside the Len function, if any space is given in the cell or special characters, symbols or numbers, then it also counts them. Syntax- =Len(text) Argument-
LEN Function in Excel Read More »
TRIM () Function In Excel This is a Pre-Defined Function of Excel and it is used to remove extra space from Text or Characters in Excel. The TRIM function keeps only one space between the text or characters and finds and removes all the extra blank space. Syntax- =TRIM(text) Arguments- Text– In this argument, we
TRIME Function In Excel Read More »
Concatenate Function in Excel is placed under Text Category and this function is used to join two or more values (Characters, Strings or Numbers) together. Like- First Name and Last Name are given in two different columns and if you want to merge them in one column then you can use Concatenate function in excel
Concatenate Function In Excel Read More »