Microsoft Excel. - Extremely useful program in different fields. Ready table with the possibility of autofill, quick calculations and calculations, construction of graphs, charts, creating reports or analyzes, etc.

Tools of the table processor can greatly facilitate the work of specialists from many industries. The information below is the basics of work in Excel for dummies. Overtime this articleYou will acquire the basic skills from which any work in Excel begins.

Excel Instructions

The Excel book consists of sheets. The sheet is the work area in the window. His elements:

To add a value to the cell, click on it with the left mouse button. We enter the text or numbers from the keyboard. Click Enter.

Values \u200b\u200bcan be numeric, text, monetary, percentage, etc. To install / change the format, click on the location of the right mouse button, select "Cell format". Or press the combination of hot keys Ctrl + 1.

For numeric formats, you can assign the number of decimal signs.

Note. To quickly set the numeric format for the cell - press the CTRL + SHIFT + 1 hot key combination.

For Date and Time Formats, Excel offers several options for image values.

Edit the meaning of the cells:

To delete the cell value, the Delete button is used.

To move the cell with the value, select it, press the button with scissors ("Cut"). Or click the Ctrl + x combination. Around the cell appears dotted line. The selected fragment remains in the exchange buffer.

We put the cursor in another place of the work field and click "Insert" or a Ctrl + V combination.

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

To move several cells, they need to be allocated:

1. We put the cursor in the extreme top cell on the left.
2. Click Shift, hold and with the help of the arrows on the keyboard we achieve the allocation of the entire range.

To highlight the column, click on its name (Latin letter). To highlight the string - to the figure.

To change the size of the strings or columns, move the border (the cursor in this case takes the type of cross, whose transverse crossbar has at the ends of the arrow).

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

That it became more beautiful, the border of the column e slightly move, the text align in the center relative to the vertical and horizontal.

We combine several cells: select them and click the "Combine and Place in the Center" button.

Excel has an auto-complete function. We introduce the word "January" into the A2 cell. The program recognizes the date format - the remaining months will fill automatically.

We cling the right lower corner of the cell with the "January" value and pull on the line.

We test the autocomplete function in numeric values. We put in the cell A3 "1", in A4 - "2". We highlight two cells, "cling" the mouse to the autocillion marker and pull down.

If we allocate only one cell with a number and shifted it down, then this is the number "to multiply".

To copy the column to the neighbor, we highlight this column, "cling" the marker of autocillion and pull to the side.

In the same way, you can copy the lines.

We delete the column: select it - right-click - "Delete". Or by pressing the combination of hot keys: Ctrl + "-" (minus).

To insert a column, select the adjacent right (the column is always inserted on the left), press the right mouse button - "Paste" - "Column". Combination: Ctrl + Shift + "\u003d"

To insert a string, highlight the next bottom. Combination of the keys: SHIFT + Space To highlight the string and press the right mouse button - "insert" - "string" (Ctrl + Shift + "\u003d") (the string is always inserted from above).



How to work in Excel: Formulas and functions for teapots

In order for the program to perceive the information introduced into the cell as a formula, put the sign "\u003d". For example, \u003d (2 + 3) * 5. After clicking "Enter" Excel considers the result.

The sequence of calculation is the same as in mathematics.

The formula may contain not only numeric values, but also references to cells with values. For example, \u003d (A1 + B1) * 5, where A1 and B1 are references to cells.

To copy the formula to other cells, it is necessary to "hook" a marker of autofill in a cell with a formula and stretch down (to the side - if you copy in the line cells).

When copying formulas with relative references to excel cells Changes constants depending on the address of the current cell (column).

In each cell of the column with the second term in brackets - 3 (reference to the B1 cell is constant, unchanged).

Significantly expand the functionality of the program built-in functions. To insert a function, you need to press the FX button (or the SHIFT + F3 key combination). The type window opens:

In order not to flip a large list of functions, you must first select a category.

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

Functions recognize and numeric values \u200b\u200band links to cells. To put a link in the argument field, you need to click on the cell.

Excel recognizes another way to introduce a function. We put the "\u003d" sign into the cell and begin to enter the name of the function. After the first characters, the list will appear. possible options. If you bring the cursor to any of them, the hint will open.

Twice click in the desired function - the order of filling arguments becomes available. To complete the administration of arguments, you need to close the bracket and press ENTER.

Enter - program found square root From among 40.

The Excel program is one of the most powerful applications of the entire Office complex. She enjoys not only accountants and economists, but also ordinary people. The program is designed to work with numbers and tables, makes it possible to submit information to the most favorable for perception of the form: as diagrams and graphs. Here you can implement the most complex calculations and perform various mathematical operations. In addition, the user will not need special knowledge, it is enough to learn how to work in Excel.

What is this office application?

The Excel program works with files that form a certain book consisting of separate sheets. In the cells of the tables, letters, symbols and numbers are introduced. They can be copied, moved or deleted. If necessary, various operations are carried out with them: text, mathematical, logical and other. Newbies, who only learn how to work in the Excel program, should know that any information can be displayed in the form of graphs or diagrams.

How to create a file?

First you need to open a document. To create it, you need to click on the program label or go to the application through the "Start".

By default, the name "Book 1" is specified, but in the "File Name" line, you can enter any name. Working, it is worth periodically to save data to avoid loss of information in the event of a power failure or hang.

Between the sheets you can easily switch by pressing the appropriate inscription at the bottom of the page. If the tabs are very much, it is better to use the arrows on the keyboard. To insert a sheet, you need to find the item "Insert" in the "Home" menu. There will be all possible actions applicable to sheets, for example, add or delete. Also tabs can be moved.

"Face" of the program

Before you figure out how to work in Excel, it is worth studying the interface. Tools are located in the upper and lower part of the window, and the rest area occupy rectangles that are cells. The feature of the spreadsheet is that the actions can be performed in some cells, and the result is displayed in others.

Each table has columns that are denoted by the letters of the English alphabet. Rows are numbered on the left. Thus, any cell has its own coordinates. In each cell, you can enter both data and formulas. Before entering the latter, it is necessary to put the symbol "\u003d".

Each cell - its own characteristic

To understand how to learn how to work in Excel correctly, the user should know that before entering the values, you must specify the dimension of the column or cell. It will depend on what the data is measured. To do this, click on the right mouse button on the dedicated range and select "Cell Format" in the Dialog box.

If the number entered is greater than 999, it is necessary to establish a splitting. You do not need to enter spaces yourself.

For the correct data display, you cannot enter more than one separate value into one cell. Also, you should not enter the listings separated by commas or other characters. For each value there should be its own cell.

How to enter data?

Users who know will not be difficult to enter data. To do this, click on the cell and dial letters or numbers on the keyboard. To continue work, you must click "Enter" or Tav. The row rupture is carried out using the ALT + "input" combination.

When entering a month or number in order, it is enough to register a value in the initial cells, and then drag the marker to the required range.

Transfer text

Most often, users are interested in how to learn how to work in Excel with text. If necessary, it can be transferred according to words. To do this, select certain cells and in the Home tab you need to find the "Alignment" option, and then select "Transfer of Text".

If you need an automatic change in the width and height of the cell according to the text entered, the following must be followed: Go to the "Home" tab and in the "Cell" group to select "Format". Next you need to choose a suitable action.

Formatting

To format numbers, it is necessary to highlight the cell and in the Home tab, find the group "Number". After clicking on the arrow next to the "Shared" item, you can select the required format.

To change the font, you need to highlight a specific range and go to the "Home", "Font" menu.

How to create a table?

Knowledge about how to work in the Excel program is unlikely to be useful to the user if he does not know how to create a table. The easiest way is to highlight a specific range and mark the borders with black lines by clicking on the appropriate icon at the top of the page. But often a non-standard table for forms or documents is required.

First of all, it is necessary to determine how the table should look like to set the width and length of the cells. Having highlight the range, you need to go to the "Format of the Cell" menu and select the "Alignment" item. The option "Corging cells" will help remove extra boundaries. Then you need to go to the "Borders" menu and set the required parameters.

Using the "Cell Format" menu, you can create various options for tables by adding or removing columns and strings, as well as changing the boundaries.

Know how to work in excel TableThe user will be able to create headlines. To do this, in the "Formatting Table" window you need to check the checkbox opposite the "Table with headlines" item.

To add items in the table, you must use the Designer tab. You can select the required parameters.

What are macros for?

If the user has often to repeat the same actions in the program, it will be useful to knowledge about how macros work in Excel. They are programmed to perform actions in a specific sequence. The use of macros allows you to automate certain operations and facilitate monotonous operation. They can be recorded in various programming languages, but their essence does not change.

To create a macro in this application, you must log in to the "Service" menu, select Macro, and then click "Start Record". Next, you need to perform the actions that are often repeated, and after completing the work, click "Stop Record".

All these instructions will help the newcomer to figure out how to work in Excel: keep records, create reports and analyze numbers.

Microsoft. Office Excel Viewer - free tool for viewing spreadsheets in excel format. The program does not require the presence of Microsoft Excel in the system.

Immediately the start field, Microsoft Office. Excel Viewer will open the file view dialog box, however, the files can also be loosen by the mouse. The functionality of this utility is limited, and does not allow you to edit documents. All you can do is print the document, take advantage preview Before printing, copy the entire table or its plot to another application for working with spreadsheets, as well as use the search for the document.

It is possible to change page settings: orientation (book, landscape), scale, field values \u200b\u200band some others. You can print not only the entire table entirely, but also separate cells. To do this, it is necessary to allocate needed cells And click the "Print Area" button. Microsoft Office Excel Viewer has a ribbon interface similar to an Excel interface. The program is very easy to handle and will not select a lot of computer resources for your work.

Microsoft Excel 2010 is an indispensable tool that is needed to each user whose activities are inextricably linked with numbers, analytical calculations, databases, statistical data, and even with home accounting! Which is not surprising, since Excel 2010 has always been famous for its versatility, ease of use, as well as a wide functional and understandable interface.

Contrary to stereotypes, Excel 2010 is suitable not only for accounting. Early calculation algorithm, simple data, a lot of formulas and creating graphs is a necessary set for students of technical, mathematical and economic specialties. In addition, the program works great with all the well-known spreadsheet formats:

• xLSM;
• xLSX;

Detailed description and advantages of the program

Microsoft Excel 2010 is a whole set of solutions that includes a set of tools that allow producing mathematical (including financial) calculations. The program literally "out of the box" allows each user to carry out the most complex mathematical calculations, solving labor-intensive engineering tasks, as well as statistical analysis. The results can be obtained in a clear and user-friendly data table, which consists of separate cells (rectangles).

In addition, Excel 2010 allows you to make results more visual thanks to the addition of various graphs and diagrams, which are presented in a wide variety. The program interface has not received cardinal changes that users will please early versions BY.

Despite this, Excel version 2010 received a number of high-quality innovations and features:

• creation and combining several small databases;
• simple publication and further editing ready project on the Internet;
• filtering function that reduces the time to search and view the necessary tables and graphs;
• Power Pivot is a unique innovation that allows you to import data from any sources (at the same time, their management does not deteriorate);
• tight integration with other MS Office 2010 package programs;
• new graphs and chart templates, big choice Tools to change the visual display of pages and much more.

How to download for a computer?

Download Excel 2010 in Russian for Windows 10 is completely free on our website. Installation file. The programs are fully operational, does not contain damaged sectors / components, and most importantly - without viruses and without SMS (requiring payment).

Russian excel version 2010 is available for download on PCs that run under: Windows 7, Windows 8, Windows 8.1 and Windows 10.

Program Review

Computer version Microsoft Excel Viewer. Allows you to view and print files in XLS, XLSX, XLSM, XLSB, XLT, XLTX, XLM and XLW formats, and also has an intuitive and convenient user interface. But, mobile version All will allow not only to view documents, but also edit them and create new ones.

System requirements for computer

• System: Windows 10, Windows 8 (8.1), Windows XP, Vista or Windows 7 (32-bit / 64-bit).

System requirements for mobile device

• System: Android 4.4 and above | iOS 11.0 and higher.

Microsoft Excel Viewer Opportunities on Computer

View and copy
	View spreadsheets for without pre-installing paid software Product Microsoft Excel 2003 or 2007 version. However, if in XLSM, XLTM, XLM files contain macros, then Excel Viewer will not be able to execute them. Also, the XLC diagrams and documents in HTML format will not be able to open.
	Copy the contents of the tables in the clipboard.
Navigation
	Support multiple viewing modes (normal, page and markup mode).
	Switch between e-books or sheets.
	Normal and advanced search for information in the book.
	Change the orientation of the page with a book on the landscape (and on the contrary).
	Scaling pages from 10% to 400%.
Other
	Printing the entire book, selected area or certain rows and columns. You can also print several pages on one sheet.

Creating and processing tables
	Thanks to the Microsoft Excel application, you can decide both ordinary and complex tasks with large input data. You can build diagrams, graphs, sort the data in the tables, use various filters and much more.
Automatic saving
	You can not worry about the safety of data in spreadsheets. Information is automatically saved. You can also restore previous version Tables.
General access
	Thanks to support cloud storage (Dropbox, SharePoint, Box, Google Disc) You can access tables from any device (tablet, smartphone, computer) and no matter where you are now. You can also open general access to tables.
Joint work
	FROM using Microsoft. Excel can simultaneously view and edit the table by a group of people. For example, with colleagues at work.

Microsoft Excel Viewer 12.0.6424.1000 for Windows

• Added IRM service to protect confidential information. If the user is not right to copy and print a document, he will not be able to do it.
• Added Microsoft Authenticode technology to check the digital signature.

Microsoft Excel 16.0.11126.20063 for Android

• Improved application stability.

Microsoft Excel 2.20 for iPhone / iPad

• Fixed bugs.