Excel spreadsheet: advanced level ТД1.10.26-ТД1.10.26_1 Shapovalova Olena PhD

Discipline "MS Excel spreadsheet: advanced level" is a technological discipline of free choice in the specialties: 051 "Economics", 071 "Accounting and Taxation", 072 "Finance, Banking and Taxation", 073 "Management", 076 "Entrepreneurship, trade and exchange activities ", 281" Public administration and administration ".

Topicality. In the work of modern enterprises the possibility of using existing information and the possibility of obtaining qualitatively new information is becoming increasingly important. The ability of employees to extract the necessary data and the ability to present them in the form of various reports is directly related to the results that can be used by management for ongoing analysis and further decision-making to improve the company. 

MS Excel spreadsheet is a powerful tool for efficient solutions in cases where you need to process large amounts of information related to searching, filtering, sorting and obtaining final values ​​using various functions. 

The purpose of teaching the discipline is to form practical skills in the use of MS Excel software as a tool for creating spreadsheets, complex diagrams and forecasting functions, which will allow you to freely operate large amounts of data, as well as reflect the dynamics of production and marketing processes 

The object of teaching the discipline is the technology of the desktop MS Excel, as a tool for solving problems of modern economics. 

The subject of teaching the discipline is the process of solving problems of modern economics.

The results of the study of this discipline are: the use of functions for comparison and substitution of data; .fast and visual creation of reports of summary tables and charts to summarize and analyze data by years, quarters, months, both in absolute and relative terms; performing calculations using different conditions and allocating the required data by conditional formatting; protection of cells, worksheets and books, as well as sorting and filtering data by value and color; ability to control data entry, calculate intermediate and total results in tables

Competences: 

- ability to process large flows of financial and economic information and generate reports by different categories and sections; 

- ability to maintain the current level of professional skills and increase their value in the labor market.