Learn how to use basic Formulas for mathematical operations & insert Functions like sum, average, count, max, min, date, time, etc. in Excel.

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.