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 Boolean logic: How to sift spreadsheet data using AND, OR, NOT, and XOR Excel logical functions make it easy to find the data you want, especially in huge spreadsheets.

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Whether or not you consider yourself an experienced user of Microsoft Excel, these 10 overlooked features may be able to increase your productivity.

Excel's main function is to interlink cells, through the use of formulas, so that the formula cell changes when data is inputted into linked cells.