Microsoft Excel

Xcel

Nowadays, doing business is much more comfortable and pleasant than it was a few years before. This can be explained by the fast development of scientific and technical progress. It has become especially simple to keep records thanks to the office programs, which allow even usual users to create their own formulas and simplify daily calculations. One of such programs is Microsoft Excel, which is included in the Microsoft Office software package. Microsoft Excel represents especially powerful instrument to create electronic tables, manage them and conveniently update. To create such updateable table it is necessary to use special instrument, which is called function. Functions can be created by typing symbol “=” in any cell and then by inputting the needed mathematical expression, using the corresponding cells. For example, by typing the number 2 in the cell A1 and, then, number 5 in the cell A2, we can set the necessary conditions for our problem. Let us assume we need to choose the maximum from value of our two numbers. This can be easily done by using function MAX. Just type the equality symbol in front of any cell and then choose the formula in the list that is provided by the master of functions. If we choose MAX, we will be asked to specify the desired interval, which is represented by A1 and A2 cells in our case. The result will be presented in the cell which we have chosen for the displaying of the computing results. This feature is very useful when we deal with the huge lists of numbers. For example, overall production costs. We can also use some other useful tools to optimize the accounting of our company. Let us say, we need to highlight the negative balances on the accounts of our organization. This can be easily done by the function of conditional formatting. Just repeat the above steps, while choosing the needed formula and you will get an impressive result, showing, for example, all the accounts with a negative balance. This allows us to...