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

Enter a formula or use the AutoSum feature to total all values in a row in Excel. The AutoSum feature enables you to obtain a total for all values in a row or column at the click of a button. You ...

Running totals are used to update totals within a series in Microsoft Excel. For instance, you might use a running total to track an account balance, enrolling students, or even inventory. Usually ...

Add a totals series: Include a new data series for the overall totals. Use Excel’s combination chart feature to layer the total column behind the individual columns, creating a visually distinct ...

Adding a partial column. Sometimes, you want to add a new column to just part of a spreadsheet. That's easy to do as well. Step 1: Select the cells to the right of where you want to add the new ...