Excel is included in the standard package of Microsoft Office 2010 and is used to work with PC users with spreadsheets.
I’ll try to answer the question about how to work in Excel. Using this program, we first create an Excel workbook consisting of several sheets. It can be created in two ways.
On the PC desktop, right-click in the context menu, select: "create a Microsoft Excel worksheet" or "open the program using the shortcut and create a new workbook."
The Excel program allows you to analyze data, tables and summary reports, do various mathematical calculations in a document by entering formulas, build professionally charts and graphs that allow you to analyze table data.
It is not so easy to briefly talk in a short article about how to work in Excel, what are the areas of application of the program, and for what 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 program interface , depending on the version. Version 2010 has a ribbon of tabs at the top. The first one is Home. Next, there are tabs for performing user tasks: "Insert", "Page Layout", "Formulas", "Data", "Review", "View" and "Add-ons". You must carefully familiarize yourself with the tools located in these tabs.
Pay attention to the Office button. It is intended for calling commands and is located in the program window, in the upper left.
Suppose we create a financial document where you can see the cash flow, income data, profit and loss calculation. Here it is possible to make a full analysis of financial activities. How to work in Excel to create such a document?
First, enter the digital data in the cells, which are combined in a table. To enter data into a cell, you must make it active. To do this, select it with a mouse click and enter the necessary information.
After filling in the entire field, we draw up the table by highlighting the entire workspace. In the right-click context menu, select the line "Cell format". Here we select the tool "Borders" and apply it.
Other commands for editing tables are available in this menu. How to work in Excel, you will learn the reference. Check them out yourself. Get and carefully study the tutorial, 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 can consolidate the theoretical knowledge gained and quickly master the principles of work in Excel.
Working with Excel Formulas
After filling out the tables for performing calculations in automatic mode (and Excel, in fact, is designed for this), you need to enter the necessary numbers and signs in the formula bar and in the cell itself. Working with formulas in Excel is one of the advantages of spreadsheets. Here you can perform any action: 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 line of formulas, and then the function arguments are written in parentheses, which are separated from each other 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 only need a desire to learn the rules to learn about how to work in Excel.