Читать книгу Jump into Excel. Training Course from Beginner to Intermediate in two hours - - Страница 3

Let’s begin.

Imagine that a beginner who is completely unfamiliar with Excel is assigned a task: to prepare an Excel file with information about company’s employees.

At the same time, you need to use data both from the HR department and the secretary, and then save them on different sheets.

The final file should be a report table for printing with the following columns: Department, Position, Surname, First Name, Patronymic, Date of employment, Date of birth, Experience of full years on the date of the report, Age of full years on the date of the report. The table should be sorted by the employee’s surname.

So, let’s figure out step by step how to complete this Task.

To begin with, let’s choose a place or «Folder» on the computer where the Excel file we created will be stored, and also choose a name for them. For example, let’s create a «Task» folder on the Desktop, and in it we will create an Excel file with the name «Employees».

Note for beginners: if the desktop on the computer is not visible at the moment of work, for example, due to the fact that the screen is completely occupied by an open application, we will first open access to the desktop, and «minimize» all open windows of other applications. If we do not see the «Minimize all windows» button (its display depends on the computer settings) then hover the mouse cursor over the lowest part of the screen, a strip called the «Taskbar». Then right-click, and in the menu window that appears, left-click on «Show the desktop».

Hover the mouse cursor over the Taskbar, right-click, and in the menu window that appears, left-click on «Show the desktop».

All other windows with open applications will minimize and the Desktop will open to us.

So, let’s create a new folder.

Hover the mouse cursor over any free space on the Desktop and click the right mouse button. In the menu window that appears, hover the mouse cursor over «New», then hover over the «Folder» and click on the left mouse button.

Hover the mouse cursor over «New», then hover over the «Folder»

A folder with the highlighted name «New folder» appeared.

«New folder» appeared

At the moment of selecting the text in the folder, we change its current name «New folder» to our name «Task» by typing the text from the keyboard and pressing the «Enter» key.

Change its current name «New folder» to our name «Task»

If we later want to rename the «Task» folder to any other name, hover the mouse cursor over this folder and click the right mouse button, select «Rename»

Click the right mouse button, select «Rename»,

and type in the name we want,

and type in the name we want,

for example, «Folder». Then you can press «Enter».

Then you can press «Enter».

Return the name «Task» to the folder.

Now, open the created folder «Task».

To do this, hover the mouse cursor over the «Task» folder and click the right mouse button. In the menu window that appears, hover the cursor over «Open» and click on the left mouse button.

Hover the cursor over «Open»

An empty folder opens. Let’s create a Microsoft Excel file in it.

To do this, hover the mouse cursor over any free space in the open folder «Task» and click the right mouse button. In the menu window, select «New», and in the next menu window that opens, select «Microsoft Excel Worksheet».

select «Microsoft Excel Worksheet»

The file «Microsoft Excel Worksheet» appeared. We can straightaway rename it to our name «Employees». So, type in «Employees» from the keyboard, and press the «Enter» key on the keyboard.

rename it to our name «Employees»

In the same folder, we will copy the files with the initial information received from the HR department and from the secretary.

Let’s say these files were transferred to us on a flash drive or saved in a shared folder.

To copy files to the «Task» folder, first open a flash drive or a shared folder. In our case, this is a Transcend flash drive. In the folder that opens, right-click on the desired file and select «Copy».

right-click on the desired file and select «Copy»

Then go to our «Task» folder, right-click and select «Paste».

right-click and select «Paste»

Now we can see the file appeared. We will do the same with the second file. First copy and then paste it. Now all three files are in our «Task» folder: two with the initial information, and the third file created by us, «Employees», in which we will prepare the Results.

all three files are in our «Task» folder

Now let’s start filling out the created «Employees» file with information.

We can open the file «Employees» as we opened the folder: hover the mouse cursor, click the right mouse button and select «Open» from the menu. Or we can do it in another way: hover the mouse cursor over the file and double-click with the left mouse button. The file opens.