Excel's OFFSET function lets you create a reference that isquite literally offset from a starting point. It allows references to adjust dynamically to changes in your spreadsheet's data and structure.

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.

How to Change the Character Set in Excel 2007. When doing business internationally, it's often necessary to use international symbols to display financial information.

Charts are great for showing comparisons and trends. In this tutorial, we will explain how to apply layouts and styles in a chart in Excel.

How to Change the Height & Width of Cells in Excel. Upon launching Microsoft Excel, an exactly-formatted spreadsheet grid is presented for you to start filling in.

In this guide, we'll show you the different ways to reduce the size of a Microsoft Excel spreadsheet to make it easier to share and store.