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

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.

Cutting and pasting ranges of cells is a common operation in Excel, and Microsoft's Visual Basic offers streamlined functionality to easily automate the process.

Furthermore, you can create basic data structures, such as queues, within Excel using Visual Basic macros.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

If you need a visual clue to hype a worksheet, use Excel's Conditional Formatting feature to help values stand out.

Kalyan S. Pasupathy, Alexandra Medina-Borja, Integrating Excel, Access, and Visual Basic to Deploy Performance Measurement and Evaluation at the American Red Cross, Interfaces, Vol. 38, No. 4, The Use ...