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

When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you ...

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 ...

How to Calculate a Vlookup on Excel for Loans. In Excel a "Vlookup," short for vertical lookup, is a formula used to return a value from a table of data. For example, you might want to add a ...

This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report.

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

Several basic templates are available for Microsoft Excel that make it simple to calculate production costs.

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.

Everyone likes a bonus, but sometimes calculating one can be a bit complicated--at first. Here's how to calculate the amount in Microsoft Excel that you or your staff will get paid.

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

Find out how to use Microsoft Excel to calculate the present value of a fixed annuity, including a calculation example. The calculation doesn't account for taxes.