Cookies on the Business Insider India website

Business Insider India has updated its Privacy and Cookie policy. We use cookies to ensure that we give you the better experience on our website. If you continue without changing your settings, we\'ll assume that you are happy to receive all cookies on the Business Insider India website. However, you can change your cookie setting at any time by clicking on our Cookie Policy at any time. You can also see our Privacy Policy.

This Advanced Excel Trick Allows You To Calculate Complicated Matrix Functions

Walter Hickey,Daniel GoodmanSep 5, 2013, 20:11 IST

Your browser doesn't support HTML5 video.

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:

kalturavideoplaceholder

Produced by Daniel Goodman