href="#image47_65b53585f908710007af2903_jpg.jpeg"/>error: second row with Borshchev’s and Ivanov’s data
To avoid this error, we will perform preliminary data processing – we will put the rows on the «Result» sheet in the same alphabetical order as they are sorted on the «Information from HR» sheet. So that the line with the surname «Borshchev» on the «Result» sheet would become the second, immediately under the header, as well as on the «Information from HR» sheet. After that, we will be able to copy the columns from the «Information from HR» sheet to the «Result» sheet, and Borshchev’s data will be copied to the row with Borshchev, and not with Ivanov.
Let’s use Sorting for this.
Sort operation
Select the area for sorting (columns A:E or cells A1:E26), click on the «Sort» button on the «Data» tab, select «Sort by…", «Surname», in the window that appears, select the alphabetical sorting order «From A to Z», and click «Ok».
select «Sort by – Surname»
Please note: If we wanted to sort the names of Departments in alphabetical order, and then within these departments by Surname, we would first select «Sort by – Department», and then add a second level of sorting by clicking on «Add Level» in the upper left corner of the menu, and in the second level that appeared we would select «Surname».
first select «Sort by – Department», then by «Surname»
After the sorting is done, the order of the rows with surnames on the «Result» sheet matches the order of the rows on the «Information from HR» sheet.
Note: Sorting (and much more) can also be done using the menu that appears when you right-click. Using the right mouse button to open the menu is a very useful skill that speeds up your work in Excel.
Copy the data from the «Information from HR» sheet to transfer to the «Result» sheet.
Select three columns on the «Information from HR» sheet: «Full name», «Date of employment» and «Date of birth». We don’t need the Full name column for the task, but we use it to make sure that the rows with the surnames of employees after sorting now match everywhere.
rows with the surnames of employees after sorting match everywhere
After visual verification that the order of the rows is correct (that is, the last name from column «F» with the full name coincided with the last name from column «C»), the extra column «F» with the Full name must be deleted.
Deleting a column
Select column F by hovering the mouse cursor over the heading F and click the left mouse button. Then click on the right mouse button. In the menu that appears, select «Delete».
select «Delete»
Thus, all the original data has been transferred to the «Result» sheet.
Сreating a new column
Let’s create the columns «Experience of full years on the date of the report» and «Age of full years on the date of the report» ourselves.
Конец ознакомительного фрагмента.
Текст предоставлен ООО «Литрес».
Прочитайте эту книгу целиком, купив полную легальную версию на Литрес.
Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.
