Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how.

You can subtract numbers in Microsoft Excel in a few different ways, depending on your data and formatting.

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number.

This is because SEQUENCE is a dynamic array function that produces a spilled array, and Excel tables aren't compatible with results generated in this way.