SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.

There are times where rounding values to the nearest decimal or whole number should be used to improve the look and clarity of your Excel presentation. When you round numbers, you remove the least ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

The subtotal function in Excel is a handy way to calculate smaller amounts, separate from the final total. It's relatively easy to use in a spreadsheet, and it allows you to organize your data. The ...

The purpose of the Bin2Hex engineering function in Excel is to convert a binary or decimal to hexadecimal. Learn how to use it properly.

Subtotals - Having a list in Excel and just filtering it does not always give you all you desire. Using the Subtotal function in that list may.