Averaging values in an Excel sheet is easy. But perhaps you want to ignore zeros or include multiple sheets. Knowing how each averaging function works is the key to choosing the right one.

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

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

Running totals show how figures build over an extended period, one entry at a time, allowing you to see trends and patterns that raw data alone might not reveal. Creating running totals in Excel ...

How to Do Averages With Percentages in Excel. Averages are typically computed as the sum of values divided by the number of data points. However, averages are also calculable from percentages.

In this post, I will show you how to create an efficient to-do list with all the relevant details and turn your chaotic task management into a solid and productive system.

How to Do Residuals in Excel. Linear regression models predict the outcome of one variable based on the value of another, correlated variable. Excel 2013 can compare this data to determine the ...

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.