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.

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column ...

How to Change Columns Into Rows in Excel 2007. If you've ever entered a long list of business data and realized you need this information across a row instead of down a column, you can take ...

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.