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.

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.

How to Sum a Column of Zeros in Excel. You can use the Sum function in Microsoft Office Excel to sum columns of data, whether your data is in an Excel table or is simply a range in a column of ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

Here is where Excel pivot tables step in to extract data, which can help you avoid getting lost in endless rows and columns.

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.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to interpret the parts of complex formulas.

Figure A Transfer the Excel Table into Power Query. How to add a new column in Power Query Our goal is to combine the t-shirt sales by client into a single cell for each client.

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