Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

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

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.