News

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.
How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known ...
How to Use Excel to Calculate Incremental Cost & Incremental Revenue. Microsoft Excel can be a powerful tool for large and small businesses alike. It is used to perform calculations, store and ...
Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.
Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.
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 a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.
Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.
Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.
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.
Follow along in this step-by-step guide to learn how to easily calculate hours worked in Microsoft Excel.
Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.