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 as explained below. One of the ...

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

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.

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