Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

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.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.