The package of Microsoft Office is a suite of desktop applications among the most comprehensive in circulation. In particular, Microsoft Excel is a program dedicated to the production of spreadsheets . For ordinary users , this program has always been a mystery, it is often used in the field of accounting and solving equations. In fact many do not know that this tool, sometimes underestimated, can be much more useful and powerful than you can imagine. Especially with the passing years, the tools have been refined and made ​​more functional. This guide aims precisely to explain in a simple and fast, like solving a system of linear equations with Excel.

Open therefore Micosoft Excel from Microsoft Office package . The program is presented as a spreadsheet consisting of empty cells. Now enter the coefficients in a matrix "nx n". From the right of the equal sign, enter the values ​​in column "N". Be careful because this column is not to touch the n-by-n matrix created previously.

 

To be clear, we can give an example. Let's say you have three linear equations with three coefficients each. These equations are x-z + 4y = 8;9x + 15y-z = 14; 6x + y-2z = 1. Then cell A1 must contain 1, cell B1 must contain 4 and the cell C1 must contain -1. The cell A2 must contain 9, cell B2 should contain 15 and the cell C2 must contain -1. The cell A3 must contain 6 cell B3 must contain one and the cell C3 must contain 1. Then you insert the coefficient to the right of the equal sign in the column N. It will be then the column 3, which contains 8 respectively in cell E1, E2 and E3 14 1.