How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

How to Calculate the Total Hours Formula in Excel. As a spreadsheet software program, Microsoft Excel has many useful features for a small business's productivity.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Column functions and Columns functions are Lookup and Reference functions in Microsoft Excel. The Column function returns the column number of a reference, and its formula is Column([reference]).

Figure E Quickly applying a few formats to the subtotals and grand total in Excel helps them stand out a bit from the data by moving them to a column of their own.

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

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

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.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.

The VLOOKUP function is one of the most useful when pulling information from an Excel database. Here's how it works and how you can start using it in your work.