If you want to change the text case from lowercase to uppercase in Microsoft Excel, then this guide shows you five ways to do it.

Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

How to Change the X-Axis Range in Excel Charts. For a business owner, Microsoft Excel 2010 provides an excellent platform for storing numerical information about your business.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

How to combine values into a single cell in .xls Excel files The newer features and functions that I’ll be using later in this article aren’t available in the earlier .xls format.

If you are interested in learning more about how you can manage data categorization in Excel while preserving historical values, a concept known as a “slowly changing dimensions” (SCD ...