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
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.
More cool Excel tutorials:
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.
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.
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.
Create 3-D Charts in Excel
Learn step by step with screenshots how to create 3-D charts in Excel.
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