Excel-Tips

LOWER, UPPER and PROPER are text functions which let us do the following:

LOWER – Converts all words in the text to lowercase.

UPPER – Converts all words in the text to uppercase.

PROPER – Capitalizes the first letter in each word in the text.

Syntax

=LOWER(text)

=UPPER(text)

=PROPER(text)

The COUNTIFS function is a premade function in Excel, which counts cells in a range based on one or more true or false condition.