How to Reverse a Column Order in Microsoft Excel. Reversing the order of a column would be easy if the column was already listed alphabetically or sequentially; you would just sort in the other ...

How to Make a Two Column Spread Sheet on Microsoft Excel. Unless someone's calculator needs an upgrade, one plus one usually adds up to two. With Microsoft Excel, you can put that math to work ...

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.

To sum a Column in a Microsoft Excel spreadsheet, you can use the AutoSum, the Status Bar, and even the Sum function to calculate values in one or more columns ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s ...

The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. Here's how to do it.

How to insert multiple rows in Microsoft Excel on your Mac or PC How to hide and unhide columns in Excel to optimize your work in a spreadsheet How to add a column in Microsoft Excel in 2 ...