Useful functions in Microsoft Excel. Creating formulas in Microsoft Excel In Excel

MS Excel has many amazing tools that most users are unaware of or greatly underestimate. These include Excel tables. Would you say that all Excel is a spreadsheet? No. The working area of ​​a sheet is just a set of cells. Some of them are filled, some are empty, but in essence and functionality they are all the same.

An Excel spreadsheet is completely different. This is not just a range of data, but an entire object that has its own name, internal structure, properties and many advantages over a regular range of cells. Also known as “smart tables”.

How to create a Table in Excel

The usual range of sales data is available.

To convert a range to a Table, select any cell and then Insert → Tables → Table

There is a hotkey Ctrl+T.

A small dialog box will appear where you can adjust the range and indicate that the first row contains the column headers.

As a rule, we don’t change anything. After clicking OK, the original range will turn into an Excel Table.

Before moving on to the Table properties, let’s first look at how Excel itself sees it. Much will become clear immediately.

Structure and links to an Excel table

Each Table has its own name. This can be seen in the tab Constructor, which appears when any Table cell is selected. By default it will be "Table1", "Table2", etc.

If you plan to have several Tables in your Excel workbook, then it makes sense to give them more descriptive names. This will make them easier to use in the future (for example, when working in Power Pivot or ). I'll change the title to "Report". Report table visible in Name Manager Formulas → Defined Names → Name Manager.

And also when typing the formula manually.

But the most interesting thing is that Excel sees not only the whole Table, but also its individual parts: columns, headings, totals, etc. The links look like this.

=Report[#All]– for the entire Table
=Report[#Data]– data only (no header line)
=Report[#Headings]– only on the first line of headings
=Report[#Results]- on the results
=Report[@]– for the entire current line (where the formula is entered)
=Report[Sales]– for the entire “Sales” column
=Report[@Sales]– to a cell from the current row of the “Sales” column

To write links, it is not at all necessary to remember all these structures. When typing formulas manually, all of them are visible in the tooltips after selecting Table and opening the square bracket (in the English layout).

Select the desired one with the key Tab. Don't forget to close all brackets, including square brackets.

If in some cell you write a formula for summing over the entire “Sales” column

SUM(D2:D8)

then it will automatically be converted into

This means that a chart or where an Excel Table is specified as the source will automatically pull up new records.

And now about how Tables make life and work easier.

Excel Table Properties

1. Each Table has headers, which are usually taken from the first row of the source range.

2. If the Table is large, then when you scroll down, the names of the Table columns replace the names of the sheet columns.

Very convenient, no need to specially secure areas.

3. An autofilter is added to the table by default, which can be disabled in the settings. More on this below.

4. New values ​​written in the first empty row from the bottom are automatically included in the Excel Spreadsheet, so they immediately go into a formula (or chart) that references some column in the Spreadsheet.

New cells are also formatted to match the table style, and filled with formulas if they exist in a certain column. In short, to extend the Table it is enough to enter only the values. Formats, formulas, links - everything will be added automatically.

5. New columns will also be automatically included in the Table.

6. When you enter a formula into one cell, it is immediately copied to the entire column. No need to manually pull.

In addition to the specified properties, it is possible to make additional settings.

Table Settings

In the context tab Constructor There are additional analysis and settings tools.

Using checkmarks in a group Table Style Options

You can make the following changes.

- Remove or add header row

— Add or remove a line with totals

— Make the string format interleaved

— Make the first column bold

— Make the last column bold

— Make alternating row fill

— Remove default autofilter

The video tutorial below shows how this works in action.

In Group Table styles you can choose a different format. By default it is like in the pictures above, but this is easy to change if necessary.

In Group Tools Can create a pivot table, remove duplicates, and convert to normal range.

However, the most interesting thing is the creation slices.

A slice is a filter placed in a separate graphic element. Click on the button Insert slice, select the column(s) by which we will filter,

Microsoft Excel is an extremely useful program in various areas. A ready-made table with the ability to autofill, quickly calculate and calculate, build graphs, diagrams, create reports or analyses, etc.

Spreadsheet tools can greatly facilitate the work of specialists from many industries. The information presented below is the basics of working in Excel for dummies. After mastering this article, you will acquire the basic skills with which any work in Excel begins.

Instructions for working in Excel

An Excel workbook consists of sheets. A sheet is a work area in a window. Its elements:

To add a value to a cell, left-click on it. Enter text or numbers from the keyboard. Press Enter.

Values ​​can be numeric, text, monetary, percentage, etc. To set/change the format, right-click on the cell and select “Format Cells”. Or press the hotkey combination CTRL+1.

For number formats, you can assign the number of decimal places.

Note. To quickly set the number format for a cell, press the hotkey combination CTRL+SHIFT+1.

For Date and Time formats, Excel offers several options for displaying values.

Let's edit the cell values:

To delete a cell value, use the Delete button.

To move a cell with a value, select it and press the button with scissors (“cut”). Or press the combination CTRL+X. A dotted line appears around the cell. The selected fragment remains on the clipboard.

Place the cursor somewhere else in the work field and click “Insert” or the CTRL+V combination.

In the same way, you can move several cells at once. On the same sheet, on another sheet, in another book.

To move multiple cells, you need to select them:

1. Place the cursor in the uppermost cell on the left.
2. Press Shift, hold and use the arrows on the keyboard to select the entire range.

To select a column, click on its name (Latin letter). To highlight a line, use a number.

To change the size of rows or columns, move the borders (the cursor in this case takes the form of a cross, the crossbar of which has arrows at the ends).

To make the value fit in the cell, the column can be expanded automatically: click on the right border 2 times.

To make it more beautiful, let's move the border of column E a little, align the text in the center relative to the vertical and horizontal.

Let’s merge several cells: select them and click the “Merge and Place in Center” button.

Excel has an AutoFill feature. Enter the word “January” in cell A2. The program recognizes the date format and will fill in the remaining months automatically.

We grab the lower right corner of the cell with the value “January” and drag it along the line.

Let's test the autocomplete function on numeric values. We put “1” in cell A3, and “2” in A4. Select two cells, grab the autofill marker with the mouse and drag it down.

If we select only one cell with a number and drag it down, then this is the number “multiply”.

To copy a column to an adjacent one, select this column, “catch” the autofill marker and drag it to the side.

You can copy strings in the same way.

Let's delete a column: select it - right-click - "Delete". Or by pressing the hotkey combination: CTRL+"-"(minus).

To insert a column, select the one adjacent to the right (the column is always inserted on the left), right-click - “Insert” - “Column”. Combination: CTRL+SHIFT+"="

To insert a line, select the one adjacent to the bottom. Key combination: SHIFT+SPACEBAR to select a line and press the right mouse button - “Insert” - “Row” (CTRL+SHIFT+"=")(the line is always inserted from above).



How to work in Excel: formulas and functions for dummies

In order for the program to perceive the information entered into a cell as a formula, we put the “=” sign. For example, = (2+3)*5. After you press ENTER, Excel calculates the result.

The calculation sequence is the same as in mathematics.

A formula can contain not only numeric values, but also references to cells with values. For example, =(A1+B1)*5, where A1 and B1 are cell references.

To copy a formula to other cells, you need to “hook” the autofill marker in the cell with the formula and drag it down (to the side - if you are copying to row cells).

When you copy a formula with relative cell references, Excel changes the constants depending on the address of the current cell (column).

In each cell of column C, the second term in brackets is 3 (the reference to cell B1 is constant and unchanging).

Built-in functions significantly expand the functionality of the program. To insert a function, you need to press the fx button (or the SHIFT+F3 key combination). A window like this will open:

To avoid scrolling through a large list of functions, you must first select a category.

When the function is selected, click OK. The Function Arguments window opens.

The functions recognize both numeric values ​​and cell references. To put a link in the argument field, you need to click on the cell.

Excel recognizes another way to enter a function. Place the “=” sign in the cell and begin entering the name of the function. After the first characters, a list of possible options will appear. If you hover your cursor over any of them, a tooltip will appear.

Double-click on the desired function - the order of filling in the arguments becomes available. To finish entering arguments, you need to close the parenthesis and press Enter.

ENTER - the program found the square root of the number 40.

A formula tells Excel what to do with numbers or values ​​in a cell or group of cells. Without formulas, spreadsheets are not needed in principle.

Formula construction includes: constants, operators, links, functions, range names, parentheses containing arguments and other formulas. Using an example, we will analyze the practical application of formulas for novice users.

Formulas in Excel for dummies

To set a formula for a cell, you need to activate it (place the cursor) and enter equals (=). You can also enter an equal sign in the formula bar. After entering the formula, press Enter. The result of the calculation will appear in the cell.

Excel uses standard mathematical operators:

The “*” symbol is required when multiplying. It is unacceptable to omit it, as is customary during written arithmetic calculations. That is, Excel will not understand the entry (2+3)5.

Excel can be used as a calculator. That is, enter numbers and mathematical calculation operators into the formula and immediately get the result.

But more often cell addresses are entered. That is, the user enters a link to the cell whose value the formula will operate on.

When values ​​in cells change, the formula automatically recalculates the result.

The operator multiplied the value of cell B2 by 0.5. To enter a cell reference into a formula, just click on that cell.

In our example:

1. Place the cursor in cell B3 and enter =.
2. We clicked on cell B2 - Excel “labeled” it (the cell name appeared in the formula, a “flickering” rectangle formed around the cell).
3. Enter the sign *, the value 0.5 from the keyboard and press ENTER.

If several operators are used in one formula, the program will process them in the following sequence:

• %, ^;
• *, /;
• +, -.

You can change the sequence using parentheses: Excel first calculates the value of the expression in parentheses.



How to designate a constant cell in an Excel formula

There are two types of cell references: relative and absolute. When copying a formula, these links behave differently: relative ones change, absolute ones remain constant.

Find the autofill marker in the lower right corner of the first cell of the column. Click on this point with the left mouse button, hold it and “drag” it down the column.

Release the mouse button - the formula will be copied to the selected cells with relative links. That is, each cell will have its own formula with its own arguments.

In the second part of the Excel 2010 series for beginners, you will learn how to link table cells with mathematical formulas, add rows and columns to a ready-made table, learn about the AutoFill function, and much more.

Introduction

In the first part of the “Excel 2010 for Beginners” series, we got acquainted with the very basics of Excel, learning how to create regular tables in it. Strictly speaking, this is a simple matter and, of course, the capabilities of this program are much wider.

The main advantage of spreadsheets is that individual data cells can be linked together by mathematical formulas. That is, if the value of one of the interconnected cells changes, the data of the others will be recalculated automatically.

In this part, we will figure out what benefits such opportunities can bring using the example of the table of budget expenses that we have already created, for which we will have to learn how to create simple formulas. We will also get acquainted with the cell autofill function and learn how you can insert additional rows and columns into the table, as well as merge cells in it.

Perform basic arithmetic operations

In addition to creating regular tables, Excel can be used to perform arithmetic operations in them, such as addition, subtraction, multiplication and division.

To perform calculations in any table cell, you need to create inside it the simplest formula, which must always begin with an equal sign (=). To specify mathematical operations within a formula, ordinary arithmetic operators are used:

For example, let's imagine that we need to add two numbers - “12” and “7”. Place the mouse cursor in any cell and type the following expression: “=12+7”. When you have finished entering, press the “Enter” key and the cell will display the calculation result - “19”.

To find out what a cell actually contains - a formula or a number - you need to select it and look at the formula bar - the area located immediately above the column names. In our case, it just displays the formula that we just entered.

After carrying out all the operations, pay attention to the result of dividing the numbers 12 by 7, which is not an integer (1.714286) and contains quite a lot of digits after the decimal point. In most cases, such precision is not required, and such long numbers will only clutter the table.

To fix this, select the cell with the number for which you want to change the number of decimal places after the decimal point and on the tab home in Group Number select team Decrease bit depth. Each click on this button removes one character.

To the left of the team Decrease bit depth There is a button that performs the opposite operation - it increases the number of decimal places to display more accurate values.

Drawing up formulas

Now let's return to the budget table we created in the first part of this series.

At the moment, it records monthly personal expenses for specific items. For example, you can find out how much was spent on food in February or on car maintenance in March. But the total monthly expenses are not indicated here, although these indicators are the most important for many. Let's correct this situation by adding the line “Monthly expenses” at the bottom of the table and calculate its values.

To calculate the total expense for January in cell B7, you can write the following expression: “=18250+5100+6250+2500+3300” and press Enter, after which you will see the result of the calculation. This is an example of using a simple formula, the compilation of which is no different from calculations on a calculator. Unless the equal sign is placed at the beginning of the expression, and not at the end.

Now imagine that you made a mistake when indicating the values ​​of one or more expense items. In this case, you will have to adjust not only the data in the cells indicating expenses, but also the formula for calculating total expenses. Of course, this is very inconvenient and therefore in Excel, when creating formulas, not specific numerical values ​​are often used, but cell addresses and ranges.

With this in mind, let's change our formula for calculating total monthly expenses.

In cell B7, enter an equal sign (=) and... Instead of manually entering the value of cell B2, left-click on it. After this, a dotted highlight frame will appear around the cell, which indicates that its value is included in the formula. Now enter the “+” sign and click on cell B3. Next, do the same with cells B4, B5 and B6, and then press the ENTER key, after which the same amount value will appear as in the first case.

Select cell B7 again and look at the formula bar. It can be seen that instead of numbers - cell values, the formula contains their addresses. This is a very important point, since we just built a formula not from specific numbers, but from cell values ​​that can change over time. For example, if you now change the amount of expenses for purchasing things in January, then the entire monthly total expense will be recalculated automatically. Give it a try.

Now let's assume that you need to sum not five values, as in our example, but one hundred or two hundred. As you understand, using the above method of constructing formulas in this case is very inconvenient. In this case, it is better to use the special “AutoSum” button, which allows you to calculate the sum of several cells within one column or row. In Excel, you can calculate not only the sums of columns, but also rows, so we use it to calculate, for example, total food expenses for six months.

Place the cursor on an empty cell on the side of the desired line (in our case it is H2). Then click the button Sum on the bookmark home in Group Editing. Now, let's go back to the table and see what happened.

In the cell we selected, a formula appears with an interval of cells whose values ​​need to be summed. At the same time, the dotted highlight frame appeared again. Only this time it frames not just one cell, but the entire range of cells, the sum of which needs to be calculated.

Now let's look at the formula itself. As before, the equals sign comes first, but this time it is followed by function“SUM” is a predefined formula that will add the values ​​of the specified cells. Immediately after the function there are brackets located around the addresses of the cells whose values ​​​​need to be summed, called formula argument. Please note that the formula does not indicate all the addresses of the cells being summed, but only the first and last ones. The colon between them indicates that range cells from B2 to G2.

After pressing Enter, the result will appear in the selected cell, but that’s all the button can do Sum don't end. Click on the arrow next to it and a list will open containing functions for calculating average values ​​(Average), the number of data entered (Number), maximum (Maximum) and minimum (Minimum) values.

So, in our table we calculated the total expenses for January and the total expenses on food for six months. At the same time, they did this in two different ways - first using cell addresses in the formula, and then using functions and ranges. Now, it's time to finish the calculations for the remaining cells, calculating the total costs for the remaining months and expense items.

Autocomplete

To calculate the remaining amounts, we will use one remarkable feature of Excel, which is the ability to automate the process of filling cells with systematic data.

Sometimes in Excel you have to enter similar data of the same type in a certain sequence, for example, days of the week, dates, or row numbers. Remember, in the first part of this series, in the table header, we entered the name of the month in each column separately? In fact, it was completely unnecessary to enter this entire list manually, since the application can do it for you in many cases.

Let's erase all the month names in the header of our table, except for the first one. Now select the cell labeled “January” and move the mouse pointer to its lower right corner so that it takes the form of a cross called fill marker. Hold down the left mouse button and drag it to the right.

A tooltip will appear on the screen, telling you the value the program is about to insert into the next cell. In our case, this is “February”. As you move the marker down, it will change to the names of other months, which will help you figure out where to stop. Once the button is released, the list will populate automatically.

Of course, Excel does not always correctly “understand” how to fill in subsequent cells, since the sequences can be quite diverse. Let's imagine that we need to fill a line with even numeric values: 2, 4, 6, 8 and so on. If we enter the number “2” and try to move the autofill marker to the right, it turns out that the program offers to insert the value “2” again both in the next and in other cells.

In this case, the application needs to provide a little more data. To do this, in the next cell on the right, enter the number “4”. Now select both filled cells and again move the cursor to the lower right corner of the selection area so that it takes the form of a selection marker. Moving the marker down, we see that the program has now understood our sequence and is showing the required values ​​in the tooltips.

Thus, for complex sequences, before using autofill, you need to fill in several cells yourself so that Excel can correctly determine the general algorithm for calculating their values.

Now let's apply this useful program feature to our table, so that we can enter formulas manually for the remaining cells. First, select the cell with the amount already calculated (B7).

Now “hook” the cursor on the lower right corner of the square and drag the marker to the right to cell G7. After you release the key, the application itself will copy the formula into the marked cells, while automatically changing the addresses of the cells contained in the expression, substituting the correct values.

Moreover, if the marker is moved to the right, as in our case, or down, then the cells will be filled in ascending order, and to the left or up - in descending order.

There is also a way to fill a row using tape. Let's use it to calculate the cost amounts for all expense items (column H).

We select the range that should be filled, starting from the cell with the data already entered. Then on the tab home in Group Editing press the button Fill and select the filling direction.

Add rows, columns, and merge cells

To get more practice in writing formulas, let's expand our table and at the same time learn a few basic formatting operations. For example, let’s add income items to the expenditure side, and then calculate possible budget savings.

Let's assume that the revenue part of the table will be located on top of the expenditure part. To do this we will have to insert a few extra lines. As always, this can be done in two ways: using commands on the ribbon or in the context menu, which is faster and easier.

Right-click in any cell of the second row and select the command from the menu that opens Insert…, and then in the window - Add line.

After inserting a row, pay attention to the fact that by default it is inserted above the selected row and has the format (cell background color, size settings, text color, etc.) of the row located above it.

If you need to change the default formatting, immediately after pasting, click the button Add Options icon that automatically appears near the lower right corner of the selected cell and select the option you want.

Using a similar method, you can insert columns into the table that will be placed to the left of the selected one and individual cells.

By the way, if a row or column ends up in the wrong place after insertion, you can easily delete it. Right-click on any cell belonging to the object to be deleted and select the command from the menu that opens Delete. Finally, indicate what exactly you want to delete: a row, a column, or an individual cell.

On the ribbon, you can use the button for adding operations Insert located in the group Cells on the bookmark home, and to delete, the command of the same name in the same group.

In our case, we need to insert five new rows at the top of the table immediately after the header. To do this, you can repeat the adding operation several times, or you can, having completed it once, use the “F4” key, which repeats the most recent operation.

As a result, after inserting five horizontal rows into the top part of the table, we bring it to the following form:

We left the white unformatted rows in the table on purpose to separate the income, expenditure and total parts from each other by writing appropriate headings in them. But before we do that, we will learn one more operation in Excel - merging cells.

When several adjacent cells are combined, one is formed, which can occupy several columns or rows at once. In this case, the name of the merged cell becomes the address of the uppermost cell of the merged range. At any time, you can split a merged cell again, but you cannot split a cell that has never been merged.

When merging cells, only the data in the top left is saved, but the data in all other merged cells will be deleted. Remember this and do the merging first, and only then enter the information.

Let's return to our table. In order to write headings in white lines, we need only one cell, while now they consist of eight. Let's fix this. Select all eight cells of the second row of the table and on the tab home in Group Alignment click on the button Combine and place in the center.

After executing the command, all selected cells in the row will be combined into one large cell.

Next to the merge button there is an arrow, clicking on which will bring up a menu with additional commands that allow you to: merge cells without central alignment, merge entire groups of cells horizontally and vertically, and also cancel the merge.

After adding headers, as well as filling out the lines: salary, bonuses and monthly income, our table began to look like this:

Conclusion

In conclusion, let's calculate the last line of our table, using the knowledge gained in this article, the cell values ​​of which will be calculated using the following formula. In the first month, the balance will be the normal difference between the income received for the month and the total expenses in it. But in the second month we will add the balance of the first to this difference, since we are calculating savings. Calculations for subsequent months will be carried out according to the same scheme - savings for the previous period will be added to the current monthly balance.

Now let's translate these calculations into formulas that Excel can understand. For January (cell B14) the formula is very simple and will look like this: “=B5-B12”. But for cell C14 (February), the expression can be written in two different ways: “=(B5-B12)+(C5-C12)” or “=B14+C5-C12”. In the first case, we again calculate the balance of the previous month and then add the balance of the current month to it, and in the second, the already calculated result for the previous month is included in the formula. Of course, using the second option to construct the formula in our case is much preferable. After all, if you follow the logic of the first option, then in the expression for the March calculation there will already be 6 cell addresses, in April - 8, in May - 10, and so on, and when using the second option there will always be three of them.

To fill the remaining cells from D14 to G14, we will use the ability to fill them automatically, just as we did in the case of amounts.

By the way, to check the value of the final savings for June, located in cell G14, in cell H14 you can display the difference between the total amount of monthly income (H5) and monthly expenses (H12). As you understand, they should be equal.

As can be seen from the latest calculations, in formulas you can use not only the addresses of adjacent cells, but also any others, regardless of their location in the document or belonging to a particular table. Moreover, you have the right to link cells located on different sheets of the document and even in different books, but we will talk about this in the next publication.

And here is our final table with the calculations performed:

Now, if you wish, you can continue filling it out yourself, inserting both additional items of expenses or income (rows) and adding new months (columns).

In the next article we will talk in more detail about functions, understand the concept of relative and absolute links, be sure to master several more useful elements of table editing, and much more.

Microsoft Excel is convenient for creating tables and making calculations. A workspace is a set of cells that can be filled with data. Subsequently – format, use for building graphs, charts, summary reports.

Working in Excel with tables for novice users may seem difficult at first glance. It differs significantly from the principles of creating tables in Word. But we'll start small: by creating and formatting a table. And at the end of the article, you will already understand that you cannot imagine a better tool for creating tables than Excel.

How to Create a Table in Excel for Dummies

Working with tables in Excel for dummies is not rushed. You can create a table in different ways, and for specific purposes, each method has its own advantages. Therefore, first let’s visually assess the situation.

Take a close look at the spreadsheet worksheet:

This is a set of cells in columns and rows. Essentially a table. Columns are indicated in Latin letters. Lines are numbers. If we print this sheet, we will get a blank page. Without any boundaries.

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



How to select a column and row

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

To select a line, use the line name (by number).

To select several columns or rows, left-click on the name, hold and drag.

To select a column using hot keys, place the cursor in any cell of the desired column - press Ctrl + spacebar. To select a line – Shift + spacebar.

How to change cell borders

If the information does not fit when filling out the table, you need to change the cell borders:

To change the width of columns and height of rows at once in a certain range, select an area, increase 1 column/row (move manually) - the size of all selected columns and rows will automatically change.

Note. To return to the previous size, you can click the “Cancel” button or the hotkey combination CTRL+Z. But it works when you do it right away. Later it won't help.

To return the lines to their original boundaries, open the tool menu: “Home” - “Format” and select “Auto-fit line height”

This method is not relevant for columns. Click “Format” - “Default Width”. Let's remember this number. Select any cell in the column whose borders need to be “returned”. Again, “Format” - “Column Width” - enter the indicator specified by the program (usually 8.43 - the number of characters in the Calibri font with a size of 11 points). OK.

How to insert a column or row

Select the column/row to the right/below the place where you want to insert the new range. That is, the column will appear to the left of the selected cell. And the line is higher.

Right-click and select “Insert” from the drop-down menu (or press the hotkey combination CTRL+SHIFT+"=").

Mark the “column” and click OK.

Advice. To quickly insert a column, select the column in the desired location and press CTRL+SHIFT+"=".

All these skills will come in handy when creating a table in Excel. We will have to expand the boundaries, add rows/columns as we work.

Step-by-step creation of a table with formulas

Column and row borders will now be visible when printing.

Using the Font menu, you can format Excel table data as you would in Word.

Change, for example, the font size, make the header “bold”. You can center the text, assign hyphens, 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 and working with data).

Let's make a “smart” (dynamic) table:

Note. You can take a different path - first select a range of cells, and then click the “Table” button.

Now enter the necessary data into the finished frame. If you need an additional column, place the cursor in the cell designated for the name. Enter the name and press ENTER. The range will automatically expand.

If you need to increase the number of lines, hook it in the lower right corner to the autofill marker and drag it down.

How to work with a table in Excel

With the release of new versions of the program, working with tables in Excel has become more interesting and dynamic. When a smart table is formed on a sheet, the “Working with Tables” - “Design” tool becomes available.

Here we can give the table a name and change its size.

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

Features of dynamic MS Excel spreadsheets huge. Let's start with basic data entry and autofill skills:

If we click on the arrow to the right of each header subheading, we will get access to additional tools for working with table data.

Sometimes the user has to work with huge tables. To see the results, you need to scroll through more than one thousand lines. Deleting rows is not an option (the data will be needed later). But you can hide it. For this purpose, use numerical filters (picture above). Uncheck the boxes next to the values ​​that should be hidden.