Subscribe
Tutorial search

Excel Case Tutorials


Sort by:
Excel Gantt Chart
Excel Gantt Chart
This Excel tutorial showcases how to create a Gantt chart.
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:
Force Text to Upper- or Proper Case
Force Text to Upper- or Proper Case
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only.
Difficulty:
Change Text to Upper- or Proper Case
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.
Difficulty:
Upper to Lower Case Function =PROPER()
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.
Difficulty:
PMT (loan stuff) Function
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.
Difficulty:
Multiple Scenarios
Multiple Scenarios
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
Difficulty:
LOWER, UPPER and PROPER functions in Excel
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.
Difficulty:
Search Term(s) (1): case