How to create BAR chart in Excel
Bar chart represent the categorical data in bars or columns. It can be plotted horizontally and vertically. It can be…
Excel
MAX,MIN,LARGE,SMALL Function in excel
MAX formula will return the maximum value present in row or column. N formula will return the minimum values present…
Countif and Sumif in Excel
The countif function count cell value by given criteria and sumif function sum the values of cell by mentioned criteria.
Xlookup Function in Excel
If we want to vlookup something in excel it should be in left to write order otherwise vlookup will not…
Unique Formula in Excel
formula in excel is used to find unique values in a row or column and results list of distinctive element.
IF and Nested IF in Excel
IF formula in excel is used when one condition in bracket will be true then it will give result as…
Substitute and Replace in Excel
The Replace formula is used if we want to replace any character by its position. Substitute formula is used if…
Lower ,Upper and Proper Formula in Excel
The Lower formula in excel will result in all lower case characters. Upper case formula returns all characters in upper…
Find and Search Formula in excel
The Find and search function is used to find text or characters in cell. Both will return the number at…
Formulatext function in Excel
t is used to document formula of a cell in sheet.