Subscribe
Tutorial search

LOWER, UPPER and PROPER functions in Excel - Excel tutorial


These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper.
Category: Excel > Functions - Difficulty:


More cool Excel tutorials:



How To Change The Chart Legend Font In Excel
How To Change The Chart Legend Font In Excel
This video tutorial shows how to change the font of the chart legend in Excel.
Difficulty:
DAYS360 Function
DAYS360 Function
The DAYS360 function is used to calculate the number of days between two dates. It is based on a 360 day calendar.
Difficulty:
DAVERAGE Function
DAVERAGE Function
The DAverage function in Excel is used to calculate the average of values in database based on entered criteria.
Difficulty:
Find/ Replace in Excel
Find/ Replace in Excel
The find replace tool is more commonly used in MS Word. However, it is extremely useful in Excel and can be used to quickly make changes to a spreadsheet.
Difficulty:
Prevent Case Sensitivity in VBA Code
Prevent Case Sensitivity in VBA Code
By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words.
Difficulty: