Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

In this case, you’ll need a second subtotal row. How to add a second subtotal row to a PivotTable in Excel The default PivotTable is useful, but you might need more information.

Adding Multiple Rows in Excel You can add multiple rows at once in Excel, something that's often useful for adding multiple lines of data.

Spreadsheet applications like Excel enable you to insert, delete or rearrange entire rows of business data in ways that are difficult or messy to do with old-fashioned pencil and paper ledgers ...

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.