Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

If you wish to calculate the GPA or Grade Point Average in Microsoft Excel or other Excel editor, you can use this formula.

Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

If, for example, you wanted to calculate your returns after taxes, you could input the amount of taxes due in the table as a negative number to recalculate an after-tax return.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

How to Calculate Fluctuations in Excel. Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for ...