Using excel. How to work in Excel. Basic techniques and functions - basics from Excel courses. Add rows, columns, and merge cells

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 hotkeys, place the cursor in any cell of the desired column - press Ctrl + spacebar. To select a line – Shift + space.

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.

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. Step by step

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.

Video on the topic: Excel for beginners

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 hotkeys, place the cursor in any cell of the desired column - press Ctrl + spacebar. To select a line – Shift + space.

Video on the topic: TOP 15 best Excel tricks

How to change cell borders

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

• Move manually by clicking the cell border with the left mouse button.

• When a long word is written in a cell, double-click on the column/row border. The program will automatically expand the boundaries.

• If you need to maintain the column width but increase the row height, use the “Wrap Text” button on the toolbar.

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

• We manually fill out the header - the names of the columns. We enter the data and fill out the lines. We immediately put the acquired knowledge into practice - we expand the boundaries of the columns, “select” the height for the rows.

• To fill out the “Cost” column, place the cursor in the first cell. We write “=”. Thus, we signal the Excel program: there will be a formula here. Select cell B2 (with the first price). Enter the multiplication sign (*). Select cell C2 (with quantity). Press ENTER.

• When we move the cursor to a cell with a formula, a cross will form in the lower right corner. It points to the autocomplete marker. We grab it with the left mouse button and drag it to the end of the column. The formula will be copied to all cells.

• Let's mark the boundaries of our table. Select the range with the data. Click the button: “Home” - “Borders” (on the main page in the “Font” menu). And select “All borders”.

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:

• Go to the “Insert” tab - “Table” tool (or press the hotkey combination CTRL+T).

• In the dialog box that opens, specify the range for the data. Please note that the table has subheadings. Click OK. It's okay if you don't guess the range right away. The “smart table” is mobile and dynamic.

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:

• Select a cell by left-clicking on it. Enter a text/numeric value. Press ENTER. If you need to change the value, place the cursor in the same cell again and enter new data.
• When you enter duplicate values, Excel will recognize them. Just type a few characters on the keyboard and press Enter.

• To apply a formula to an entire column in a smart table, just enter it in the first cell of that column. The program will copy to other cells automatically.

• To calculate the totals, select the column with the values ​​plus an empty cell for the future total and press the “Sum” button (the “Editing” tool group on the “Home” tab or press the hotkey combination ALT+"=").

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.

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 a range 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.

The Microsoft Office Excel program is a table editor in which it is convenient to work with them in every possible way. Here you can also set formulas for basic and complex calculations, create graphs and diagrams, program, creating real platforms for organizations, simplifying the work of an accountant, secretary and other departments dealing with databases.

How to learn to work in excel on your own

The excel 2010 tutorial describes in detail the program interface and all the features available to it. To start working independently in Excel, you need to navigate the program interface, understand the taskbar where commands and tools are located. To do this, you need to watch a lesson on this topic.

At the very top of Excel we see a ribbon of tabs with thematic sets of commands. If you move the mouse cursor over each of them, a tooltip appears detailing the direction of action.

Under the tab ribbon there is a “Name” line, where the name of the active element is written, and a “Formula line”, which displays formulas or text. When performing calculations, the “Name” line is converted into a drop-down list with a default set of functions. You just need to select the required option.

Most of the excel window is occupied by the work area, where tables, graphs are actually built, and calculations are made. . Here the user performs any necessary actions, using commands from the tab ribbon.

At the bottom of excel on the left side you can switch between workspaces. Additional sheets are added here if it is necessary to create different documents in one file. In the lower right corner there are commands responsible for convenient viewing of the created document. You can select the workbook viewing mode by clicking on one of the three icons, and also change the scale of the document by changing the position of the slider.

Basic Concepts

The first thing we see when opening the program is a blank sheet, divided into cells that represent the intersection of columns and rows. The columns are designated by Latin letters, and the rows by numbers. It is with their help that tables of any complexity are created and the necessary calculations are carried out in them.

Any video lesson on the Internet describes creating tables in Excel 2010 in two ways:

To work with tables, several types of data are used, the main of which are:

• text,
• numerical,
• formula.

By default, text data is aligned to the left of cells, and numeric and formula data is aligned to the right.

To enter the desired formula into a cell, you need to start with the equal sign, and then by clicking on the cells and putting the required signs between the values ​​​​in them, we get the answer. You can also use the drop-down list with functions located in the upper left corner. They are recorded in the “Formula Bar”. It can be viewed by making a cell with a similar calculation active.

VBA to excel

The programming language built into the Visual Basic for Applications (VBA) application makes it easier to work with complex data sets or repetitive functions in Excel. Programming instructions can be downloaded on the Internet for free.

In Microsoft Office Excel 2010, VBA is disabled by default. In order to enable it, you need to select “Options” in the “File” tab on the left panel. In the dialog box that appears, on the left, click “Customize Ribbon”, and then on the right side of the window, check the box next to “Developer” so that such a tab appears in Excel.

When starting to program, you need to understand that an object in Excel is a sheet, workbook, cell and range. They obey each other, so they are in a hierarchy.

Application plays a leading role . Next come Workbooks, Worksheets, Range. Thus, you need to specify the entire hierarchy path to access a specific cell.

Another important concept is properties. These are the characteristics of objects. For Range it is Value or Formula.

Methods represent specific commands. They are separated from the object by a dot in VBA code. Often when programming in Excel, the Cells (1,1) command is needed. Select. In other words, you need to select a cell with coordinates (1,1), that is, A 1.

This program is used by a large number of people. Andrey Sukhov decided to record a series of training video lessons “Microsoft Excel for Beginners” for novice users and we invite you to familiarize yourself with the basics of this program.

Lesson 1. Overview of the interface (window appearance) of Excel

In the first lesson, Andrey will talk about the Excel interface and its main elements. You will also understand the working area of ​​the program, with columns, rows and cells. So, the first video:

Lesson 2: How to Enter Data into an Excel Spreadsheet

In the second video tutorial on the basics of Microsoft Excel, we will learn how to enter data into a spreadsheet and also get acquainted with the AutoFill operation. I think the most effective training is one that is built on practical examples. So you and I will begin to create a spreadsheet that will help us manage the family budget. Based on this example, we will consider the tools of the Microsoft Excel program. So, the second video:

Lesson 3: How to Format Spreadsheet Cells in Excel

In the third video lesson on the basics of Microsoft Excel, we will learn how to align the contents of the cells of our spreadsheet, as well as change the width of the columns and the height of the rows of the table. Next, we will get acquainted with Microsoft Excel tools that allow you to merge table cells, as well as change the direction of text in cells if necessary. So, the third video:

Lesson 4. How to format text in Excel

In the fourth video tutorial on the basics of Microsoft Excel, we will become familiar with text formatting operations. For different elements of our table we will use different fonts, different font sizes and text styles. We will also change the text color and set a colored background for some cells. At the end of the lesson we will receive an almost finished family budget form. So, the fourth video:

Lesson 5. How to design a table in Excel

In the fifth video lesson on the basics of Microsoft Excel, we will finally format the family budget form, which we started working on in previous lessons. In this tutorial we will talk about cell borders. We will set different borders for different columns and rows of our table. By the end of the lesson, we will receive a family budget form completely ready for data entry. So, the fifth video:

Lesson 6. How to use data format in Excel

In the sixth video lesson on the basics of Microsoft Excel, we will fill out our family budget form with data. Microsoft Excel allows you to simplify the data entry process as much as possible, and we will get acquainted with these capabilities. Next, I will talk about data formats in cells and how they can be changed. By the end of the lesson, we will receive a family budget form filled out with initial data. So, the sixth video:

Lesson 7. How to make calculations using Excel tables

In the seventh video lesson on the basics of Microsoft Excel, we will talk about the most interesting thing - formulas and calculations. Microsoft Excel has very powerful tools for performing various calculations. We'll learn how to perform basic calculations using spreadsheets, then get acquainted with the Function Wizard, which greatly simplifies the process of creating formulas for calculations. So, the seventh video:

Lesson 8. Designing a document in Excel

In the eighth video lesson on the basics of Microsoft Excel, we will completely finish working on the family budget form. We will compose all the necessary formulas and carry out the final formatting of rows and columns. The family budget form will be ready and if you maintain your own family budget, you will be able to adjust it to your expenses and income. So, the eighth video:

Lesson 9. How to build charts and graphs in Excel

In the final ninth lesson on the basics of Microsoft Excel, we will learn how to create charts and graphs. Microsoft Excel has a very impressive toolkit for visualizing calculation results. You can present any data, either simply entered into a spreadsheet or data obtained as a result of calculations, in the form of graphs, charts and histograms. So, the final ninth video: