Tables are an essential tool for the Excel user. How to make a table in Excel and automate this process , our article will answer.

Before creating a table in Excel, we suggest studying a few general rules:

  • The information is organized by columns and rows. Each line is assigned to one record.
  • The first row is reserved for the so-called "heading", where the column headings are written.
  • You need to adhere to the rule: one column - one data format (numeric, currency, text, etc.).
  • The table must contain the record identifier, i.e. the user assigns one column to line numbering.
  • Structured records should not contain empty columns and rows. Zero values ​​are allowed.

How to create a table in Excel manually

To organize the workflow, the user must know how to create a table in Excel. There are 2 methods: manual and automatic. Step-by-step instruction How to draw a table in Excel manually:

  1. Open the book and activate the desired sheet.
  2. Select the required cells.
  3. On the toolbar, find the "Borders" icon and the "All Borders" item.
  4. Indicate available information in the table.

Method II consists in manually drawing the grid of the table. In this case:

  1. Select the tool "Grid by the border of the picture" by clicking on the icon "Borders".
  2. While holding down the left mouse button (LMB), drag the pointer along the indicated lines, as a result of which a grid appears. The table is created while the LMB is pressed.

How to create a table in Excel automatically

Table area

Before creating a table in Excel, the user needs to determine what spacing of cells he needs:

  1. Select the required range.
  2. In MS Excel 2013-2019, on the "Home" tab, click on the "Format as Table" icon.
  3. When expanding the drop-down menu, select the style you like.

Table button on the Quick Access Toolbar

The toolbar contains an icon for creating a table object. To use the functionality of the table processor, the user uses the following algorithm:

  1. Activate the spacing of the cells required for the job.
  2. Go to the "Insert" menu.
  3. Find the "Tables" icon:
  • In MS Excel 2007 click on the icon. In the dialog box that appears, check or uncheck the radio button for the "Table with headers" item. Click OK.
  • In MS Excel 2016, click the icon and select the "Table" item. Specify a range of cells by selecting with a mouse or manually writing cell addresses. Click OK.

Note: to create an object, use the keyboard shortcut CTRL + T.

4. To change the name of the column, go to the formula bar or double-click on the object with the heading.

Cell range

Working with numerical information implies the use of functions that specify an interval (range of cells). Under the range, the reference literature defines a plurality of cells in a spreadsheet that collectively form a single rectangle (A1: C9).

The activated "Constructor" tab reveals a toolkit that facilitates the process of editing an object. To automate the work, the user sets the radio buttons on the "Title bar" and "Total line" tools. The last option allows you to carry out calculations according to the selected formula. To do this, the user expands the list by clicking on the arrow in the summary cell and selects a function.


Populating with data

Working with structured information is possible if the cells are filled with text, numerical and other information.

  • To fill out, you need to activate the cell and start entering information.
  • To edit a cell, double-click on it or activate the edited cell and press F2.
  • By expanding the arrows in the title bar of MS Excel structured information, you can filter the available information.
  • When choosing a formatting style for an MS Excel object, automatically select the interlaced selection option.
  • The "Design" tab (the "Properties" block) allows you to change the name of the table.
  • To increase the range of rows and columns with subsequent filling with information: activate the "Resize Table" button on the "Design" tab, new cells will automatically acquire the specified object format, or select the last cell of the table with a value before the final row and drag it down. The resulting row will remain unchanged. The calculation is carried out as the object is filled.

  • Headings should not contain number formats because they are converted to text when the table is created. If the formula contains as an argument a reference to a header cell where a number is expected, the function may not work.

Pivot table

The summary is used to summarize information and conduct analysis, does not cause difficulties in creation and design. To create a pivot table:

  1. Structure an object and provide information.
  2. Go to the "Insert" menu and select the icon: in MS Excel 2007 - "Pivot Table"; in MS Excel 2013-2019 - "Tables - Pivot table".
  3. When the "Create PivotTable" window appears, activate the range entry line by placing the cursor.
  4. Select a range and click OK.

Note: If the summary should be on the same sheet after creation, the user sets the radio button to the desired option.

5. When the sidebar appears to configure the object, move the categories to the required areas or turn on the switches ("check marks").


The generated summary automatically calculates the totals for each column.

Later versions of MS Excel suggest using the "Recommended Pivot Tables" option. A similar variation of information analysis is used in cases where it is impossible to correctly select fields for rows and columns.

  1. Select cells with entered information.
  2. When you click on the "Tables" icon, select "Recommended pivot tables".
  3. The spreadsheet processor automatically analyzes the information and suggests the best options for solving the problem.
  4. If you select a suitable item in the table and confirm with OK, get a summary table.

Out-of-the-box templates in Excel 2016

MS Excel 2016 spreadsheet processor at startup prompts you to choose the optimal template for creating a table. The office suite contains a limited number of templates. Additional samples can be downloaded by the user on the Internet.

To use templates:

  1. Choose the sample you like.
  2. Click "Create".
  3. Fill the created object in accordance with a well-thought-out structure.

Registration

The exterior of the object is an important parameter. Therefore, the user learns not only how to build a table in Excel, but also how to focus on a specific element.

Creating a header

Given a table drawn with the Borders tool. To create a header:

Select the first line by clicking LMB on the numeric designation of the line.

On the Home tab, find the Insert tool.

Activate the item "Insert rows to sheet".


After the appearance of an empty line, select an interval of cells according to the width of the table.

Click on the "Combine" icon and select the first item.


Set a title in the cell.

Changing the line height

Typically, the height of the title bar is larger than the original height. Adjusting the line height:

  • Press right click mouse (RMB) on the numerical designation of the line and activate the "Line height". In the window that appears, specify the size of the title bar and click OK.
  • Or move the cursor to the border between the first two lines. With the LMB held down, pull the lower border of the row down to a certain level.

Text alignment

If the user assumes the location of the text in the cell is different from the default, then he uses the icons "Alignment" relative to the horizontal and vertical, as well as the button "Orientation". Selecting items from the drop-down list will allow you to position the text vertically or diagonally.


Style change

Changing the font size, typeface and writing style is done manually. To do this, the user uses the tools of the "Font" block on the "Home" tab or calls the "Format Cells" dialog box via RMB.

The user can use the Styles icon. To do this, select a range of cells and apply the style you like.


How to insert a new row or column

To add rows, columns and cells:

  • select the row or column before which the object is inserted;
  • activate the "Insert" icon on the toolbar;
  • select a specific option.

Removing items

To delete objects on a MS Excel sheet, the user activates a similar button on the toolbar, after selecting a row, column, cell.


Fill cells

To set the background of a cell, row, or column:

  • highlight the range;
  • find the Fill Color icon on the toolbar;
  • choose the color you like.

  • call the "Format of cells" through the RMB;
  • go to the "Fill" tab;
  • choose color, fill methods, pattern and pattern color.

III way

  • click on the arrow in the "Font" block;
  • go to the "Fill" tab;
  • choose the style you like.

Item format

The toolbar contains the "Format" icon. The option helps to set the cell size, visibility, arrange sheets and protect the sheet.


Content format

The last item from the "Format" drop-down list on the Quick Access Toolbar allows you to set the data type or number formats, set the appearance parameters and object borders, set the background and protect the sheet.


Using formulas in tables

The spreadsheet is popular for its ability to use math, statistics, logic, and more. functions.

The user can get acquainted with the complete list and entered arguments by clicking on the link "Help on this function".


To set the formula:

  • activate the cell where the formula will be calculated;
  • open the "Formula Wizard";
  • write the formula yourself in the formula bar and press Enter;
  • apply and activate floating hints.

The toolbar contains the AutoSum icon, which automatically calculates the sum of the column. To use the tool:

  • highlight the range;
  • activate the pictogram.

Using graphics

To insert an image into a cell:

  1. Select a specific cell.
  2. Go to the menu "Insert - Illustrations - Pictures" or "Insert - Picture".
  3. Specify the path to the image.
  4. Confirm the selection by clicking on "Insert".

MS Excel toolkit will help the user to create and format the table manually and automatically.


You want to know how to make a table in Microsoft program Office Excel? In fact, this question cannot be answered unambiguously. Moreover, there are dozens, if not hundreds of answers to it - because the Excel spreadsheet editor has incredibly extensive functionality. According to statistics, an inexperienced user, of whom most of them, do not use about 90-95% of the program's capabilities.

A universal way to create a table in Excel

Surely many users by creating a table mean setting some kind of borders of elements, frames. Well, we have in store for you a universal method that works equally well not only on old versions of the program, but also on fresh ones. Well, to make a table, you must do the following:
As you understood from all of the above, this instruction is universal and will fit any version Excel programs... But even that's not all - you can always play around with the settings in the fifth paragraph to modify tables, borders, their color and many other settings. All in your hands.

Formatting a table

You probably remember that at the very beginning we mentioned a huge number of options for creating tables in Excel, right ?! We hasten to please you, in the end we have in store an extremely simple method of giving them a unique appearance. To do this, you will need to use the standard types of table formatting. So let's get started:


Well, now you know how to create tables in Excel, how to give them certain formatting and styles. I would like to add one more thing: do not forget to experiment, the program has many interesting functions!

In the first material Excel 2010 for beginners, we will get acquainted with the basics of this application and its interface, learn how to create spreadsheets, as well as enter, edit and format data in them.

Introduction

I think I will not be mistaken if I say that the most popular application included in the Microsoft Office package is the Word test editor (processor). However, there is another program that any office worker rarely does without. Microsoft Excel (Excel) refers to software products called spreadsheets. With the help of Excel, in a visual form, you can calculate and automate the calculations of almost anything, from a personal monthly budget to complex mathematical and economic-statistical calculations containing large amounts of data arrays.

One of key features spreadsheets is the ability to automatically recalculate the value of any desired cells when the content of one of them changes. To visualize the obtained data, based on groups of cells, you can create various types of charts, pivot tables and maps. At the same time, spreadsheets created in Excel can be inserted into other documents, as well as saved in a separate file for later use or editing.

It would be somewhat incorrect to call Excel simply a “spreadsheet”, since this program has enormous capabilities, and in terms of its functionality and range of tasks it can, perhaps, even surpass Word. That is why, within the framework of the series of materials "Excel for Beginners", we will get acquainted only with the key features of this program.

Now, after the end of the introductory part, it's time to get down to business. In the first part of the cycle, for better assimilation of the material, as an example, we will create a regular table that reflects personal budgetary expenses for six months like this:

But before starting to create it, let's first look at the basic elements of the interface and controls of Excel, as well as talk about some of the basic concepts of this program.

Interface and control

If you are already familiar with Word editor, then it will not be difficult to understand the Excel interface. After all, it is based on the same ribbon, but only with a different set of tabs, groups and commands. At the same time, in order to expand the work area, some groups of tabs are displayed only if necessary. You can also minimize the ribbon altogether by double-clicking on the active tab with the left mouse button or by pressing the Ctrl + F1 key combination. Returning it to the screen is done in the same way.

It is worth noting that in Excel for the same command, there can be several ways to call it at once: through the ribbon, from the context menu, or using a combination of hot keys. Knowledge and use of the latter can greatly speed up the work in the program.

The context menu is context sensitive, that is, its content depends on what the user is doing at the moment. The context menu is invoked by right-clicking on almost any object in MS Excel. This saves time because it displays the most frequently used commands for the selected object.

Despite such a variety of controls, the developers went further and provided users in Excel 2010 with the ability to make changes to the built-in tabs and even create their own with those groups and commands that are used most often. To do this, right-click on any tab and select the item Customizing the Ribbon.

In the window that opens, in the menu on the right, select the desired tab and click on the button Create a tab or To create a group, and in the left menu the desired command, then click the button Add... In the same window, you can rename existing tabs and delete them. To cancel erroneous actions, there is a button Reset, which returns the tab settings to their initial settings.

Also, the most frequently used commands can be added to Quick Access Toolbar located in the upper left corner of the program window.

This can be done by clicking on the button Customizing the Quick Access Toolbar, where it is enough to select the required command from the list, and if the required command is absent in it, click on the item Other commands.

Data entry and editing

Files created in Excel are called workbooks and have the extension "xls" or "xlsx". In turn, a workbook consists of several worksheets. Each worksheet is a separate spreadsheet that can be interconnected if necessary. The active workbook is the one you are currently working with, for example, into which you enter data.

After starting the application, a new book named "Book1" is automatically created. By default, a workbook consists of three worksheets named “Sheet1” to “Sheet3”.

The working area of ​​the Excel worksheet is divided into many rectangular cells. Horizontally merged cells are rows, and vertically merged columns. To be able to explore a large amount of data, each worksheet of the program has 1,048,576 lines numbered with numbers and 16,384 columns designated with letters of the Latin alphabet.

Thus, each cell is the intersection of various columns and rows on the sheet, forming its own unique address, consisting of the letter of the column and the row number to which it belongs. For example, the name of the first cell is A1 because it is at the intersection of column "A" and row "1".

If the app includes Formula bar which is located immediately below Ribbon, then to the left of it is Name field where the name of the current cell is displayed. Here you can always enter the name of the cell you are looking for, to quickly jump to it. This feature is especially useful on large documents with thousands of rows and columns.

Also for viewing different areas of the sheet, scroll bars are located at the bottom and on the right. In addition, you can use the arrow keys to navigate the Excel workspace.

To start entering data in the desired cell, you must select it. To go to the desired cell, left-click on it, after which it will be surrounded by a black frame, the so-called indicator of the active cell. Now just start typing on the keyboard, and all the information you enter will appear in the selected cell.

When entering data into a cell, you can also use the formula bar. To do this, select the required cell, and then click on the field of the formula bar and start typing. In this case, the information entered will be automatically displayed in the selected cell.

After finishing data entry press:

  • Press "Enter" - the next active cell will be the cell below.
  • Key "Tab" - the next active cell will be the cell to the right.
  • Click on any other cell and it will become active.

To change or delete the contents of any cell, double-click on it with the left mouse button. Move the flashing cursor to the desired location to make the necessary edits. As with many other applications, the arrow keys, Del, and Backspace are used to delete and make corrections. If desired, all necessary edits can be made in the formula bar.

The amount of data that you will enter into a cell is not limited to its visible part. That is, the cells of the working area of ​​the program can contain both one number and several paragraphs of text. Each Excel cell can hold up to 32,767 numeric or text characters.

Formatting cell data

After entering the names of the rows and columns, we get a table of the following type:

As you can see from our example, several names of expense items "went" beyond the boundaries of the cell, and if the adjacent cell (cells) also contain some information, then the entered text partially overlaps with it and becomes invisible. And the table itself looks rather ugly and unpresentable. At the same time, if you print such a document, then the current situation will remain - it will be quite difficult to disassemble in such a table what is going to be quite difficult, as you can see for yourself from the picture below.

To make a spreadsheet document neater and more beautiful, you often have to change the size of rows and columns, the font of the cell content, its background, align the text, add borders, and so on.

First, let's tidy up the left column. Move the mouse cursor over the border of columns "A" and "B" in the row where their names are displayed. When changing the mouse cursor to a characteristic symbol with two oppositely directed arrows, press and hold the left key, drag the dotted line that appears in the required direction to expand the column until all the names fit within one cell.

You can do the same with a string. This is one of the easiest ways to resize the height and width of the cells.

If you need to set the exact sizes of rows and columns, then on the tab home in a group Cells select item Format... In the menu that opens using the commands Line height and Column width you can set these parameters manually.

Very often it is necessary to change the parameters of several cells and even an entire column or row. In order to select an entire column or row, click on its name above or on its number on the left, respectively.

To select a group of adjacent cells, draw around them with the cursor and hold down the left mouse button. If it is necessary to select the scattered fields of the table, then press and hold the "Ctrl" key, and then click on the required cells.

Now that you know how to select and format multiple cells at once, let's center the month names in our table. Various commands for aligning content inside cells are located on the tab home in a group with a telling name Alignment... Moreover, for a table cell, this action can be performed both relative to the horizontal direction and vertical.

Circle the cells with the name of the months in the header of the table and click the button Align Center.

In a group Font in the tab home you can change the font type, size, color and style: bold, italic, underlined, and so on. There are also buttons for changing the borders of a cell and its fill color. All these functions will be useful for us to further change the appearance of the table.

So, first, let's increase the font of the column and column names of our table to 12 points, and also make it bold.

Now, first select the top row of the table and set it to a black background, and then in the left column, cells A2 to A6, dark blue. This can be done using the button Fill color.

You've probably noticed that the color of the text in the top row has merged with the background color, and the names in the left column are poorly readable. Let's fix this by changing the font color using the button Text color to white.

Also using the already familiar command Fill color we have given the background of odd and even rows with numbers a different blue tint.

To prevent the cells from merging, let's define borders for them. Determination of borders occurs only for the selected area of ​​the document, and can be done both for one cell and for the entire table. In our case, select the entire table, then click on the arrow next to the button Other boundaries everyone in the same group Font.

In the menu that opens, a list of quick commands is displayed, with which you can select the display of the desired boundaries of the selected area: bottom, top, left, right, outer, all, and so on. It also contains commands for drawing borders by hand. At the very bottom of the list is the item Other boundaries which allows you to specify in more detail the necessary parameters of the borders of the cells, which we will use.

In the window that opens, first select the type of border line (in our case, a thin solid), then its color (choose white, since the background of the table is dark) and finally, those borders that should be displayed (we chose the inner ones).

As a result, using a set of commands of just one group Font we transformed ugly appearance tables into quite presentable, and now knowing how they work, you yourself will be able to come up with your own unique styles for the design of spreadsheets.

Cell data format

Now, in order to complete our table, it is necessary to properly format the data that we enter there. Recall that in our case, these are cash costs.

You can enter different types of data into each of the cells in a spreadsheet: text, numbers, and even graphics. That is why in Excel there is such a thing as "cell data format", which serves to correctly process the information you enter.

Initially, all cells have General format allowing them to contain both text and digital data. But you are free to change this and choose: numeric, monetary, financial, percentage, fractional, exponential, and formats. In addition, there are formats for date, time of postal codes, telephone numbers and personnel numbers.

For the cells of our table containing the names of its rows and columns, the general format (which is set by default) is quite suitable, since they contain text data. But for the cells in which budget expenditures are entered, the monetary format is more suitable.

Select cells in the table containing information on monthly expenses. On the ribbon in the tab home in a group Number click the arrow next to the field Number Format, after which a menu will open with a list of the main available formats. You can select the item Monetary right here, but we will select the very bottom line for a more complete overview Other number formats.

In the window that opens, in the left column, the name of all number formats, including additional ones, will be displayed, and in the center, various settings for their display.

Having selected the currency format, at the top of the window you can see how the value in the table cells will look like. Slightly below mono set the number of displaying decimal places. So that the pennies do not clutter up the table fields, we will set the value here equal to zero. Next, you can select the currency and display negative numbers.

Now our sample table is finally complete:

By the way, all the manipulations that we did with the table above, that is, the formatting of cells and their data can be performed using the context menu by right-clicking on the selected area and selecting the item Cell format... In the window of the same name, for all the operations we have considered, there are tabs: Number, Alignment, Font, The border and Fill.

Now, after finishing work in the program, you can save or print the obtained result. All these commands are in the tab File.

Conclusion

Probably, many of you will ask the question: "Why create such tables in Excel, when all the same can be done in Word, using ready-made templates?" That is how it is, only to perform all sorts of mathematical operations on cells in text editor impossible. You almost always enter the information in the cells yourself, and the table is only a visual representation of the data. And it is not very convenient to make voluminous tables in Word.

In Excel, the opposite is true, tables can be arbitrarily large, and the value of cells can be entered either manually or automatically calculated using formulas. That is, here the table acts not only as a visual aid, but also as a powerful computational and analytical tool. Moreover, cells can be interconnected with each other not only within one table, but also contain values ​​obtained from other tables located on different sheets and even in different books.

You will learn how to make a table "smart" in the next part, in which we will get acquainted with the basic computational capabilities of Excel, the rules for constructing mathematical formulas, functions and much more.

The fact that the ability to work on a computer today is necessary for everyone and everyone does not raise doubts even among skeptics.

The book you are holding in your hands will be a real friend and helper for those who wish to independently and in a short time master the wisdom of working on personal computer... Written in a simple and straightforward language, it is accessible and easy even for beginners. A large number of specific examples and illustrative illustrations contributes to the quick and easy assimilation of the proposed material.

Its sequential presentation, as well as a detailed step-by-step description of the key operations and procedures, make the study of this book a fascinating process, the result of which will be the ability to communicate well with any modern computer.

Description based on example Windows systems XP Professional.

Book:

As we noted above, an Excel worksheet is a table consisting of cells, each of which is formed as a result of the intersection of a row and a column. But after all, the worksheet is almost never completely filled with data: it usually contains small tables. Accordingly, they need to be somehow indicated on the sheet, having appropriately formalized the visual presentation of a specific table. In particular, the rows and columns of the table should have clear names that reflect their essence, the table should have clear boundaries, etc.

To solve this problem, a special mechanism is implemented in Excel, which is accessed using the toolbar. Borders... You can enable the display of this panel (Fig. 6.21) using the command of the main menu View? Toolbars? The border.

Rice. 6.21. Toolbar The border

First you have to decide what border you want to draw. For example, the common border of the table can be highlighted with bold lines, and the grid of the table - with regular lines, etc. To draw a common border, you need to click the button located on the left in the toolbar, and in the menu that opens (see Fig. 6.21) select the item Picture border... Then, while holding down the mouse button, use the pointer (which will take the shape of a pencil) to outline the border of the table. In order for each cell to be separated from one another by a border, you need to select the item in the menu (see Fig. 6.21) Boundary grid, and then, while holding down the mouse button, draw a range, the cells of which should be separated by a border.

* * *

In fig. 6.22 shows an example of a table created using three types of lines: bold, dash-dotted and double.

Rice. 6.22. Table design option

But that's not all: if you wish, you can decorate each line with any color. To select a color, click in the panel Borders the last button on the right, and specify it in the menu that opens.

Please note that the table borders created in this way cannot be deleted by the traditional method - by pressing the key Delete... To do this, you will need in the panel The border push the button Erase the border(its name is displayed as a tooltip when you hover the mouse pointer), then perform the same actions as in the process of creating a border (i.e., while holding down the mouse button, specify the lines to be erased). To delete a line within one cell, it is enough to move the mouse pointer to this line, which after pressing the button Erase the border will take the form of an eraser, and just click

However, drawing a table is only half the battle: to perform interactive calculations in it, you need to create formulas or apply the appropriate functions. We will consider these operations below, using a specific example.

If you've never used a spreadsheet before to create documents, we recommend reading our Excel guide for dummies.

After that, you can create your first spreadsheet with tables, graphs, math formulas and formatting.

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


Working with cells. Padding and formatting

Before you start any specific steps, you need to understand the basic element of any document in Excel. An Excel file consists of one or more sheets divided into small cells.

A cell is the basic component of any Excel report, table or graph. Each cell contains one block of information. It can be a number, date, currency, unit of measure, or other data format.

To fill in a cell, you just need to click on it with the pointer and enter the required information. To edit a previously filled cell, double-click on it.

Rice. 1 - an example of filling cells

Each cell on the sheet has its own unique address. Thus, you can carry out calculations or other operations with it. When you click on a cell, a field with its address, name and formula will appear at the top of the window (if the cell is involved in any calculations).

Let's select the cell "Share of shares". Its location address is A3. This information is indicated in the properties panel that opens. We can also see the content. This cell does not have formulas, so they are not shown.

More cell properties and functions that can be used in relation to it are available in the context menu. Click on the cell with the right key of the manipulator. A menu will open, with which you can format the cell, analyze the content, assign a different value, and other actions.

Rice. 2 - context menu of a cell and its main properties

Sorting data

Often users are faced with the task of sorting data on a sheet in Excel. This feature helps you quickly select and view only the data you want from the entire table.

Before you is an already completed table (we will figure out how to create it later in the article). Imagine that you want to sort the data for January in ascending order. How would you do it? A banal retyping of a table is an extra work, and besides, if it is voluminous, no one will do it.

Excel has a dedicated function for sorting. The user is only required to:

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

Rice. 3 - "Data" tab

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

Rice. 4 - setting sorting parameters

The data will be automatically sorted:

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

Similarly, you can sort by 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 out the table. For example, we have two cells with values ​​2 and 17. How to enter their result into the third cell without doing the calculations yourself?

To do this, you need to click on the third cell, in which the final result of the calculations will be entered. Then click on the function icon f (x) as shown in the figure below. In the window that opens, select the action you want to apply. SUM is the sum, AVERAGE is the average, and so on. A complete list of functions and their names in the Excel editor can be found on the official website of Microsoft.

We need to find the sum of two cells, so click on "SUM".

Rice. 6 - selection of the "SUM" function

The function arguments window has two fields: "Number 1" and "Number 2". Select the first field and click on the cell with the number "2". Its address will be written to 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 math with three or more boxes, just keep entering argument values ​​in the Number 3, Number 4, and so on boxes.

If in the future the value of the summed cells changes, their sum will be updated automatically.

Rice. 7 - the result of the calculations

Creating tables

Any data can be stored in Excel tables. With the help of the quick setup and formatting function, in the editor it is very easy to organize a personal budget control system, a list of expenses, digital data for reporting, and so on.

Tables in Excel take precedence over similar options in Word and other office programs. Here you have the opportunity to create a table of any dimension. The data is filled in easily. There is a function panel for editing content. In addition, the finished table can be integrated into the docx file using the usual copy-paste function.

To create a table, follow the instructions:

  • Click the Insert tab. On the left side of the options panel, select Table. If you need to summarize any data, select the "Pivot Table" item;
  • Using the mouse, select a place on the sheet that will be allocated for the table. And also you can enter the location of the data in the element creation window;
  • Click OK to confirm the action.

Rice. 8 - creating a standard table

To format the appearance of the resulting plate, open the contents of the constructor and in the "Style" field, click on the template you like. If desired, you can create your own look with a different color scheme and cell selection.

Rice. 9 - formatting the table

The result of filling the table with data:

Rice. 10 - filled table

For each cell in the table, you can also customize the data type, formatting, and information display mode. The constructor window contains all the necessary options for further configuration of the plate, based on your requirements.

Adding graphs / charts

To build a chart or graph, a ready-made plate is required, because the graphic data will be based precisely on information taken from individual lines or cells.

To create a chart / graph, you need:

  • Select the table completely. If you need to create a graphic element only to display the data of certain cells, select only them;
  • Open the insert tab;
  • In the recommended charts box, select the icon that you think will best visually describe the tabular information. In our case, this is a 3-D pie chart. Move the pointer to the icon and select the appearance of the element;

    • Likewise, you can create scatter plots, line charts, and table element dependencies. All the resulting graphic elements can also be added to Word documents.

    There are many other functions in the Excel spreadsheet editor, however, for the initial work, the techniques described in this article will suffice. In the process of creating a document, many users independently master the more advanced options. This is due to a user-friendly and intuitive interface. latest versions programs.

    Thematic videos: