How to Convert Excel to Text & Set Column Width. Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column.

Learn how to Transpose Row to Column in Excel. Transpose converts horizontal row data sheets into vertical column style sheets and back.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

I also have a table containing students' scores (table 2 from this point). I want Excel to use the information in table 1 to complete the missing column in table 2.

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.