UPPER, LOWER, PROPER in Excel - Dashboard Guide

Dashboard Mode - UPPER, LOWER, PROPER

Goal

See how text can be changed to all uppercase, all lowercase, or proper case (first letter capitalized) to clean up names and make data look neat.

Sample Data

Original Name
john smith
MARY JONES
alice Johnson
robert BROWN
emily davis
MICHAEL CLARK

Dashboard Components

• Uppercase Names: Shows all names in uppercase letters.
  Formula example: =UPPER(A2) copied down.
• Lowercase Names: Shows all names in lowercase letters.
  Formula example: =LOWER(A2) copied down.
• Proper Case Names: Shows names with first letter of each word capitalized.
  Formula example: =PROPER(A2) copied down.

Dashboard Layout

+----------------+----------------+-----------------+
| Original Names | Uppercase      | Lowercase       |
|                | Names          | Names           |
|                |                |                 |
| john smith     | JOHN SMITH     | john smith      |
| MARY JONES     | MARY JONES     | mary jones      |
| alice Johnson  | ALICE JOHNSON  | alice johnson   |
| robert BROWN   | ROBERT BROWN   | robert brown    |
| emily davis    | EMILY DAVIS    | emily davis     |
| MICHAEL CLARK  | MICHAEL CLARK  | michael clark   |
+----------------+----------------+-----------------+
+-----------------+
| Proper Case     |
| Names           |
|                 |
| John Smith      |
| Mary Jones      |
| Alice Johnson   |
| Robert Brown    |
| Emily Davis     |
| Michael Clark   |
+-----------------+

Interactivity

Add a filter to select specific names or search text. When you filter the original names, the uppercase, lowercase, and proper case columns update automatically to show only the filtered names.

Self Check

If you add a filter to show only names containing "john", which rows appear in the uppercase and proper case columns?

Key Result

Dashboard shows original names and their uppercase, lowercase, and proper case versions side by side.