Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak

Serhii D.

Offer Serhii to work on your next project.

Ukraine Ukraine
7 hours 36 minutes ago
Available for hire available for hire
36 Safe completed
1 year ago
29 Clients
added 1 bid
registered for 2 years
  • Dashboard
  • DAX
  • Excel VBA
  • Google Sheets
  • Excel Power Pivot

Rating

Successful projects
100%
Average rating
There is no data
Rating
1101
Application programming
Data processing
8 projects
Databases
6 projects
Data processing
5 projects
Data parsing
4 projects
Application programming

Skills

Portfolio


  • The Power BI Dashboard

    Data processing
    Data analysis and the creation of a dashboard in Power BI. The data is uploaded through the API.
  • Graphics in Excel

    Data processing
    Just different graphics in Excel made by me ever for different projects, dashboards or just for learning purposes.
  • Excel program for storage accounting

    Application programming
    Excel-based program to account for the manual and electrical tools of a large construction company operating in the energy sector.
    The program allows you to track which tool, when and in what amount it was issued to the employee. Accounting of the written instrument. It allows you to quickly see where and what it is. Also, the program has the function of accounting certification and technical examination of special tools and informs the user of the approaching end date of the importance of such a certificate.
  • Excel Power Pivot data model

    Data processing
    From the database, tables are uploaded completely different in terms of information and structure. Power Pivot has created a data model, and a number of measures have been written in the DAX language. This allows different data structures to create a single common summary table and have all the important information in one report.
  • Excel Program for Product Accounting

    Application programming
    Excel-based program to account for the warehouse of a company that is engaged in making different types of wood packaging. Completed products are ordered in whole sets from the manufacturer (5 suppliers). Then in the warehouse everything is discompleted and different elements are sent to different contractors (about 15) for processing (sliping, painting, emblematization, etc.). Initially the report was in the register.

    The program allows you to account orders with the assignment of the party number. It then allows you to break the set into elements without losing the link to the party number. Watch what the contractor is and what is in the warehouse. Completion of delivery, complaint - all is also fixed in the program.

    All input data, as well as settings, are set by the user.
  • Excel program for painting

    Application programming
    The Excel-based program for painting the interior details of the car. The operator on the drawing of the data from the painting camera introduces in the base all the variants of painted details as well as the number of details that the robot collapsed and married. This is the way to monitor and analyze evacuations. The program allows you to generate several types of reports. Also, each detail shows the barcode that the operator scans and the data is entered into SAP. For convenience, each detail is displayed visually, all data is also entered by the operator on the sensor monitor.
  • Excel to recognize details

    Application programming
    In the manufacturing plant, the operator places the details for installation by scanning them in sequence in accordance with the customer's order. After scanning, the data is stored in the Excel file.

    The installation line operator, by extracting the details from the container, knows which components to be installed on that detail depending on the model.

    Due to the impossibility of hanging the monitor at the eye level in the app there is a voice recognition feature of the detail model. There is also the option of choosing the interface language.
  • Excel program for ordering materials from the warehouse

    Application programming
    Excel-based program for ordering materials from the warehouse in the manufacturing plant.The program is installed on different workstations in the manufacturing plant creating a whole network of such files.If it is necessary to fill in the necessary materials for production, the order from the file is sent via WI-FI to the ZEBRA mobile printer, which is located in the cabin of the wire chargers or at the warehouse worker.The paid label shows the logistics staff where, what and in what amount to deliver.The logistics department has one main file in which it manages the data, i.e. the link numbers, the attachment of goods to the department, the attachment of goods to the printer (some of them) on which the label should be printed, etc.All files are connected with each other via Power Query.Thanks to this, the logistics department can connect to all files at any time and download the data about all orders.Production in turn, in this way, connects to the main file, and after pressing the button "Update logistics data" immediately updates all data from the warehouse.
  • Excel for storing palettes in storage

    Application programming
    Excel-based program for a small palette storage. The program supports a screenshots scanner. When receiving the palette to the warehouse, it generates the palette number with a strip code with this number. Connect the palette to a specific location in the warehouse (automatically or manually). During the release of the palette from the warehouse removes it from the location. The receipt-transmission account of the European Palette. The stored data enables you at any time to withdraw any report, see the state of the stock and the status of all actions for the palettes that have been taken to the stock.

Reviews and compliments on completed projects 35

12 June 2023 24 USD
The work done

Quality
Professionalism
Price
Availability
Terms

It’s good, I’ve got it, and I’ll be.

14 March 2023 14 USD
Additional file settings

Quality
Professionalism
Price
Availability
Terms

Everything works! I will turn again.

27 February 2023 92 USD
Create 4 files from the main file

Quality
Professionalism
Price
Availability
Terms

Sergey knows his thing. professionally performed,

10 January 2023 36 USD
Excel - Data analysis task solution

Quality
Professionalism
Price
Availability
Terms

Very positive experience! I can recommend Sergey as an excellent data processing specialist in Excel.
The task was not trivial, the data is loaded from external sources, with complex logic, but it all got five with a plus!

Quality
Professionalism
Price
Availability
Terms

Everything is fine, thank you very quickly.

Quality
Professionalism
Price
Availability
Terms

A great executive. Fast introduction of the right. Everything is fast and clear. thank you.
I recommend cooperation.

8 February 2022 5 USD
From PDF to Google tables

Quality
Professionalism
Price
Availability
Terms

Excellently performed work. The most important thing is the lightning time.

4 February 2022 72 USD
Based on Excel

Quality
Professionalism
Price
Availability
Terms

Sergey did everything well, the project required some improvements because. In the process of checking I had new tasks in my head, which Sergey treated greatly and fulfilled my wishes. I recommend Sergey to perform such tasks.

22 January 2022 84 USD
Настроитъ автоматический отчет для гугл страницы (dynamic dashboard)

Quality
Professionalism
Price
Availability
Terms

A great specialist with great patience.
Everything in time and more than expected.

21 January 2022 7 USD
Create a diagram in Excel

Quality
Professionalism
Price
Availability
Terms

Everything was great, Sergey studied all the nuances and quickly completed the work!

17 January 2022 19 USD
Парсинг файла PDF

Quality
Professionalism
Price
Availability
Terms

Thank you, you did everything clearly, I didn’t even give the TK correctly, but you did everything smoothly and cool. Thank you

9 January 2022 8 USD
Удалить строки по стоп словам из списка в Notepad++ 2

Quality
Professionalism
Price
Availability
Terms

Everything is perfectly done! Thank you !

Quality
Professionalism
Price
Availability
Terms

Very pleased with cooperation. Rapid contact and quick execution of work

31 December 2021 10 USD
Formule of Measure

Quality
Professionalism
Price
Availability
Terms

The project was done very well and timely.

Quality
Professionalism
Price
Availability
Terms

Everything was done clearly, quickly, professionally. I am very pleased that I received answers to all the questions in a kind form, and reasonable advice and their implementation gave a great result!

Profile deleted | Safe Safe | Response feedback

Quality
Professionalism
Price
Availability
Terms

Everything went well, I'll be glad to work with Sergey.

14 December 2021 60 USD
Excel Project

Quality
Professionalism
Price
Availability
Terms

Great work!
He is a professional who knows his work 100%.
Thank you !

11 December 2021 14 USD
Conversion of Excel Document

Quality
Professionalism
Price
Availability
Terms

Qualitatively and in time.

Profile deleted | Safe Safe | Response feedback

10 December 2021 24 USD
PC Generator from Exel (Macros)

Quality
Professionalism
Price
Availability
Terms

Thank you ! satisfied with work. The project is carried out in accordance with our deadlines and all our wishes.

29 November 2021 12 USD
The PowerBI Project

Quality
Professionalism
Price
Availability
Terms

Everything is done quickly and quality. Sergey was able to do what other performers could not do. Thank you greatly! I recommend !

15 November 2021 14 USD
Автоматизация Ексель

Quality
Professionalism
Price
Availability
Terms

Задание выполнено в сроки согласно требований. Исполнитель предложил дополнительные варианты решения задачи. Рекомендую к сотрудничеству.

11 November 2021 7 USD
Optimization of Google Sheets Excel

Quality
Professionalism
Price
Availability
Terms

The task is performed in time and in accordance with the TZ. I recommend cooperation!

4 November 2021 8 USD
Task by Excel

Quality
Professionalism
Price
Availability
Terms

Excellent performers, they did everything quickly and very well! Just about Excel! I recommend it!!The !

Profile deleted | Safe Safe | Response feedback

14 October 2021 5 USD
Написать 3 формулы ВПР Excel — персональный проект для Сергія Дрюкова

Quality
Professionalism
Price
Availability
Terms

Самый быстро выполненный проект на фрилансханте) Рекомендую исполнителя: шарит

30 September 2021 5 USD
Create a drop-down list of Excel

Quality
Professionalism
Price
Availability
Terms

I am very pleased with the result of Sergey’s work in Excel.
This specialist took for a complex work that is solved by macros, which was not suitable for me as the document was planned to be used in the browser version.
In general, Sergey decided this with the help of multi-page formulas, all this time he carefully explained his steps and was really involved in the process with interest.

I recommend Sergey as a responsible executive!

27 September 2021 7 USD
Excel specialist for macro writing

Quality
Professionalism
Price
Availability
Terms

Switch and good. Pleased with the work and the result.

Quality
Professionalism
Price
Availability
Terms

I am pleased with the cooperation, of course.

11 September 2021 10 USD
Модифицировать формулу EXEL

Quality
Professionalism
Price
Availability
Terms

Оперативность выполнения заказа, отзывчивость и понимание ситуации, однозначно рекомендую к работе!

Profile deleted | Personal | Response feedback

9 September 2021 24 USD
Города превратить в район и просклонять (510 строк)

Quality
Professionalism
Price
Availability
Terms

Класс!! Большое спасибо за работу. Очень быстро и, что главное, качественно выполнено задание. Рекомендую.

8 September 2021 7 USD
Нужно просклонять 50 названий районов по трём падежам (на ру языке) — персональный проект для Сергія Дрюкова

Quality
Professionalism
Price
Availability
Terms

Все четко и быстро. Большое спасибо.

8 September 2021 8 USD
Selection of data from Excel

Quality
Professionalism
Price
Availability
Terms

Operational execution of the order, a literary approach, clarification of things not described in the TZ, I recommend to work!

Profile deleted | Safe Safe | Response feedback

Quality
Professionalism
Price
Availability
Terms

Everything is done quickly and efficiently, I recommend!!The !

3 September 2021 42 USD
Converter of Excel to VBA code

Quality
Professionalism
Price
Availability
Terms

Speed of performance and professionalism at a high level + responsibility, adequacy. I hope for further cooperation. A good evening. A great human thanks. Before the meeting.

Profile deleted | Safe Safe | Response feedback

Quality
Professionalism
Price
Availability
Terms

greatly ! Quick and quality written very necessary macros - now I'm happy!

Quality
Professionalism
Price
Availability
Terms

The project is done in time and satisfied with the work.

Activity

  Recent proposals 10
Data Analytics in Excel/Google Sheets
97 USD
Processing and transferring sales data to the map Personal project
72 USD
Data analytics in Excel/Google Sheets
97 USD
Systematize the database (duplicates, supplement from different sources)
72 USD
Creating a convenient database in Excel
121 USD
Create 3 Excel tables based on the provided examples
19 USD
Build a diagram in Microsoft Excel using the data in the table
12 USD
Getting data via API in Power Query for Power BI Personal project
12 USD
Reports from Power BI Personal project
84 USD
It is necessary to add columns to the xls without breaking the existing formulas
12 USD