How to work in Excel 2010

The Excel application is included in the standard Microsoft Office 2010 package and serves as the user of a PC with spreadsheets.

I'll try to answer the question about how to work in Excel. With this program, we first create an Excel workbook consisting of several sheets. It can be created in two ways.

On the desktop of the PC, right-click in the context menu to select: "create a Microsoft Excel worksheet" or "open the program using a shortcut and create a new workbook."

Excel program allows you to analyze data, tables and summary reports, do various mathematical calculations in the document by entering formulas, build professionally diagrams and graphs that allow you to analyze the data of tables.

It's not so easy to briefly describe in a short article how to work in Excel, what are the areas of application of the program, for which formulas are needed. But let's start in order.

Before you open a book that contains empty cells. Before you start working with them, carefully study the interface of the program , depending on the version. Version 2010 has a tabbed strip at the top. The first of them is "Home". Then there are tabs for performing user tasks: Insert, Page Layout, Formulas, Data, Review, View and Add-ons. You should carefully familiarize yourself with the tools that are located in these tabs.

Notice the Office button. It is designed to invoke commands and is located in the program window, upper left.

Suppose we create a financial document, where you can see the movement of cash, income data, the calculation of profits and losses. There is an opportunity to make a full analysis of financial activities. How to work in Excel to create such a document?

First, we introduce digital data into cells, which we combine into a table. To enter data into a cell, you need to make it active. To do this, select it with a mouse click and enter the desired information.

After filling the entire field, we form the table by selecting the entire working area. In the right-click menu, select the line "Format Cell". Here we select the "Borders" tool and apply it.

Other commands for editing tables are available in this menu. How to work in Excel, you will learn the directory. Read them yourself. Acquire and carefully study the self-instruction manual, which details the principles of how to work in Excel 2010. Choose a reference book with assignments, since a theory without practice is ineffective. Performing tasks, you will be able to consolidate your theoretical knowledge and quickly learn the principles of working in Excel.

Working with Excel formulas

After processing the tables for the calculation in automatic mode (and Excel, in fact, is designed for this), you need to enter the desired numbers and signs into the formula line and into the cell itself. Working with formulas in Excel is one of the advantages of spreadsheets. Here you can perform any actions: addition, subtraction, multiplication, division, extraction of square roots, calculation of functions and logarithms; You can find the sum of numbers and the arithmetic mean.

The formula is preceded by an equal sign, which is placed in the formula line, and then the arguments of the function are written in parentheses, separated by a semicolon.

For a more in-depth study of the principles of work in this program, you need to take special courses. And for starters, you just need to learn the rules that allow you to learn how to work in Excel.