What is a table in Excel. Basic types of data entry and simple operations

Hi all! Today's material is for those who continue to master working with application programs and do not know how to make a pivot table in Excel.

Having created a general table in any of the text documents, you can analyze it by making pivot tables in Excel.

Creating an Excel pivot table requires meeting certain conditions:

1. The data fits into a table with columns and lists with names.
2. No unfilled forms.
3. No hidden objects.

How to make a pivot table in excel: step-by-step instructions

To create a pivot table you need:

An empty sheet has been created, where you can see lists of areas and fields. Headings have become fields in our new table. Pivot table will be formed by dragging fields.

They will be marked with a checkmark, and for ease of analysis you will swap them in the table areas.


I decided that I would do the data analysis through a filter by seller, so that it would be clear by whom and for what amount each month was sold, and what kind of product.

We choose a specific seller. Hold down the mouse and move the “Seller” field to the “Report Filter”. The new field is checked and the table view changes slightly.


We will put the “Products” category in the form of lines. We transfer the field we need to “Line titles”.


To display a drop-down list, it matters in what order we specify the name. If we initially make a choice in favor of a product in the lines, and then indicate the price, then the products will be drop-down lists, and vice versa.

The “Units” column, being in the main table, displayed the quantity of goods sold by a certain seller at a specific price.


To display sales, for example, for each month, you need to replace the “Date” field with “Column names”. Select the "Group" command by clicking on the date.


Specify the date periods and step. Confirm your choice.

We see such a table.


Let's move the "Amount" field to the "Values" area.


The display of numbers has become visible, but we need the number format


To correct this, select the cells by calling up the window with the mouse and selecting “Number Format”.

We select the number format for the next window and check “Digit group separator”. Confirm with the “OK” button.

Designing a Pivot Table

If we check the box that confirms the selection of several objects at once, we will be able to process data for several sellers at once.


The filter can be applied to columns and rows. By checking the box on one of the product types, you can find out how much of it was sold by one or more sellers.


Field parameters are also configured separately. Using the example, we see that a certain Roma seller in a specific month sold shirts for a specific amount. By clicking the mouse, in the line “Sum by field...” we call up the menu and select “Value Field Parameters”.


Next, to summarize the data in the field, select “Quantity”. Confirm your choice.

Look at the table. It clearly shows that in one month the seller sold 2 shirts.


Now we change the table and make the filter work by month. We transfer the “Date” field to the “Report Filter”, and where “Column Names” is, there will be “Seller”. The table displays the entire sales period or for a specific month.

Selecting cells in a pivot table will cause a tab to appear called “Working with Pivot Tables”, and there will be two more tabs “Options” and “Designer”.


In fact, you can talk about the settings of pivot tables for a very long time. Make changes to your taste, achieving a convenient use for you. Don't be afraid to push and experiment. You can always change any action by pressing the combination Ctrl keys+Z.

I hope you have learned all the material and now know how to make a pivot table in Excel.

The life of a person from the world of technology is an incredible combination of numbers and indicators that periodically require systematization. To accomplish the latter, you have to use special technical tools. Our article will prove that pivot tables in Excel are accessible even for dummies.

A little theory

Excel Pivot Tables (for dummies) are a type of registry that contains a specific piece of data from a source for analysis and is depicted so that logical connections can be traced between them. The basis for its design is a specific list of values.

Before starting work, it is worth preparing the necessary materials for it that can be compiled for analysis. When creating a preparatory version, make sure that the data is classified, for example, numbers are not confused with letter designation, and all columns had headings.

Pivot tables in Excel are indispensable for those who, due to their occupation, deal with big amount numbers that periodically need to be systematized and report generated. Excel will help you calculate and analyze a large number of values, saving time.

The advantages of using this type of data grouping:

• during operation, no special programming knowledge is required; the method is suitable for dummies;
• the ability to combine information from other primary sources;
• you can update the basic instance with new information by slightly adjusting the parameters.

Learning to work with pivot tables in Excel does not take much time and can be based on videos.

An example of creating an Excel pivot table - an algorithm for dummies

Having familiarized ourselves with the basic theoretical nuances about pivot tables in Excel, let's move on to applying them in practice. To start creating a pivot table in Excel 2016, 2010 or 2007, you must install software. As a rule, if you use programs Microsoft systems Office, then Excel is already on your computer.

Having launched it, a vast field will open in front of you, divided into a large number of cells. The video tutorial above will tell you more about how to make pivot tables in Excel.

Using the following algorithm, we will look in detail at an example of how to build a pivot table in Excel.
In the panel at the top of the window, go to the “Insert” tab, where in the left corner we select “Pivot Table”.


Next, a dialog box opens on the screen where you need to specify the appropriate parameters. There are several important points at this stage of creating pivot tables in Excel. If before you start creating the registry, you set the cursor icon on the sheet, then the empty lines of the window will be filled in automatically. Otherwise, the address of the data range must be designated independently.


Let's take a closer look at filling out the dialog box items yourself.

We do not leave the first line empty, otherwise the program will generate an error. If there is a source from which you plan to transfer data, then select it in the “Use external data source” item. An external source means another Excel workbook or a set of data models from a DBMS.

Give each column a title in advance.

Select the place where the future frame with cells will be located. This can be a new window or this sheet, we recommend using a different sheet.


Having secured all the settings, we get a ready-made base. By left side The area where the base of the future frame is located is located. On the right side there is a settings window that helps you manage the registry.


Now we need to figure out how this whole structure is built. In the “Free Table Fields” settings window, you designate the data that will be present.


The entire structure is built in such a way that text data plays the role of unifying elements, and numerical data shows consolidated values. For example, let’s combine all receipts by department and find out how much goods each person received. To do this, check two headings: department and cost of goods in the batch.


Notice how this data is located in the lower area of ​​the settings panel.


The department automatically went into lines, and the numerical data into values. If you try to click on any column with numbers, they will appear in this area. And a new column will be added to the table itself.


In this case, summation occurs. Now we can find out from our report how many goods arrived in each department and their total cost.

You can freely adjust the width of the columns to optimally position the data. Simply expand the column widths or row heights as you are used to in Excel.


If you don't like this orientation, you can drag the row names into the columns area with your mouse - just hover your mouse, click left button and pull.


As for calculating results, the amount is far from the only function. To see what else Excel offers, click the name in the Values ​​area and select the latest command.


In the value field options you will find many options for analysis.


For each value you can select your own function. For example, let's add the "Price" field and find the maximum price of the product in each department. In fact, we’ll find out how much the most expensive one costs.


Now we see that the “Accessories” department received goods worth 267,660 rubles, while the most expensive one has a price of 2,700 rubles.
The “Filters” area allows you to set criteria for selecting records. Let’s add the “Date of receipt” field by simply checking the box next to it.


Nowadays, a pivot table in Excel looks awkward if we need to analyze by date. Therefore, let's move the date from the rows to the filters - just drag and drop as indicated above.


The result of these actions was the appearance of another field on top. To select a date, click on the arrow next to the word “All”.


Now we can select a specific day; to open the list, click on the triangle in the right corner.


You can also select values ​​for the department.


Uncheck those that do not interest you, and you will receive only the information you need.

While working, you may encounter a similar message “Invalid Excel PivotTable Name”. This means that the first row of the range from which they are trying to extract information is left with empty cells. To solve this problem, you must fill the column spaces.

Refresh data in a PivotTable in Excel

An important question is how to make and update a pivot table in Excel 2010 or other version. This is relevant when you are going to add new data. If the update will take place only for one column, then you need to click anywhere on it right click mice. In the window that appears, click “Update”.


If a similar action needs to be carried out with several columns and rows at once, then select any zone and open the “Analysis” tab on the top panel and click on the “Update” icon. Next, choose the desired action.


If you don't need a pivot table in Excel, then you should figure out how to delete it. It won't be difficult. Select all components manually, or using the keyboard shortcut “CTRL+A”. Next, press the “DELETE” key and the field will be cleared.

How to add a column or table to an Excel PivotTable

To add an additional column, you need to add it to the source data and expand the range for our registry.


Go to the Analysis tab and open the data source.


Excel will suggest everything itself.


Refresh and you will get a new list of fields in the settings area.

You can add a table only if you “glue” it with the original one. You can replace a range in an existing one, but you cannot add another range on the fly. But you can create a new pivot table based on several original ones, even located on different sheets.

How to make a pivot table in Excel from several sheets

To do this, we need the Pivot Table Wizard. Let's add it to the panel quick access(the very top of the window is on the left). Click the drop-down arrow and select "More Commands."


Select all commands.


And find the Excel Pivot Table Wizard, click on it, then on “Add” and OK.


The icon will appear at the top.


You should have two tables with identical fields on different sheets. We have data on receipts in departments for May and June. Click the PivotTable Wizard shortcut and select Range Consolidation.


We need several fields, not just one.


In the next step, select the first range and click the “Add” button. Then switch to another sheet (click on its name below) and “Add” again. You will have two ranges created.

You should not select the entire table. We need information about department receipts, so we've highlighted a range starting with the Department column.
Give each one a name. Click circle 1, then enter “May” in the field, click circle 2 and enter “June” in field 2. Don't forget to change the ranges in the area. The one we call must be highlighted.

Click “Next” and create on a new sheet.


After clicking “Finish” we will get the result. This is a multidimensional table, so it is quite difficult to manage. That's why we chose a smaller range, so as not to get confused in the measurements.


Please note that we no longer have clear field names. They can be pulled out by clicking on the items in the top area.


By unchecking or checking the boxes, you adjust the values ​​you want to see. It is also inconvenient that the calculation is the same for all values.

As you can see, we have one value in the corresponding area.

Changing the report structure

We have examined step by step an example of how to create a pivot table in Exce, and we will tell you how to obtain another type of data further. To do this, we will change the report layout. Having placed the cursor on any cell, go to the “Designer” tab, and then “Report Layout”.

You will have a choice of three types for structuring information:

• Condensed form

This type of program is applied automatically. The data is not stretched, so there is virtually no need to scroll through images. You can save space on signatures and leave it for numbers.

• Structured form

All indicators are presented hierarchically: from small to large.

• Tabular form

The information is presented under the guise of a register. This makes it easy to transfer cells to new sheets.

Having chosen a suitable layout, you secure the adjustments made.

So, we told you how to create pivot table fields in MS Excel 2016 (in 2007, 2010, proceed by analogy). We hope this information will help you quickly analyze your consolidated data.

Have a great day!

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

You'll then be able to create your first spreadsheet with tables, graphs, math formulas, and formatting.

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

Working with cells. Filling and formatting

Before proceeding with specific actions, you need to understand the basic element of any document in Excel. An Excel file consists of one or several sheets divided into small cells.

A cell is a basic component of any Excel report, table or graph. Each cell contains one block of information. This could be a number, date, monetary amount, unit of measurement, or other data format.

To fill out a cell, simply click on it with the pointer and enter the required information. To edit a previously filled cell, double-click on it.

Rice. 1 – 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 will appear at the top of the window with its address, name and formula (if the cell is involved in any calculations).

Select the “Share of Shares” cell. Its location address is A3. This information is indicated in the properties panel that opens. We can also see the content. This cell has no formulas, so they are not shown.

More cell properties and functions that can be applied to it are available in the context menu. Click on the cell with the right mouse button. A menu will open with which you can format the cell, analyze the contents, assign a different value, and other actions.

Rice. 2 – context menu of the 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 need from the entire table.

In front of you is an already filled out table (we’ll figure out how to create it later in the article). Imagine that you need to sort data for January in ascending order. How would you do it? Simply retyping a table is extra work, and if it is large, no one will do it.

There is a special function for sorting in Excel. The user is only required to:

• Select a table or block of information;
• Open the “Data” tab;
• Click on the “Sorting” icon;

Rice. 3 – “Data” tab

• In the window that opens, select the table column on which we will perform actions (January).
• Next is the sorting type (we group by value) and, finally, the order - ascending.
• Confirm the action by clicking on “OK”.

Rice. 4 – setting sorting parameters

The data will be sorted automatically:

Rice. 5 – the result of sorting the numbers in the “January” column

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

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 image below. In the window that opens, select the action you want to apply. SUM is the sum, AVERAGE is the average, and so on. Full list functions and their names in the Excel editor can be found on the official website Microsoft.

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

Rice. 6 – select the “SUM” function

There are two fields in the function arguments window: “Number 1” and “Number 2”. Select the first field and click on the cell with the number “2”. Its address will be written into the argument line. 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 operations on three or more cells, simply continue entering the argument values ​​in the Number 3, Number 4, and so on fields.

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

Rice. 7 – result of calculations

Creating tables

You can store any data in Excel tables. Using the function quick setup and formatting, it is very easy to organize a personal budget control system, a list of expenses, digital data for reporting, etc. in the editor.

Tables in Excel have an advantage over a similar option in Word and others office programs. Here you have the opportunity to create a table of any size. The data is easy to fill out. There is a function panel for editing content. In addition, the finished table can be integrated into docx file using the usual copy-paste 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 consolidate any data, select the “Pivot Table” item;
• Using the mouse, select the space 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 appearance the resulting sign, open the contents of the designer and in the “Style” field, click on the template you like. If desired, you can create your own view with a different color scheme and selecting cells.

Rice. 9 – table formatting

Result of filling the table with data:

Rice. 10 – completed table

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

Adding graphs/charts

To build a chart or graph, you need to have a ready-made plate, because graphical data will be based precisely on information taken from individual rows or cells.

To create a chart/graph you need:

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

In a similar way, you can create scatter plots, line diagrams, and table element dependency diagrams. All received graphic elements can also be added to text documents Word.

The Excel spreadsheet editor has many other functions, however, the techniques described in this article will be sufficient for initial work. In the process of creating a document, many users independently master more advanced options. This happens thanks to a convenient and intuitive interface latest versions programs.

Thematic videos:

Excel is needed to create tables and make calculations. Now we will learn how to correctly compile and format tables.

Open Excel (Start - Programs - Microsoft Office - Microsoft Office Excel).

At the top there are buttons for editing. This is what they look like in Microsoft Excel 2003:

And so - in Microsoft Excel 2007-2019:

After these buttons there is the working (main) part of the program. It looks like one big table.

Each of its cells is called a cell.

Pay attention to the topmost cells. They are highlighted in a different color and called A, B, C, D and so on.

In fact, these are not cells, but column names. That is, it turns out that we have a column with cells A, a column with cells B, a column with cells C, and so on.

Also pay attention to the small rectangles with the numbers 1, 2, 3, 4, etc. on the left side of Excel. These are also not cells, but row names. That is, it turns out that the table can also be divided into rows (line 1, line 2, line 3, etc.).

Based on this, each cell has a name. For example, if I click on the first cell from the top left, then you can tell that I clicked on cell A1 because it is in column A and row 1.

And in the next picture, cell B4 is clicked.

Please note that when you click on a particular cell, the column and row in which they are located changes color.

Now let's try to print some numbers in B2. To do this, you need to click on this cell and enter the numbers on the keyboard.

To consolidate the entered number and move to the next cell, press the Enter button on your keyboard.

By the way, there are a lot of cells, rows and columns in Excel. You can fill out the table ad infinitum.

Design buttons in Excel

Let's look at the design buttons at the top of the program. By the way, they are also available in Word.

Font. The style in which the text will be written.

Letter size

Style (bold, italic, underlined)

Using these buttons you can align text in a cell. Place it on the left, center or right.

By clicking on this button, you can cancel the previous action, that is, go back one step.

Change text color. To select a color, you need to click on the small arrow button.

Using this button you can fill the cell with color. To select a color you need to click on the small arrow button.

How to create a table in Excel

Look at the small table already compiled in Excel:

Its upper part is the hat.

In my opinion, making the header is the most difficult part of creating a table. We need to think through all the points and provide for a lot. I advise you to take this seriously, because very often, due to an incorrect header, you have to redo the entire table.

Following the header is the content:

And now in practice we will try to compose in Excel program such a table.

In our example, the header is the top (first) line. Usually that's where she is.

Click on cell A1 and type the first item “Name”. Then click in cell B1 and type the next item - “Quantity”. Please note that words do not fit in cells.

Fill in the remaining cells C1 and D1.

Now let’s bring the hat back to normal. First you need to expand the cells, or rather the columns in which the words do not fit.

To expand a column you need to move the cursor (mouse arrow) over the line separating the two columns, in our case, the line between A and B. The cursor will change and take the form of an unusual double-sided black arrow. Press the left mouse button and, without releasing it, stretch the column to the desired width.

The same can be done with strings.

To expand a string Place the cursor (mouse arrow) on the line separating the two lines. The cursor will change and take the form of an unusual double-sided black arrow. Press the left mouse button and, without releasing it, stretch the line to the desired width.

Expand the columns where the text does not fit. Then make the hat a little bigger. To do this, move the cursor over the line between lines 1 and 2. When it changes view, press the left button and, without releasing it, expand the first line.

It is customary for the header to be slightly different from the content. In the table we are repeating, the header items are “thicker” and “blacker” than the rest of the content, as well as the cells are shaded gray. To do this, you need to use the top part of Excel.

Click on cell A1. With this simple action you will select it, that is, you will “tell” Excel that you are going to change something in this cell. Now click on the button at the top of the program. The text in the cell will become thicker and blacker (bold).

Of course, you can change the remaining points in the same way. But imagine that we have not four of them, but forty-four... This will take a lot of time. To make this faster, we need to select the part of the table that we are going to change. In our case, this is the header, that is, the first line.

There are several ways to highlight.

Selecting an entire Excel table. To do this, click on the small rectangular button in the left corner of the program, above the first line (the rectangle with the number 1).

Selecting part of a table. To do this, click on the cell with the left mouse button and, without releasing it, circle the cells that you want to select.

Select a column or row. To do this, click on the name of the desired column

or strings

By the way, you can select several columns and rows in the same way. To do this, click on the name of the column or row with the left mouse button and, without releasing it, drag along the columns or rows that you want to select.

Now let's try to change the header of our table. To do this, select it. I suggest selecting the entire line, that is, clicking on the number 1.

After this, we will make the letters in the cells thicker and blacker. To do this, press the button

Also in the table we need to make, the words in the header are located in the center of the cell. To do this, click the button

Well, finally, let's paint the cells in the header with a light gray color. To do this, use the button

To select the appropriate color, click on the small button next to it and select the desired one from the list of colors that appears.

We did the hardest thing. All that remains is to fill out the table. Do it yourself.

And now the final touch. Let's change the font and size of letters in the entire table. Let me remind you that first we need to select the part that we want to change.

I suggest selecting the entire table. To do this, click the button

Well, let's change the font and size of the letters. Click on the small arrow button in the field that is responsible for the font.

Select a font from the list that appears. For example, Arial.

By the way, there are a lot of fonts in programs from the Microsoft Office suite. True, not all of them work with the Russian alphabet. You can make sure that there are a lot of them by clicking on the small arrow button at the end of the field to select a font and scrolling the wheel on the mouse (or moving the slider with right side window that appears).

Then change the size of the letters. To do this, click on the small button in the field indicating the size and select the desired one from the list (for example, 12). I remind you that the table must be selected.

If suddenly the letters no longer fit into the cells, you can always expand the column, as we did at the beginning of compiling the table.

And one more very important point. In fact, the printed table we compiled will have no borders (no partitions). It will look like this:

If you are not satisfied with this “limitless” option, you must first select the entire table, and then click on the small arrow at the end of the button, which is responsible for the borders.

From the list, select "All borders".

If you did everything correctly, you will get a table like this.

Microsoft Excel is an excellent program for creating spreadsheets, complex calculations and monitoring statistical information. Using the application, the user can not only build a graph using a formula, but also perform many other manipulations with numbers. Let's try to figure it out how to build a table in Excel yourself.

How to make a table in Excel?

There are two ways to create a table in Microsoft Excel: manually, step by step following the recommendations below, and automatically. You don't need to watch training videos to create a summary data list; Any teapot can cope with the task, just like any teapot.

Important: Before you start using the program, you should prepare information to fill out - the user can insert any value into any free field, but it is better to imagine in advance the “dimensions” and complexity of the required table.

Automatically

Excel can draw a table in full automatic mode; For this, a novice user will need:

• Open a Microsoft Excel sheet, go to the “Insert” tab and click on the “Table” button.

• Draw the approximate boundaries of the workpiece with the mouse pointer (the user can create an “inaccurate” table and then expand it) and click on the “OK” button in the dialog box.

• If necessary, allow adding headers to the list of data. To do this, just check the required checkbox - it’s as easy as learning.

• The finished table will appear on the Excel sheet.

• Now you need to set the names of the columns by clicking on each of them and entering the necessary information in the formula line.

• Until all the headings are in place.

• Great! The user learned how to make automatic Excel tables. All that remains is to fill in the empty fields with numbers and start working with the information.

In manual mode

You can create tables manually - it's almost as fast and much easier than. To draw a data block table on your own, a novice user must:

• Enter the prepared data anywhere in the Excel sheet in the cells.

• Find the “Borders” drop-down list on the “Home” tab and select the “All borders” option in it.

• Then make sure that the program has drawn on the sheet all the lines necessary to form the table.

Important: the user can go the other way - first mark the space for the table, and then enter his data into the outlined cells.

Designing a table in Excel

Below are some tips on how to design a table created in Excel; These recommendations will be equally useful to both experienced and novice users who want to work with the program with the greatest efficiency - and create not only ergonomic, but also beautiful data blocks.

Changing cell color

To make the cells of a table built in Excel more attractive, you can give them different shades. This is done simply:

• The user selects the required blocks.

• Finds the “Fill” drop-down menu on the “Home” tab and selects the colors you like for rows, columns and individual squares.

Advice: You can return everything “as it was” by calling the drop-down menu again and clicking on the “No fill” option.

Changing the height and width of cells

To change the row height or column width in an Excel table, a novice user will need:

• Select to Excel sheet the required line.

• Click on it serial number Right-click and select “Line Height”.

• And set the required value in the dialog box.

• Do the same for vertical rows of data - only instead of “Row Height” click on “Column Width”.

• The user can set horizontal and vertical to any values ​​within reason; To return to the original ones, just use the key combination Ctrl + Z.

Changing font style and size

• Select the required cells, rows or columns on the Excel sheet, and on the “Home” tab, select the optimal character style from the drop-down list.

• Next, using the B and I buttons, determine whether the font should be bold or italic.

• And set the size of the characters - by clicking on the desired one in the drop-down list or using the “More/Less” buttons.

Important: You can reset changes by setting the same font settings for previously adjusted cells as for those that remained unchanged.

Aligning Labels

You can set the position of the cell's text in height and width as follows:

• Select the desired areas of the Excel table with the right mouse button and select the “Format Cells” option in the context menu that opens.

• On the “Alignment” tab, select in the drop-down lists the method for anchoring the text to the center point.

Important: cells that remain unselected will not be centered - the user will have to repeat all manipulations for them from the beginning.

Changing the table style

You can change the style only for an automatically created Excel table; a user who decides to build it manually will be forced to “adjust” the font parameters, cell fill, alignment and other characteristics in order to achieve similarity with the original “blank”.

To change the style in Excel, you need to:

• Switch to the "Design" tab.

• Check the boxes to indicate whether the first and last columns should be bold.

• Do you need a results line under the table - and select other options contained on the tab.

• And by opening the “Styles” drop-down menu located right there, the computer owner will be able to choose one of several dozen completely ready-made templates- and apply it with one click.

Questions from Dummies

As you can see from the examples above, creating a table in Excel is very simple; In conclusion, answers will be given to the most frequently asked questions from novice users.

How to add a column or row?

To add a row or column to the automatically generated Excel spreadsheet, follows:

• For a column, select the header with the right mouse button and select the “Columns on the right/left” option in the menu that opens.

• For a line - select the entire line below the planned one, and, similarly, calling the pop-up menu, find the “Lines above” parameter.

• If the table was created manually, the user will only need to select a new range and, opening the “Borders” menu again, give it the same appearance as the previously created ones. Data transfer in this case is carried out by copying and pasting.

How to calculate the amount in the table?

To find the sum of data in an Excel table, you need to:

• Select the corresponding column, go to the “Home” tab and click on the “AutoSum” button.

• The corresponding values ​​can be calculated by the program for each column and each row of the source table.

The procedure for calculating the amount in Excel tables created automatically is no different from that described above.

How to sort data in a table?

To automatically sort information contained in an Excel table, you should:

• Select a column with the mouse and open the “Sorting” drop-down menu.

• Next, select one of simple options data processing (in ascending or descending order) or, by turning on “Custom sorting”, set the selection parameters in a new window: column number.

• Ordering option.

• And the order: direct or reverse.

Important: in an Excel table created automatically, the user will be able to call sorting directly in context menus columns.

How to insert an image into a table?

To add a picture to an Excel table, you will need to go to the “Insert” tab and click on the “Pictures” button, and then select the required file.

A user who decides to create a table on their own will be able to adjust the size, position and other parameters of the picture by selecting it with a mouse click and automatically going to the “Format” tab.

Let's sum it up

You can create tables in Excel both automatically and manual mode. The user can freely change the font style and size, cell fill color and other data design parameters. To automatically calculate the amount by column or row or sort the numbers contained in the table, just use the corresponding buttons on the “Home” tab.