"Russian Academy of National Economy and Public Administration under the President of the

Russian Federation"

"Faculty of Economic and Social Sciences"

Report
In The Discipline "Digital Technologies In Management"
On The Topic: "Electronic online tables in business."

The work of a student Kartashova Victoria Igorevna

Scientific supervisor Dmitry Vladimirovich Ilyin

Moscow.
2022.
Table of contents

Introduction..............................................................................................................3

1. What are spreadsheets.......................................................................................4

1.1 History of development.................................................................................4

1.2. Classification of spreadsheets......................................................................5

1.2. Basic table processors...................................................................................6

2. Google Online Spreadsheets for Business........................................................9

2.1. Google Tables features.................................................................................9

2.2 Using Google Tables in Business................................................................10

2.3 The main advantages of Google Sheets:.....................................................10

Bibliographic list:
1. Information systems and technologies in economics and management. Economic
information systems : textbook / E. V. Akimova, D. A. Akimov, E. V. Katuntsov,
A. B. Makhovikov. — Saratov : University Education, 2016. — 172 p. — ISBN
2227-8397.
2. https://www.britannica.com/technology/word-processor
3. https://smekni.com/a/114729/sovremennye-tekstovye-protsessory-i-ikh-
vozmozhnosti/
4. E. V. Mikheeva, O. I. Titova.. Computer Science : textbook for sred. Prof.
education. 2007

2
Introduction

Nowadays, tabular forms of documents are very common, but let's not forget that they
have been such for far from the first year in a row, mostly because of their convenience.
While people were developing technologies, of course, tabular forms of data also
advanced in numerous fields of human activity. As mentioned earlier, first of all it became such
because of its convenience and ease of use, both in two-dimensional planes and in three-
dimensional spaces. It is so simple that it is similar to the game "sea battle" in use. You specify
the cell, its coordinates and carry out any work with the data of the specified cell. Thus, it is
possible to build any database, use programming languages or coding and encryption. 

3
1. What are spreadsheets

A spreadsheet is a computer program that can be used to work with data presented in the
form of two-dimensional arrays that simulate paper tables. Some programs can organize data
into "sheets", thus allowing you to work with the third dimension.
Table processors are a set of programs for managing a spreadsheet.

1.1 History of development

For the first time, the idea of creating spreadsheets as such appeared in the late 1960s by
two North American programmers Rene Pardo and Remy Landau. They developed, registered
and patented the LANPAR software product, namely LANguage for Programming Arrays at
Random. People used this software to carry out budget calculations in the world's largest
telecommunications companies.
Years later, in 1979, two Harvard University students in the USA with Dan Bricklin and
Bob Frankston created a program that became one of the most successful programs and
promoted Apple II computers on the IT market. This program was VisCalc.
The next technological stage in the development of spreadsheets began in 1982, when
software tools such as Lotus 1,2 and 3 appeared. This program became a new table processor,
which included the ability to work with databases. This program was a huge commercial success,
and was also able to greatly promote IBM computers.
Microsoft has played a special role in the promotion of spreadsheets. She launched the
well-known EXCEL on the market. Undoubtedly, this product is still a leader in its field, both in
terms of functionality and distribution in the world.
Undoubtedly, the development of technology continues to this day. At the moment,
communication systems are being upgraded, new mobile devices with various operating systems
are appearing. This brought to the fore the use and improvement of spreadsheets that would be as
easy to use as possible and would be available anywhere. At the moment, the market leader is
Google with its online tables.

4
1.2. Classification of spreadsheets

Spreadsheets

By the nature of the By the way information is According to the structure of

content displayed the organization of information

Documentaries Local Multidimensional

Distributed
Factographic Two - dimensional

 Documentary tables contain information in a free format, be it text, numbers, and so on;
 Factographic tables contain brief information in a strictly defined format;
 Local tables are processed on a local APM with any operating system with the ability to
transfer to another APM of the same type (offline tables);
 Distributed tables are generated and processed on any network APM (online tables);
 Multidimensional tables have a multidimensional organization in the form of sheets;
 Two-dimensional tables have a two-dimensional organization.

Table Processor Objects

Object Object Properties
Workbook Name, number of sheets
Sheet Name, number of objects placed and their
type, availability of protection
Spreadsheet Total number of rows and columns containing
data
Column Name, width, number of filled cells
Line Number, height, number of filled cells
Cell Address, Name, Content, Data type, Data

5
display format, Note, Borders, Fill
Cell range Address, number of cells
Chart Type, name, chart area size, color scheme

The systematization of spreadsheets can be more detailed, but for their use in business,
such a structure is more than enough.

1.2. Basic table processors

Quattro Pro, spreadsheets of the Master application package

Quattro Pro is an office program that is essentially a spreadsheet editor. At one time it was
developed by Borland, and some time later it was sold to Novell (in 1993) and two years later it
was bought by Corel Corporation, now it is part of the Corel WordPerfect Office suite.

Interface

Gnumeric is an open source spreadsheet program.

Gnumeric is a set of office applications with integration parts. It is part of GNOME Office. In
terms of functionality, it resembles Microsoft Excel, but at the same time it has many advantages
over it. Among these advantages are new features and no fees for using this program. Moreover,

6
experts and ordinary users have said many times that thanks to this program it is possible to get
more accurate calculations.

Interface.

KCells is a free table processor, included in the KOffice and KDE projects.

KCell is a simple table processor with a standard set of functions. It has the function of
supporting
KCell, ODS, Gnumeric, TeX, CSV and TXT formats.

Interface.

Lotus 1-2-3 is a table processor developed by Lotus Software. The program is called "1-2-
3" because it consists of three elements: tables, graphs and basic database functionality.

7
Lotus 1-2-3 is much easier to work with than VisiCalc, and also has various possibilities for
creating diagrams, diagrams and databases, but gradually the program was displaced from the
market by the Microsoft Excel application.
Interface.

Microsoft Excel is a spreadsheet program created by Microsoft Corporation for Microsoft

Windows, Windows NT and Mac OS, as well as Android, iOS and Windows Phone.

Microsoft Excel is one of the most popular and most common spreadsheet management tools.
Allows you to solve a whole range of tasks:
• Perform various calculations;
• Mathematical modeling;
• Use spreadsheets as a database.
Interface.

8
2. Google Online Spreadsheets for Business

Google Spreadsheets have been developed so that they can be used by organizations
whose advantage is the flexibility of their work processes, as well as to be confident in the safety
of their data. Thanks to Google tables and artificial intelligence technology, it is possible to
obtain accurate data for making various decisions in any field of human activity. Thanks to the
cloud, you can work as a team from any device and anywhere. And also, data from any sources
can be processed in Tables, using compatibility with third-party systems, such as Microsoft
Office.

2.1. Google Tables features.

• Editing tables;
• Creating your own tables;
• Creation of various filters;
• Ability to work offline;
• Ability to work in a group on a single file in real time;
• View actions in file versions;
• Blocking changes on the sheet;
• Receive notifications of comments and changes during your absence;
• Automatic saving in the cloud (on Google Drive);
• Ability to convert files from Excel and back;
• Adding various diagrams and pictures;
• Import tables in various formats: XLS, CSV, TXT.

Interface.

9
1. Google Tables logo. By clicking on it, you can go to the list of all the user's tables.
2. The name of the open document.
3. The panel for working with the table.
4. Menu.
5. Show/hide comments to the table.
6. Table access settings.
7. The user's logo.
8. A string of formulas.
9. Columns.
10. Lines.
11. Working area.
12. Sheets of the current table.
13. Status bar.
14. Data analysis panel.

2.2 Using Google Tables in Business

Most of the features that are not available in MS EXCEL are available in the Google Sheets
service. It is one of the many tools called Google Docs.

2.3 The main advantages of Google Sheets:

1. Great opportunities for importing and exporting data from various files, books, databases, and
so on;
2. Automatic saving of files created by you in the cloud, so you don't have to worry about the
safety of files and documents;
3. You can work with any files in almost any resolution, including pdf and docs;
4. Automatic visualization and analysis of the information you have entered using various tables
and filters, you just need to select the desired cells;
5. You can edit and save documents without an Internet connection;
6. You can make edits and comments online if you give users access to the document;
7. A huge number of additional editing tools;
8. You can create questionnaires and questionnaires, and the data will be automatically entered
into the table.
10
Undoubtedly, Google Tables have a number of advantages over all offline tabular tools, here are
some of them:

1. The ability to work in a team

You can invite the right employees to hold joint discussions and work online, this can be done by
simply opening the chat directly on the document page; you can receive real-time updates of the
document and notifications about the changes that have been created during your absence. All
changes are saved automatically online and offline.

2. Working with EXEL files

Google spreadsheets make it easy to convert any Microsoft files, as well as use the same
keyboard shortcuts as in EXEL, which is very convenient for ordinary users.

3. Research data from various sources, including BigQuery

In Google Sheets, you can find all the necessary tools to perform data analysis or visualization.
With the help of additional APIs and connectors, you can process data from any source, upload
files in all provided formats, including CSV and Excel. And using attached tables, you can
analyze datasets from BigQuery directly in Tables, while you do not need SQL knowledge.

4. The possibility of making individual decisions.

You can optimize workflows, create personal applications based on Tables using AppSheet,
while writing code is not required, as well as create your own functions, menu items and macros.

11
Conclusion

Studying the possibilities of using spreadsheets, I would like to say that nowadays the most
successful is the one who gives users the opportunity to use the largest number of management
tools. Google Tables are just the most striking example. Now it is used by almost all progressive
companies, ordinary users and employees. Using Google Tables will allow companies to expand
their abilities and potential, make working with online tables as comfortable and convenient as
possible by using all its advantages. Economic and Social Sciences"

12