Excel online tutorial, smart table. How I took online Excel lessons

Many analytical works and projects are being created. Therefore, the question of how to use Excel is relevant in our time. Using the editor you can:

1. Work with data in Excel.
2. Create tables and graphs.
3. Make calculations.
4. Analyze final values.

How to start a table processor?

To start using Excel, you need the following: go to the Start menu, then select All programs, then Microsoft Office, Excel. This option is suitable for office versions no earlier than 2003. For others: Start, All Programs, then Microsoft Excel. Third option: Start, Run, write Excel, press Enter.

General appearance and main functions

Excel is " workbook", consisting of "sheets" on which are the columns and rows that form the table. You can select a cell that has its own unique address to enter information by clicking on it with the left mouse button. Having created a table with data, you can decorate its borders with different lines, and also change the color of the cells in the “Format Cells” window. Based on the data you enter into the table, you can create a chart or graph to visualize the results. By using table processor Various calculations are also carried out, statistical data or simply any current information is displayed. For each cell, you can set its own format in accordance with the type of input data, for example:

Worksheets can be renamed, deleted, or added. Data can be cut, pasted, copied, including using the fill marker (with the data and “drag” it further along the row or column, thereby filling it according to a given pattern). For beginner users of Excel, there is a user manual from Microsoft.

Working with formulas and diagrams in Excel

The Excel spreadsheet processor is ideal for making calculations. For those who are just starting to learn how to work with Excel, there are usually no particular difficulties. To indicate the beginning of the calculation in the table, you need to put the “=” sign, otherwise the entered formula will not be accepted by the system. Working in a processor involves the use of built-in formulas. To use a value, you must select the cell that contains it.

Charts are created to visually display information or totals. There are:

1. Histograms.
2. Spot.

To build, you need to select the table and open the “Diagram Wizard”, with which you can create and edit it. In Office 2007, this process occurs by selecting a chart type on the User Interface ribbon.

Excel - powerful processor, allowing you to work with text values tables and their visual display in the form of graphs and diagrams, as well as carry out calculations. - means having access to a multifunctional tool that is suitable for solving professional problems, as well as for current user calculations.

Microsoft Excel– extremely useful program in different 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. Leaf – work area in the 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. Appears around the cell dotted line. 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, “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 next to it below. 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 copying to row cells).

When copying a formula from relative links on Excel cells changes 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 unchangeable).

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 will appear possible options. If you hover your cursor over any of them, a tooltip will appear.

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

ENTER – program found square root from the number 40.

Excel is a spreadsheet program that allows you to store, organize, and analyze information. In this lesson, you'll learn some ways to work with the Excel 2010 environment, including the new fly-out menu that replaces the Microsoft Excel 2007 menu button.

We'll show you how to use and modify the Ribbon and Panel quick access, as well as how to create a new book and open an existing one. After this lesson, you will be ready to start working on your first book in Excel program.

Introducing Excel 2010

The Excel 2010 interface is very similar to the Excel 2007 interface. However, there are some differences, which we will look at in this tutorial. However, if you are new to the Excel environment, it will take you some time to learn how to navigate Excel.

Excel program interface

1) Quick access panel

The Quick Access Toolbar gives you access to some of the commands you need, no matter what tab you're currently on. By default, the Save, Cancel, and Redo commands are shown. You can add commands to make the panel more user-friendly.

2)Field Name

The Name field displays the position or "name" of the selected cell. In the image below, cell B4 appears in the Name field. Notice that cell B4 is at the intersection of column B and row 4.

3) String

A row is a group of cells that runs from the left edge of the page to the right. IN Excel rows are indicated by numbers. In the figure below, line 16 is selected.

4) Formula bar

In the formula bar, you can enter and edit information, formulas, or functions that appear in a specific cell. In the image below, cell C1 is selected and the number 1984 is entered in the formula bar. Please note that the information is displayed in both the formula bar and cell C1.

5) Sheets

By default, a new workbook contains 3 sheets. You can rename, add or delete sheets.

6) Horizontal scroll bar

You may have more data than can fit on the screen. Click and hold the horizontal scroll bar and move it left or right, depending on what part of the page you want to see.

7) Column

A column is a group of cells that runs from the top of the page to the bottom. IN Excel columns are indicated by letters. In the image below, column K is selected.

8) Page view

There are three ways to display a spreadsheet. To select one of them, you need to click on the page view buttons.

• Ordinary– selected by default, shows you an unlimited number of cells and columns. Highlighted in the picture below.
• Page layout splits the spreadsheet into pages.
• Page lets you see general view spreadsheet, which is useful when you add page breaks.

9) Scale

Click and drag the slider to change the scale. The number displayed to the left of the slider indicates the zoom level in percentage.

10) Tape

The Ribbon contains all the commands you might need to perform common tasks. It contains several tabs, each of which has several groups of commands. You can add your own tabs with your favorite commands. In the lower right corner of some groups there is an arrow, clicking on which will show you even more commands.

Working in Excel environment

The Ribbon and Quick Access Toolbar are where you'll find the commands you need to perform common tasks in Excel. If you're familiar with Excel 2007, you'll see that the main difference in the Excel 2010 Ribbon is the placement of commands like Open and Print in the pop-up menu.

Ribbon

The ribbon contains several tabs, each with several groups of commands. You can add your own tabs with your favorite commands.

To customize the Feed:

You can customize the Ribbon by creating your own tabs with the commands you need. Teams are always located in a group. You can create as many groups as you need. Moreover, you can add commands to the default tabs as long as you create a group for them.

If you can't find the command you need, click the Select commands drop-down list and select All commands.

To collapse and expand the Feed:

The feed is designed to quickly respond to your current tasks and be easy to use. However, you can minimize it if it takes up too much screen space.

1. Click on the arrow on the right top corner Ribbons to roll it up.
2. To expand the Ribbon, click on the arrow again.

When the ribbon is minimized, you can show it temporarily by clicking on a tab. However, the tape will disappear again when you stop using it.

Quick Access Toolbar

The Quick Access Toolbar is located above the Ribbon and gives you access to some useful commands no matter what tab you're currently on. By default, the Save, Cancel, and Redo commands are shown. You can add commands to make the panel more user-friendly.

To add commands to the Quick Access Toolbar:

1. Click the arrow on the right side of the Quick Access Toolbar.
2. From the list that appears, select the commands you want to add. To select commands that are not listed, click More commands.

Popup menu

The pop-up menu gives you various options to save, open files, print or sharing documents. It is similar to the Office Button menu in Excel 2007 or the File menu in earlier versions of Excel. However, now it is not just a menu, but a full-page view that is much easier to work with.

To get to the pop-up menu:

1) Basic commands

2) Details

Details contains information about the current book. You can view and change its permissions.

3) Latest

For convenience, the last books you worked with are shown here.

4) Create

From here, you can create a new blank workbook or choose a layout from a large selection of templates.

5) Print

In the Print panel, you can change print settings and print your book. You can also preview how the printed book will look.

7) Help

From here you access Microsoft Office Help or Check for Updates.

8) Parameters

Here you can change various Excel options. For example, you can change your spell check, auto-recover, or language settings.

Creating and opening books

Excel files are called workbooks. Each workbook contains one or more sheets (also known as “spreadsheets”).

To create a new book:

1. Select New.
2. Select New book in the Available templates section. It is highlighted by default.
3. Click Create. The new workbook appears in the Excel window.

To save time, you can create a document from a template, which you can select from Available templates. But we'll talk about this in the next lessons.

To open an existing workbook:

1. Click on the File tab. This will open a pop-up menu.
2. Select Open. The Open Document dialog box appears.
3. Select the book you want and click Open.

If you recently opened an existing workbook, it might be easier to find it under Latest in the pop-up menu.

Compatibility Mode

Sometimes you will need to work with workbooks created in earlier Microsoft versions Excel, such as Excel 2003 or Excel 2000. When you open these workbooks, they appear in compatibility mode.

Compatibility mode disables some features, so you can only use the commands that were available when you created the book. For example, if you open a workbook created in Excel 2003, you can use the tabs and commands that were in Excel 2003.

In the picture below, the workbook is opened in compatibility mode.

To get out of compatibility mode you need to change the book format to current version. However, if you work with people who work with more earlier versions Excel, it is better to leave the workbook in Compatibility Mode and not change the format.

To convert a workbook:

If you want to have access to all the features of Excel 2010, you can convert your workbook to Excel format 2010.

Please note that converting a file may cause some changes to the original file.

1. Click the File tab to open a pop-up menu.
2. Select the Convert command.
3. Then press OK twice.

1. The book will be converted to a new format.

Practice!

1. Open Excel 2010 on your computer and create a new, blank workbook.
2. Roll and unfold the tape.
3. Go through all the tabs and notice how the ribbon options change.
4. Try changing the appearance of the pages.
5. Add any commands to the Quick Access Toolbar.
6. Close Excel without saving the workbook.

Working with Excel: tutorial. Excel (Excel) is one of basic programs Microsoft package Office. This indispensable assistant when working with invoices, reports, tables.
Excel allows you to:
program, store huge amounts of information
Build graphs and analyze results
Make calculations quickly
This program is an excellent choice for office work.
Getting started with Excel (Excel)
1. Double-click on the sheet name to enter editing mode. In this panel, you can add a new sheet to the book or delete an unnecessary one. This is easy to do - you need to right-click and select the “Delete” line.

2. It’s easy to create another book - select the “Create” line in the “File” menu. The new book will be placed on top of the old one, and an additional tab will appear on the taskbar.

Thanks to tabular form data views, tables automatically turn into a database. It is customary to format tables; to do this, select the cells and give them individual properties and format.

A simple F=ma is the formula, force equals mass times acceleration.

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

After this, you can create your first spreadsheet with tables, graphs, mathematical formulas and formatting.

Detailed information about the basic functions and capabilities of the table processor.

Description of the main elements of the document and instructions for working with them in our material.

By the way, to work more efficiently with Excel tables, you can familiarize yourself with our material.

Working with cells. Filling and formatting

Before taking specific actions, you need to understand the basic element of any .

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 a cell, just click on it with the pointer and enter necessary information.

To edit a previously filled cell, click on it double click mice.

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 cell “Share of shares”. Its location address is A3. This information is indicated in the properties panel that opens. We can also see the content.

This cell 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 cells and its basic 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.

It’s already in front of you (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

will happen automatic sorting data:

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 Excel editor can be found on the official Microsoft website.

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 with three or a large number cells, just continue entering the argument values ​​in the fields “Number 3”, “Number 4” and so on.

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 control system in the editor personal budget, list of expenses, digital data for reporting, etc.

They have an advantage over a similar option in 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 “ Pivot table»;
• 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.