No, today we are not talking about a movie review or parallel worlds, but about a particularly interesting calculation method in Excel. A matrix is an arrangement of numerical values in tabular form. We'll show you what exciting things you can do with it in Excel. With matrix formulas you can perform several calculations at once. You can process a whole group of cells at the same time - if you want, even across several worksheets. Sounds complicated, but it's amazingly simple! Instead of you creating several different individual formulas, you use a single matrix formula for your calculations. Once used, you'll never want to do without it again!

Published on: 05.04.2022

Excel 2016

Array Operations  
We will show you in this video how to work with array formulas in Excel. Array formulas can be used to perform various calculations at once. (7 Min.)



Excel 2013

Array Operations  
We will show you in this video how to work with array formulas in Excel. Array formulas can be used to perform various calculations at once. (7 Min.)



Excel 2010

Array Operations  
We will show you in this video how to work with array formulas in Excel. Array formulas can be used to perform various calculations at once. (7 Min.)



Excel 2007

Array Operations  
We will show you in this video how to work with array formulas in Excel. Array formulas can be used to perform various calculations at once. (7 Min.)