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
Excel Case Tutorials
Excel Gantt Chart
This Excel tutorial showcases how to create a Gantt chart.
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.
Force Text to Upper- or Proper Case
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only.
Change Text to Upper- or Proper Case
When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case.
Upper to Lower Case Function “=PROPER()”
The following formula easily tranforms a list of data from Upper to Lower case. This is has come in handy several times.
PMT (loan stuff) Function
The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used for the car purchase in the first example. There are a few things that we must know in order for this function to work.
The scenario feature allows you to quickly change a number of input cells based on some predefined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios easily
LOWER, UPPER and PROPER functions in Excel
These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper.