Video: Get started with Excel for Android tablets. Video: Get Started with Excel for Android Tablets Smartphone Spreadsheet Program

Spreadsheet processor to work with spreadsheets in your phone.

Are you comfortable using the calculator built into your mobile phone? In principle, quite, as long as it concerns all sorts of small calculations.

But it often happens that you need more than just a calculator when you need to associate calculations with a specific database, for example. On the computer, there are programs for this, which are called spreadsheets. But few people know that such programs are implemented in JAVA, which allows you to have a fairly powerful spreadsheet processor in your mobile phone!

Today I will tell you about a very good spreadsheet editor for mobile phone — sheet. With it, you can create price lists with auto-calculation formulas for several categories or, for example, dynamic product databases.

List of Sheet features

• creation and editing of spreadsheets (own format);
• saving tables inside the program without creating external file;
• hand-written creation of calculation formulas;
• highlighting cells with color;
• manual resizing of cells;
• functions of copying and pasting cell data;
• control of text alignment in cells.

Everything is fine, but there is one thing, but a big one, BUT - Sheet cannot work with tables created in other programs, since it saves all the data inside itself, without creating an external file :(. Therefore, you will have to pay for the convenience of using a finished table with time, spent on its creation.

So, let's install the program on our phone. For this, as we know, there are several ways: installation via the Internet and with local computer(read more).

Sheet interface

Installed? Let's run the program and try to work with it.

After launch, a ready-made spreadsheet with empty cells will open in front of us.

Under the table you will see two buttons "Menu" and "Cancel" (their location depends on the phone model, for example, on Samsung J210, which was tested, the "Menu" was on the left, and the "Cancel" button was on the right). Cell navigation is carried out using the joystick. The central click of the joystick on a cell brings up a window with information about its contents.

Working with the program

Now that we have figured out the navigation through the main program window, let's try to create a small table. As you probably already guessed, we should start by pressing the "Menu" button.

Here we see five sections of the main menu. The first one is responsible for editing the data in a particular cell, the second one is for the size, color and other external attributes of the cell itself, the third one allows you to automatically recalculate all the formulas on the sheet, the fourth one opens the menu for saving and opening files, created tables, and the fifth one opens the help for program.

In order to enter data into our first cell, select it and select the “Cell Data” item from the menu.

In the new menu you will see a few more items. The first allows you to edit the contents of the cell, the second - to clear all the contents, the third - to copy, and the fourth, respectively, to paste data. The last point brings us back to our main sheet of the table. Select the first item "Edit Cell":

In the window that opens, enter desired value(You can also enter text, see below) and select “Ok” in the menu to save it.

In the same way we enter certain value to the next cell (A2), for example, the number 6. And now, let's say we need to calculate the sum of our two numbers entered earlier. To do this, you need to create a formula. Formulas in the Sheet are created by pressing the "*" button on the phone's keyboard.

Since we entered data in cells A1 and A2, it would be logical to set the formula for cell A3. Select it and press "*". In the window that opens, write the formula for adding the two above cells:

Now the main thing is that you enter the names of the cells exactly in the English layout, otherwise you will get an error. If everything is done correctly, our table will look like this:

Now, no matter how you change the values ​​in cells A1 and A2, their sum will always be displayed in the third cell!

However, this can also be calculated on a calculator. Let's complicate our table by giving names to all the cells, as in a standard database. Let the first row be responsible for the number of pencils in the warehouse, the second for pens, and the third be "Total" :).

And everything would be fine, but some labels do not fit in a standard cell. So you need to change their size! To do this, in the main menu, select the second item - "Cell Format":

A new menu will open with four options. The first is the size of the cell, the second is its color, the third is the alignment of the data inside the cell, and the last is the output to the sheet with the table. We need the first point.

As soon as you activate it, you will be sent to the main screen, with the right and bottom border lines of the cell becoming dotted, and you can move them using the phone's navigation keys:

For ease of tracking necessary information I also advise you to alternate the colors of the rows of cells (for example, odd - black, even - white (I do not advise using gray)).

It is time to save our labors. To do this, select the fourth item in the main menu of the program - “File”:

Here again is a small menu in five sections. To save the table, select the third one - "Save":

In the window that opens, enter the name under which we want to save the table and click "Ok".

Now, if you want to open the created table in the future, you just need to go to the "File" menu and select the "Open" item. In the list that opens, find your table by name and run it:

conclusions

Sheet has another not very pleasant feature - a misunderstanding of the Cyrillic alphabet :(. Therefore, you will have to enter text data in English or in transliteration (as in our example). In all other respects, this is a very good program that will give you the opportunity to work with spreadsheets, without resorting to buying expensive smartphones that have a similar function!

P.S. Permission is granted to freely copy and quote this article, provided that the open active link on the source and preservation of the authorship of Ruslan Tertyshny.

P.P.S. If you want to install this program on your phone, but you are unable to transfer the downloaded files from your computer, you can use the following direct link. To download, enter the link address in your phone browser:

I am looking for a simple spreadsheet app on my android phone.

Desired features:

• Basic functions of spreadsheets, i.e. data entry in rows and columns, including properly formatted dates and times
• Simple formula e.g. addition, sums, averages
• Sort or filter columns
• Import and export data in a standard format such as CSV
• Works offline
• A lightweight application is preferred, i.e. one that does not require a large amount of memory
• For free

Answers

SeanPercy42

I tried four individual programs for my Android spreadsheets, but narrowed down my list to two. These two seem to offer the friendliest user interfaces and the most (free) options.

I definitely recommend installing both of them and trying them out to see which one works best for your individual needs. They both have everything you mentioned. I noticed that I can't create more than two "sheets" using WPS Office. An issue I didn't have with Google Sheets, so Sheets might be the winner in this category, but I suspect WPS will quickly add this option when it's mentioned.

I hope one of them works well for you!

Excel application for android tablets very similar to the classic Excel program. However, if you're used to using a mouse and keyboard, you might find it helpful to be familiar with some of the differences. This video provides tips to help you get started quickly.

Highlights of this video

Video transcript

[Intro Music]

Learn how to quickly get started with Excel on your Android tablet.

First, let's learn how to enter text. First I touch the cell, then the formula bar and start typing. When I'm done typing, I click on the green checkmark.

But it can also be done faster. I just double-tap the cell, type in the text, and click on the checkmark,

and if you need to enter text in a group of cells, you can simply press Enter to move down one line.

When I'm done typing, I press the back button to hide the keyboard.

This button looks like this on my tablet, but it might look different on your device.

Another typing tip. Let's say we need to fix a typo.

I double-tap the cell, touch and hold the slider, and drag to Right place and then fix the error.

Now I will introduce some formulas. I want to sum the values ​​in this column... Excel suggests a range of cells to sum, and it works for me, so I just tap the checkbox.

However, suppose I want to place the result of an addition to the right of the table. Excel again offers a range of cells for summing, but in this case it is not suitable.

So I just drag the markers to set the desired range.

Now let's see how formatting is configured. The most commonly used formatting options are located on this tab, and one of the most useful is cell format.

Now we will set the format in rubles by selecting the item Monetary.

If we need something else, we can touch this arrow and open additional options.

You can continue learning on your own by simply moving from tab to tab and exploring various options. additional information For Office for Android tablets, visit aka.ms/OfficeAndroidTabletVideos.

Google Sheets (Google Spreadsheets) is a branded Android application from the search giant that will create a comfortable work with tables. The program includes tools for organizing created and edited documents. The main advantage of Google Sheets is that it has support for the XLS format created in Microsoft Excel.

Application for full-fledged work with spreadsheets on Android devices. Using this application you can create new tables and edit existing ones completely free of charge and without restrictions, you can format cells, view graphs, use the search function, insert formulas, and save tables in Microsoft Excel format. You don't need an internet connection to use Google Sheets. All changes made are saved automatically, so you can be sure that no important document will be lost. If there is an Internet connection, then you can open access to view and edit tables to other users. This way you can work together on the same project.

Advantage of Google Sheets on Android:

• create tables, edit;
• work even without the Internet;
• you can share spreadsheets and work simultaneously with colleagues;
• sorting and entering data, formatting cells, inserting formulas, viewing graphs;
• replace and search function;
• all changes are saved automatically, so you don't have to worry about the work done.

Work without restrictions with data arrays and do not worry about the work done, as the program saves all changes in automatic mode.

Download Google Sheets for Android without registration and SMS via the direct link below.

Google Spreadsheets is a program specially designed for users of electrical devices controlled by operating Android systems. This software gives you the opportunity to work with tabular datasets and do it simply and conveniently. Tables are different Google programs more convenient and intuitive interface, stability and better performance.

The application is able to work with files created with using Microsoft Excel, which greatly expands the scope of its application. The program features allow you to edit previously created documents and create recent documents, contact your colleagues and use this method to work with a single data file with the entire community, format a cell, sort data, insert graphics into cells, and much more.

The program will be a necessary addition to the arsenal of owners Android devices, often using data presented in the form of tables, who want to take into account the household budget and other categories of users. It does not take up much memory in the phone's memory, it is easy to manage, it constantly works.

How to create a document in the application? - Go to Google drive, click the New button, select Table from the menu. How do I share a document? - Open Google Drive, click the AI ​​icon, select the "Add users" option, set up email addresses and declare the necessary rights (comments, changes, reads).

Work without limits with data arrays, do it even without a network connection, and most importantly - do not worry about the work done. The program saves all your configurations automatically!

Screenshots of Google Sheets for Android