You can use the PROPER function to change the text from lower case or upper case to Proper case. In other words, using the PROPER Function you can change your text in the cell into starting alphabet as capital and all the rest into small. For example, if you have your text in abc or […]

# Formulas & Functions

## How to use LOWER Function in Excel – Infographics

You can use LOWER function to change the text from upper case or proper case to lower case. In other words, using the LOWER Function you can change your text in the cell into all small letters. For example, if you have your text in ABC or Abc format we can change it to abc […]

## How to use UPPER Function in Excel – Infographics

You can use UPPER function to change the text from lower case or proper case to upper case. In other words, using the UPPER Function you can change your text in the cell into all capital letters. For example, if you have your text in abc or Abc format we can change it to ABC […]

## How to Round Floating Values to Even or Odd Numbers

We discussed rounding of floating values using ROUND, ROUNDUP and ROUNDDOWN functions. What if I want these rounding of numbers to be even or odd? Today, we will learn how to round values using EVEN, ODD, CEILING and FLOOR Functions. Let’s understand each of these functions with some examples. EVEN Using EVEN function, a number […]

## How to Rank a Set of Numbers in Excel

RANK function is used to compare numbers to other numbers in the same list. RANK function will tell you the rank of a given number from a range of number in ascending or descending order. Syntax =RANK(number or cell address, ref, (order)) This function is used at various places like schools for Grading, Salesman Performance […]

## How to Change Text to Uppercase, Lowercase, Propercase in Excel

In this article today, we will discuss some common text functions like UPPER, LOWER and PROPER which we can use to convert our text to lowercase, uppercase or proper as required. Excel has many built-in functions related to text operations Text category. Once we start working with a few, we can work on others quite […]