Good day!
The question of creating a table in Excel is quite popular among novice users ( 
). In general, the sheet itself in Excel (what you see after starting the program) is one large table, divided into cells. And usually this question is understood as a "visual" design of certain cells in the form of a table (by the way, this simplifies some actions: finding the sum, average, minimums / maximums, etc.).
Below I will consider the solution to a similar problem (and related questions that arise in this case). So...
*
Creating a table
The article material is relevant for Excel 2019, 2016, 2013
First, I will consider the classic option: when you just have a blank sheet in Excel and you have not entered any data yet (see the screenshot below).
The first thing to do is to select a certain number of cells (focus on how many columns / rows you need for the table).
Select the desired area
Then, in the "Home" section, select the "Format as Table" tab (example below).
Format as Table / Clickable
Next, you will be presented with fifty different options for the design of tables - just select one of them.
Table design options
Then you can refine the boundaries of the table (if necessary) and click OK.
Formatting
The table is ready!
Please note that after selecting the table, you will automatically open the "Design" section: you can specify whether you need subheadings, filters for sorting, totals, alternating rows, etc.
What happened in the end
Let's consider how to calculate the sum of the numbers in the table, average, maximum, etc.
Let's say that we already have some data on the sheet (in my example, I took the simplest table of only 3 rows). The work is structured in the same way: first, select it, in the "Format as table" tab, select the desired option and click OK.
Selecting an area, and choosing the desired formatting
Next, in the "Constructor" include a row of subheadings and totals (the amount for the under-ice column will be calculated automatically, see the example below).
Turn on the totals row
If you need a sum (or average, maximum, minimum, etc.) for other columns: just in the totals row, click on the desired cell and in the properties select what you want to count (for example, I calculated the average price of products).
We find the average price, amount, maximum, minimum, etc.
Note that for large tables, the filter button can be very useful (to keep only certain rows visible). It is also very convenient to use this to sort the table (for example, by name from A to Z, or vice versa).
Sort table / Clickable
How to enlarge a table
If the number of rows (or columns) in the table is no longer enough for you, then it is quite easy to increase them by the required number. To do this, just select the last cell in the table (if there is a "Totals" row, then the cell in front of it, as in the example below), and stretch the cell by the required number of rows.
Increasing the number of lines
Moreover, all calculations in the totals line will remain unchanged (since the added lines will be empty, and you have yet to fill them in ...).
The table has become larger ...
How to insert the resulting table into Word
When the table is ready (formatted in the right way, totals are calculated, etc.), it often needs to be transferred to a Word document. It's very easy to do!
First: you need to select the resulting table and press the key combination Ctrl + C (copy).
Selection of table area / Clickable
Second: put the cursor in the desired place in the Word document and press the keyboard shortcut Ctrl + V (insert). I draw your attention to the fact that the table will be inserted exactly the same as it was in Excel (i.e. design, rows, columns, various totals and notes - everything will be transferred).
Table inserted in Word / Clickable
PS
I will also recommend you one article with the basics of working in Excel - //ocomp.info/kak-napisat-formulu-v-excel.html. Having mastered the material from it, you can solve fairly common problems (those that surround us in real life), and significantly speed up your office work!
*
That's all for now ...
Happy work!
