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.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.

In a nutshell: Formulas are a must for incorporating math into spreadsheets, but using them in Microsoft Excel involves a learning curve and can become tedious. This latest update adds a bit of ...