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.

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

How to Use the IF Function in Excel 2007 With Absolute References. Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's ...

As part of key combos in Word, Excel, and Outlook, they make it easier and faster to perform commonly used commands. Here are 15 of the most essential function-key strokes.