In Microsoft Excel, you can change the case of text inside a cell using functions for Proper Case, Uppercase, and Lowercase. Here’s how to do it:

 1. Convert to Uppercase (UPPER function)
This function changes all letters in a cell to uppercase.

- Syntax: 
  excel
  =UPPER(cell)
  
- Example: 
  excel
  =UPPER(A1)
  
  If cell A1 contains "hello world," the formula will convert it to "HELLO WORLD."

The COUNTIF function in Microsoft Excel counts the number of cells within a range that meet a specified condition. It’s useful for quickly tallying entries that match specific criteria in your data.

 Basic Syntax

=COUNTIF(range, criteria)
 

- Range: The range of cells where you want to count the items.
- Criteria: The condition you want to apply (e.g., a specific number, text, or expression).

 Example Usage