This Advanced Excel Trick Allows You To Calculate Complicated Matrix Functions

One of the coolest tricks in Microsoft Excel is the ability to use it to calculate complicated matrix functions.

While this isn’t a totally mainstream use, if you’ve ever needed to work with matrices in Excel you need to know a couple things.

First and foremost, knowing the importance of Command+Enter (or Control+Enter) has multiple functionalities when it comes to other, more mainstream uses.

Check out how to work with matrices in Excel:

Produced by Daniel Goodman

Business Insider Emails & Alerts

Site highlights each day to your inbox.

Follow Business Insider Australia on Facebook, Twitter, LinkedIn, and Instagram.