If you have never used a tabular processor for creating documents, we advise you to read our Excel (Excel) Guide for Dummies.

After that, you can create your first tabular sheet with tables, graphs, mathematical formulas and formatting.

Detailed information on basic functions and capabilities of the MS Excel tabular processor. Description of the main elements of the document and instructions for working with them in our material.

Work with cells. Filling and formatting

Before proceeding with specific actions, you need to deal with the basic element of any document in Excel. The excel file consists of one or more sheets separated into small cells.

The cell is the basic component of any exhale report, table or graphics. Each cell contains one information block. It may be a number, date, money amount, unit of measurement or other data format.

To fill the cell, just click on it by the pointer and enter necessary information. To edit a previously filled cell, click on it. double click Mouse.

Fig. 1 - Example of filling the cells

Each cell on the sheet has its own unique address. Thus, it can be calculated or other operations. When you press the cell at the top of the window, a field will appear with its address, title and formula (if the cell is learning in any calculations).

Choose the cell "Share of Shares". The address of its location is A3. This information is specified in the properties panel that opens. We can also see the contents. There is no formula for this cell, so they are not shown.

More cell properties and functions that can be used with respect to it are available in the context menu. Click on the cell with the right key of the manipulator. The menu will open, with which you can format the cell, analyze the contents, assign another value and other steps.

Fig. 2 - context menu Cells and its basic properties

Data sorting

Frequently, users face the task of sorting data on a sheet in Excel. This feature helps to quickly choose and view only the desired data from the entire table.

You have already filled with a table (how to create it will look further in the article). Imagine that you need to sort the data for January ascending. How would you do it? Banal reprinting table is an extra work, moreover, if it is volumetric, no one will do this.

For sorting to Excel, there is a specially designated function. The user is required only:

• Select a table or information block;
• Open the "Data" laying;
• Click on the "Sort" icon;

Fig. 3 - Tab "Data"

• In the window that opens, select a table column over which we will conduct actions (January).
• Next, the type of sorting (we carry out a grouping by value) and, finally, the order is ascending.
• Confirm the action by clicking on "OK".

Fig. 4 - Setting Sort Parameters

There will be automatic data sorting:

Fig. 5 - the result of sorting numbers in the "January" column

Similarly, it is possible to sort the color, font and other parameters.

Mathematical calculations

The main advantage of Excel is the ability to automatically carry out calculations in the process of filling the table. For example, we have two cells with values \u200b\u200b2 and 17. How to enter their result in the third cell, without making calculations yourself?

For this, you need to click on the third cell, which will be entered the final result of calculations. Then press the F (X) icon, as shown in the figure below. In the window that opens, select the action you want to apply. The amounts are the amount, the average value, and so on. A complete list of features and their names in the Excel editor can be found on the official website of Microsoft.

We need to find the amount of two cells, so click on the "sums".

Fig. 6 - Select the "amount" function

In the function arguments, there are two fields: "Number 1" and "Number 2". Select the first field and click on the cell with the number "2". Her address will be recorded in the argument string. Click on "Number 2" and click on the cell with the number "17". Then confirm the action and close the window. If you need to perform mathematical actions with three or large quantity Cells, just continue to enter the values \u200b\u200bof the arguments in the field "Number 3", "Number 4" and so on.

If in the future the value of the summable cells will change, their amount will be updated automatically.

Fig. 7 - the result of the calculation

Creating Tables

In Exeleian tables, you can store any data. Using a function fast settings and formatting, the editor is very easy to organize a personal budget control system, a list of expenses, digital data for reporting and so on.

Tables in Excel have an advantage over a similar option in Word and other office programs. Here you have the opportunity to create a table of any dimension. The data is filled easily. There is a feature panel to edit content. In addition, the finished table can be integrated into the DOCX file using the usual copy-insert function.

To create a table, follow the instructions:

• Open the Insert tab. On the left side of the options panel, select "Table". If you need to highlight any data, choose the item " Summary Table»;
• Use the mouse to highlight the place on the sheet, which will be assigned to the table. And you can enter the location of the data into the element creation window;
• Click OK to confirm the action.

Fig. 8 - Creating a standard table

To format appearance The resulting plate, open the contents of the designer and in the "Style" field click on the template you like. If you wish, you can create your own appearance with another color gamut and selection of cells.

Fig. 9 - formatting table

The result of filling the table of data:

Fig. 10 - Filled Table

For each cell cell, you can also configure the data type, formatting and display mode. The designer window accommodates all the necessary options for further configuration of the plate, based on your requirements.

Adding graphs / charts

To build a diagram or graphics, the presence of a ready plate is required, because graphic data will be based on the information taken from separate string or cells.

To create a diagram / graph, you need:

• Fully allocate table. If the graphic element needs to be created only to display these cells, highlight them only;
• Open the inserts tab;
• In the recommended chart field, select the icon that, in your opinion, the best way Visually describes the tabular information. In our case, this is a volumetric circular chart. Apply the pointer to the icon and select the appearance of the item;

Similarly, you can create point graphs, linear charts and diagrams of the dependence of the table elements. All received graphic elements can also be added to Word text documents.

In the table editor, Excel has many other functions, however, for initial work There will be enough techniques that are described in this article. In the process of creating a document, many users independently master more advanced options. This is due to a convenient and understandable interface. recent versions programs.

Thematic videos:

Excel 2013.- A program designed to create and edit spreadsheets In order to maintain various accounting. This program It is the most common analytical system and is equipped with upgraded chart creation tools. Microsoft provides all users with this program tools and technologies necessary for efficient work with business data. The new version of the program shows a lot of new. Now create and edit charts on a lot easier, you do not need to waste time and enter the name of the month, just enter the number of the month and the number, and Excel 2013 will write the name for you. Download free Microsoft. Office Excel for Windows 10 can be in one click.

Advantages and disadvantages of Excel

New design;
+ quick Start programs;
+ Autonomous windows for books;
+ New options for building charts;
+ Outlook function;
- unusual to use after the previous version;
- There are problems with synchronization.

Main features

• quick start of work;
• speed \u200b\u200bdata analysis;
• instant filling of the data column;
• creating the desired diagram;
• use of data filtering sections;
• standalone windows for books;
• use of a series of tables when analyzing data;
• the number of the displayed lines is expanded;
• new options for building diagrams.

*Attention! When downloading a standard installer, you will need a pre-installed archiver, it can be

Program Microsoft Excel. It is a powerful tabular processor for professionals and novice users. The software package Includes tools for creating and editing complex tables, constructing on the basis of these tables of all sorts of diagrams and schemes, automation of statistical or accounting calculations and a lot of other popular possibilities. After the article you can download Excel for free for Windows 10/8/7 in Russian and fully start using the program. Professionals will find in this programs all the functions they need, and beginner users will be able to start using without any difficulty basic capabilities Package and gradually study all the features of the software.

Microsoft Office Excel's Office is closely and competently integrated with the rest of the Microsoft office components and allows you to exchange data and diagrams with other documents created by the means of this office package. In the new versions, users have the opportunity to use not only animated graphic elements in their tables, but also visualize the results of the calculation of the table using various multimedia elements. From version to the version, the range of used mathematical functions is expanding, a huge template library is constantly increasing to create graphs or formulas.

Also new software versions are closely integrated with opportunities. cloud storage SkyDrive and allow you to upload and edit documents directly from this repository. It is worth noting that the application described is one of the most popular Microsoft products and this solution Used by the overwhelming majority of users working with large volumes of statistical data and requiring complex calculations. Those who work with a large number of tabular documents and on the basis of them builds various reports with all sorts of visualization, the advantages that this utility gives to taste.

This program is designed for Windows 7, 8, 10 and depending on the version operating system The user can use both the features of the interface oriented with the mouse when using stationary computerand evaluate the innovations of the use of the use program touch screens When working on tablets and smartphones. When loading the program, pay attention to the discharge of your operating system (x32 or x64) and download the installer you want the version. Depending on the user's preferences, the interface language in Excele can be any, although of course the majority of domestic users will choose the Russian language menu and dialogs.

To new features of the latter microsoft versions Office Excel is the simplicity of the start of using a package that is optimized by a speed analysis of data, practically instant filling of columns or rows with data and constructing the corresponding chart, the presence of sections for filtering data, an enlarged number of lines displayed, new standalone windows for books. Thus, downloading and installing new version Excel programs, the user will always have a different working tool, through which you can quickly process the available information and obtain results in the most convenient representation.

Microsoft Excel is convenient for tableware and the work of calculations. The workspace is a variety of cells that can be filled with data. Subsequently - format, use to build graphs, diagrams, summary reports.

Working in Excel with tables for novice users may at first glance seem challenging. It differs significantly from the principles of building tables in Word. But let's start with small: with the creation and formatting of the table. And at the end of the article you will understand that the best tool for creating tables than Excel will not come up with.

How to create a table in Excel for dummies

Working with tables in Excel for dummies does not tolerate hurry. You can create a table different ways And for specific purposes, each method has its advantages. Therefore, first visually assess the situation.

Look carefully on the working sheet of the tabular processor:

This is a variety of cells in columns and lines. In fact, the table. Columns are indicated by Latin letters. Rows are numbers. If you bring this sheet to print, we get a clean page. Without any borders.

First, let's learn how to work with cells, rows and columns.



How to highlight columns and string

To highlight the entire column, click on its name (Latin letter) with the left mouse button.

To highlight the string - by the name of the line (according to the figure).

To highlight a few columns or rows, click the left mouse button by name, keep and drag.

To highlight the column using hot keys, we put the cursor to any cell of the desired column - press Ctrl + space. To highlight the string - Shift + space.

How to change the boundaries of the cells

If the information when filling out the table does not fit, you need to change the boundaries of the cells:

To change the width of the columns and the height of the rows, in a certain range, we highlight the area, increase the 1 column / string (manually moving) - the size of all selected columns and rows will automatically change.

Note. To return the previous size, you can press the "Cancel" button or a combination of Ctrl + Z hotkeys. But it works when you do right away. Later - will not help.

To return the strings to the source boundaries, open the tool menu: "Home" - "Format" and choose "Row height"

For columns, this method is not relevant. Click "Format" - "Default Width". I remember this figure. We highlight any cell in the column, the boundaries of which you need to "return". Again "Format" - "Column Width" - We introduce specified program The indicator (as a rule is 8.43 - the number of Calibri font characters with a size of 11 points). OK.

How to insert a column or string

We highlight the column / string to the right / below the place where you need to insert a new range. That is, the column will appear to the left of the selected cell. And the string is higher.

Press the right mouse button - select in the drop-down menu "Paste" (or press the combination of hot keys Ctrl + Shift + "\u003d").

We celebrate the "column" and click OK.

Council. To quickly insert the column, you need to highlight the column in the desired place and press Ctrl + Shift + "\u003d".

All these skills will be useful when drawing up a table in excel program. We will have to expand borders, add strings / columns during operation.

Step-by-step creating table with formulas

Now when printing the boundaries of columns and lines will be visible.

Using the "Font" menu, you can format data excel tablesas in Word program.

Change, for example, the font size, make the cap "Fat". You can set the text in the center, assign transfer, etc.

How to create a table in Excel: Step-by-step instructions

The simplest way to create tables is already known. But Excel has a more convenient option (in terms of subsequent formatting, data working).

Let's make a "smart" (dynamic) table:

Note. You can go on another path - first allocate the range of cells, and then click the "Table" button.

Now make the necessary data to the finished framework. If an additional column is required, we put the cursor to the cell intended for the name. Enter the name and press the input. The range will automatically expand.

If you need to increase the number of rows, engage in the lower right corner for the autocill marker and stretch down.

How to work with a table in Excel

With the release of new versions of the program, work in Excel with the tables became more interesting and dynamic. When a smart table is formed on a sheet, the "Work with Tables" tool becomes available - "Designer".

Here we can give a name table, resize.

Different styles are available, the ability to convert a table to a regular range or a summary report.

Opportunities for dynamic spreadsheet MS Excel huge. Let's start with the elementary data entry skills and autofills:

If you click on the arrow to the right of each subtitle of the cap, then we will receive access to additional tools to work with the data of the table.

Sometimes the user has to work with huge tables. To see the results, you need to scroll not one thousand lines. Delete lines - not an option (data will be subsequently needed). But you can hide. For this purpose, use numeric filters (picture above). Clean the ticks opposite those values \u200b\u200bthat should be hidden.

Excel Word Microsoft Office Tutorial

Russian language.
Free version.
Designed specifically for free use.
Support for the possibilities of programs 2003, 2007, 2010 edition.

MS Excel (pronounced Excel) - convenient program To create and edit spreadsheets. It is used to compile reports of various complexity, data collection and simplify calculations using the specified formulas. In free access, the program comes exclusively in the demonstration mode, which lasts 30 days. To obtain a full-fledged version without restrictions on the functionality, you will have to buy MS Excel from Microsoft. Nevertheless, we give you free alternative optionAvailable for download. There is always a choice!

You have a unique opportunity to download Excel for free. Free version. Working functionality! The interface is practically no different from the original. The program will easily replace version 2003, 2007 and 2010.

Program Microsoft Excel. - This is an excellent assistant for reporting, drawing up graphics and data systematization.

Help for working with Excel program

You can find more information in the tutorial.
Here we will answer the most frequently asked questions.

How to create tables?
1) Click on the first cell on the very first cell and do not let go of the key.
2) Then enter the mouse to the side so that the fields of the table being created are stretched.
3) After the table sizes become satisfactory, release the mouse key.


4) Look at the drawing below. It is shown to create borders.

How to ask formulas?

To set the formula you need to highlight needed cells and press the function button (see Figure).
There are all the necessary formulas.

How to combine cells?

1) Highlight the cells you want to combine.
2) Right-click.
3) Select "Cell Format".
4) Next click on the Alignment tab.
5) Check the box next to the "combining cells".

Download more information in the textbook.

To work with this program you need to download Excel for free. Analogue supports all necessary operations. Russian version. Small size and system requirements. Free option Excel is available for each user without any restrictions! You can download it right from our site.