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.

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

You can't use a SUM () function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

Adding color creates a great visual effect, but did you know that you can evaluate values by color? Use this technique to turn color into valuable information.