Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

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.

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

Understand the basics of the earnings per share ratio, how this important financial metric is calculated in Excel, and how it's used in investment analysis.

Learn how to calculate the areas of rectangle, triangle, and circle in Excel for a single cell or range of cells usin this formula.

Place your cursor in cell D3. Please note that all formulas in Excel begin with the equal sign. Type the forward P/E formula in cell D3 as follows: =B3/C3 Press Enter or Return on your keyboard ...

Find out more about the return on assets (ROA) ratio and the formula for calculating a company's return on assets in Excel.