How to merge and unmerge cells in Microsoft Excel in 4 ways, to clean up your data and formatting

You can merge cells in Excel by using a simple drop-down menu, which will let you merge cells in a variety of ways. Here's ...

How to add a column in Microsoft Excel in 2 different ways

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.
MUO on MSN

Once you understand SCAN in Excel, you’ll never build formulas the same way

The simplest way to think about SCAN is that it applies a custom calculation to each element in a range/array and returns every intermediate result it produces along the way. If that sounds abstract, ...
MUO on MSN

They don't teach these mean Excel functions in school but they're super handy

The GEOMEAN and HARMEAN are advanced statistical functions that typically require a deeper understanding of mathematics. This is probably why they aren't taught as often as the AVERAGE function.