As a result of mastering the materials of this chapter, students must:


- general requirements for processing table documents;

- data types processed by spreadsheets;

- methods of addressing in the MS Excel 2010 spreadsheet environment;

- tools for statistical analysis of economic information;

- technologies for solving optimization and financial problems;

- the basic principles of working with arrays of data;

- built-in functions in the MS Excel 2010 spreadsheet environment and methods for applying them to calculations;

- the principles of the data analysis tools ("Selection parameter," "Finding solutions");

- the advantages of the MS Office Fluent user interface and the purpose of the Backstage function;

be able to

- on the basis of standard methods and the current legal framework to calculate economic and socio-economic indicators that characterize the activities of economic entities

- to collect, analyze and process the data needed to solve the set economic problems;

- perform arithmetic operations with arrays of data;

- solve systems of linear and nonlinear equations;

- solve the problems of economic planning for given resources;

- simulate and explore functions;

- to perform numerical integration and differentiation, apply the theory of numerical integration in economic calculations;

- choose tools for processing economic data in accordance with the task, analyze the results of calculations and justify the findings;


- information technology work in the spreadsheet environment MS Excel 2010;

- computing skills when using cell ranges;

- the skills of correct interpretation in the electronic table of financial and economic problems;

- tools and methods for solving statistical analysis problems in the MS Excel 2010 spreadsheet environment;

- tools and methods for solving financial, economic and optimization tasks in the MS Excel 2010 spreadsheet environment.

Making spreadsheet documents

The most common form of presentation of economic and financial documents is tabular. Such documents, as a rule, include the general, design and subject parts. The general part contains the title of the document and a list of common information on the composition and significance of the details. The design part of the document contains information about who prepared the document. If it is an electronic document, then an electronic digital signature may be present in the design part, which will give legal effect to the document. The subject area contains the values ​​of the economic indicators that characterize the document.

The table document is based on the notion table - a set composed of several columns (columns) that have separate headings and are separated from each other by longitudinal rulers. The data is arranged in columns and rows in such a way that each individual indicator is a part of both the graph and the rows.

The concepts spreadsheets and table processor appeared in the early 1980s. A table processor is a computer program that supports the presentation of data in the form of spreadsheets consisting of rows and graphs at the intersection of which the cells are located. The main property of spreadsheets is instantaneous recounting of formulas when changing the values ​​of their operands.

They have undergone a number of changes over the years of the existence of table processors, and to date one of the most popular applications in the world is the MS Excel spreadsheet that is part of MS Office.

MS Excel is a handy tool for automating economic and financial computing through the following elements:

• Formulas and functions built into the table processor;

• Tools for plotting;

• Data processing facilities in lists or Excel databases;

• Means of solving optimization problems;

• means of statistical data processing;

• The means of analysis and forecasting for making more informed business decisions.

Proceeding from this, we can conclude that MS Excel is not only a means of automating calculations, but also a tool for modeling various situations.

Also We Can Offer!

Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)