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.

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

None of the spaces here are required. As you can see in the screenshot below, the formula works without these spaces. You can access an Excel workbook and accompanying video below for combining a ...

Microsoft Excel uses double quotation marks to signify text within formulas. When it sees these marks, it uses the text and discards the quotes. Typing quotation marks directly into a cell is not ...

This is where the number-crunching fun starts. Learn the ins and outs of the logical formulas that represent the heart of Excel.

Trying to make all of the text or words fit properly in your Excel spreadsheet? Learn how to make text fit in Excel with our tutorial.

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.