Subscribe
Tutorial search

Change Text to Upper- or Proper Case - Excel tutorial


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.
Category: Excel > Macros - Difficulty:


More cool Excel tutorials:



Forumulas and Functions
Forumulas and Functions
Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult, especially as spreadsheets grow and are reused. What's more, the formula and function capabilities built into Excel might not always be what you want, further complicating the situation. Fortunately, there are a lot of ways you can keep your formulas and functions sane.
Difficulty:
Create 3-D Effects in Tables or Cells
Create 3-D Effects in Tables or Cells
It is easy to create this illusion yourself by applying formatting to a cell or range of cells.
Difficulty:
Using Excel to Calculate the Area of a Circle
Using Excel to Calculate the Area of a Circle
The video I created below shows you how to use Excel to calculate the Area of a Circle. Now, many may consider this exercise to be pointless, but it is more of a training exercise.
Difficulty:
Create 3-D Charts in Excel
Create 3-D Charts in Excel
Learn step by step with screenshots how to create 3-D charts in Excel.
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: