IFS Function

The Excel IFS function can run multiple tests and return a value corresponding to the first TRUE result. Use the IFS function to evaluate multiple conditions without multiple nested IF statements. IFS allows shorter, easier to read formulas. USES Test multiple...

Excel TRIM Function

The Excel TRIM function strips extra spaces from text, leaving only a single space between words and no space characters at the start or end of the text. USES   Remove extra spaces from the text Return value  Text with extra spaces removed. Syntax ...

Excel YEAR Function

The Excel YEAR function returns the year component of a date as a 4-digit number. You can use the YEAR function to extract a year number from a date into a cell or to extract and feed a year value into another formula, like the Date function. Purpose  Get the...

Filtering in Excel

Filtering allows you to extract data that meets the defined criteria from a given Range or table. This is a quick way to display only the information that is needed by you. You can Filter data in a Range, table, or PivotTable. You can filter data by − Selected...