Comparison of text between cells is possible in Excel through an Excel Formula. Exact function helps in comparing 2 cells, to check if the values within the cell is matching exactly. This function can be very helpful, as various use
Tag: Microsoft Excel Formulas
Combining text in Excel can be very useful in many situation. There can be various use cases like combining first name and last name, combining address and zip codes, combining phone number and country codes etc. Concat function helps in
Lower Case function helps in making text in Lower case, i.e. all characters of each word as Lower. Lower case function is helpful to format the content in Excel file. All the text that is not present in proper cases,
Upper Case function helps in making text in Upper case, i.e. all characters of each word as upper. Upper case function is helpful to format the content in Excel file. All the text that is not present in proper cases,
Proper Case function helps in making text in proper case, i.e. First letter capital and rest lower case for all words. Proper case function is helpful to properly format the content in Excel file. All the text that is not
Left function helps in extracting content from text in an Excel Cell. There can be many use cases where we have to work with Text values in Excel. For example there may be a need to extract, first name from
Average value calculation can be helpful in many use cases. There can be a need to find average spend volume, or average transaction volume, or average height etc. Average function helps average value calculation in Microsoft Excel. Average function is
Minimum value calculation can be helpful in many use cases. There can be a need to find minimum spend, or minimum transactions, or minimum salary etc. Min function helps minimum value calculation in Microsoft Excel. Min function is one of
Maximum value calculation can be helpful in many use cases. There can be a need to find maximum spend, or maximum transactions, or maximum salary etc. Max function helps maximum value calculation in Microsoft Excel. Max function is one of
Sum function is one of the basic function in Microsoft Excel. This is leveraged multiple times while doing any analysis. As sum remains one of the important function to work with, we will discuss basic steps to learn this function.