How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
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.
More cool Excel tutorials:
How To Change The Chart Legend Font In Excel
This video tutorial shows how to change the font of the chart legend in Excel.
The DAYS360 function is used to calculate the number of days between two dates. It is based on a 360 day calendar.
The DAverage function in Excel is used to calculate the average of values in database based on entered criteria.
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.
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.