Yuliia D.
Offer Yuliia work on your next project.
Rating
Skills and abilities
Outsourcing & consulting
Portfolio
-
Structuring the product database and classifying the assortment in Excel
Data ProcessingThe project involved organizing and classifying a huge database of clothing and footwear. The data was collected, verified, and divided into three independent, clear blocks: by brands, sizes, and specific clothing models. For each item, the quantitative status and percentage share were calculated. The work is perfect for online stores that need order in their assortment.
-
Analysis of sales structure and brand shares (Percentage summary
Data ProcessingA project aimed at creating a clear analytical report for sports brands. The table includes statistical calculations that allow for determining the exact volume of goods and the percentage share of each brand in the overall product range structure. The tool has been prepared to optimize purchases and analyze product popularity.
-
Inventory accounting and brand sorting in Excel
Data ProcessingThe project included the consolidation, filtering, and accounting of inventory balances of footwear from well-known brands (Nike, Puma, Adidas, etc.). The table implemented automatic totals (SUM function), categorization by batch numbers (LOT 1, LOT 4, LOT 5), and conditional formatting for instant detection of product shortages in the warehouse. The sheet was professionally prepared for convenient monitoring and sales reporting.
-
Creation of a product catalog with graphics and size chart in Ex
Data ProcessingA project that involves preparing a professional and readable catalog of the assortment (sports footwear) in Excel. The tasks included integrating product photos, matching articles, organizing stock balances, and detailed distribution according to the size chart. Everything is perfectly formatted for the convenience of sales managers.
-
Data entry and structuring of the product database in Excel
Data ProcessingAn example of a project that involves transferring, sorting, and structuring data about products (clothing, assortment, prices, weight) from source files into a clean Excel sheet. The task is completed with attention to filters, cell formatting, and the readability of the table for store managers.
Activity
| Latest proposals 1 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Processing graduation photos in Lightroom/Photoshop
85 USD
|