Fermé

Excel Data & Stock Management - EPOS System (Clothing Retailer)

The job is an ongoing weekly role which includes the management of stock data and report production for a clothing retailer in the UK. Exceptional Microsoft Excel skills are required to manage data (often received in PDFs), sort and manipulate, create CSV import files for our cloud based Epos System ([login to view URL]).

Report formats have already been build in Excel, but knowledge of advanced Excel formulas (such as Table array formulas and Vlookup, etc) will be needed to manage the reports in excel.

Tasks will basically include:

1. Receiving product lists with barcodes from suppliers. Cross reference with existing product list, and if new, then creation of new products in Epos.

2. Receiving of invoices (in PDF) - extract data from PDF (possible use of Adobe Acrobat here?) to ensure correct stock levels are imported into Epos via CSV

3. Generation of commercial reports (for all 5 shops) using existing built excel files. This will need to be done after 6pm on a Sunday and is to be in inboxes of managers by 8am on Monday morning.

4. General maintenance of Epos Now and to ensure products are not corrupted (barcodes can sometimes become corrupt when importing CSV files)

5. Other day to day tasks which replace to stock management and Epos Now maintenance.

Skills:

* Microsoft Excel - Advanced

* Adobe Acrobat

* General knowledge and ability to learn use a cloud based EPOS system

Expected Hours/Week:

* 4 hours on a Sunday evening (early Monday morning)

* 5 hours spread across the week

(Example of Excel Commercial report attached WITH the PDF report that the excel doc generates)

Compétences : Excel, Traitement de Données, Saisie de Données

en voir plus : excel live stock data feed, project stock management system, bata shoe stores sales stock management system, stock management system phone shop using access, code stock management jewelery system, collecting data stock data google excel, create stock management system vb, data base management system projects code, event data base management system project, games projects data base management system, project management clothing retailer, project stock management system college computer lab, sample vb stock management system projects, screen shots data entery forms stock management system, stock management system excel macros, excel ecommerce stock management, rtd excel data stock, can excel data stock bse, simple stock management system excel, hello my data httptarekahmedlancerinfosamplesintroductionindexhtml i am ready to do the project you need samples of what i did b

Concernant l'employeur :
( 1 commentaire ) Birmingham, United Kingdom

Nº du projet : #20340183

41 freelance font une offre moyenne de £12/heure pour ce travail

Toperfection

Greetings! Dear sir,I am fully proficient in these given skills:- (1) Lead Generation; (2) Email Marketing; (3) Data Entry; (4) Data Mining; (5) Web Researching; (6) Linkedin Researching; (7) MS Office; (8) PDF to Exce Plus

£10 GBP / heure
(174 Commentaires)
7.9
editchamp

Hello There, I have been freelancing for 6+ years. I have strong experience in creating CSV files for CRM, Epos, Ecommerce website like WordPress, magento etc and I am also good experience with vlookup and PDF to e Plus

£10 GBP / heure
(216 Commentaires)
7.2
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Plus

£14 GBP / heure
(225 Commentaires)
6.9
HardWorker1989

Hello Sir. Many thanks for the opportunity as I have the perfect skills for the task you have mentioned and have excellent command over Excel, Adobe Acrobat and furthermore I have a Masters degree in Project Managemen Plus

£11 GBP / heure
(104 Commentaires)
7.0
dgled

I am a financial expert and guru in Excel/VBA/Macro. I have considerable experience working with Excel, especially with converting PDF files to Excel and fitting the converted contents into a structured database in Ex Plus

£15 GBP / heure
(81 Commentaires)
7.0
£15 GBP / heure
(35 Commentaires)
6.9
prameswara

Hello Sir Im excel VBA macro and formula Expert and im fulltime freelancer :) i can work very early like you need Sir please give me a chance for doing your project and im able to be your VA for doing weekly work Sir Plus

£10 GBP / heure
(373 Commentaires)
7.2
swatsgupts123

Sir, I do have excellent Excel knowledge and can handle this work on weekly basis including sunday. I saw the attached PDF and excel sheet but need to discuss few things. Please send me a message so that we can discuss Plus

£15 GBP / heure
(90 Commentaires)
6.7
rohitpithisaria

Hello I am an excel expert and have completed more than 100 projects in excel. I will send you a few samples of my past work for your kind perusal if required. I do provide excel consultancy to a lot of my clients an Plus

£15 GBP / heure
(119 Commentaires)
6.6
Venkat2011sri

Hello, This is Venkat. I am very much interested in working with you on this project. I will manage stock data and report production for a clothing retailer as per your instructions. I am looking for ongoing work. I h Plus

£10 GBP / heure
(182 Commentaires)
6.7
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Plus

£16 GBP / heure
(92 Commentaires)
6.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

£13 GBP / heure
(101 Commentaires)
6.1
sknadeem123

Hi There, i have strong experience in creating CSV files for CRM, Epos, Ecommerce website like WordPress, magento etc and i also good experience with vlookup and PDF to excel or CRM etc. i am also happy to do test wor Plus

£15 GBP / heure
(96 Commentaires)
6.4
younus15

I checked your PDF and Excel file. I can do your project in less than 4 hours according to your description (4 hours on a Sunday evening early Monday morning) with full delivery and without error. I would also complete Plus

£10 GBP / heure
(117 Commentaires)
5.9
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I have good knowledge about excel advance formulas,vba and also about the websites so can work perfectly on thi job. I have been in this indu Plus

£10 GBP / heure
(73 Commentaires)
6.1
branislavm

Hello! I can help you with these ongoing tasks - I am a full-time freelancer and we are in almost the same time zone (1 or 2 hours difference). I was working in various companies on administration for more than 20 yea Plus

£15 GBP / heure
(23 Commentaires)
5.6
TenStar718

Hello, and thanks for the opportunity to bid on your project. Please check my portfolio and reviews from other customers https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and Plus

£15 GBP / heure
(2 Commentaires)
5.1
mahisha123

Hi, I’ve gone through your requirement. I am very much interested to work with you on the project you mentioned in the freelancer. I do have expertise in the specified area. I can start the project right away and can c Plus

£10 GBP / heure
(32 Commentaires)
4.9
razvancotofana

Hi there, I have a sound experience in excel and VBA and I would like to be your selected remote VA for your data entry and processing job. Please feel free to contact me for any additional information. BR, Razvan

£10 GBP / heure
(14 Commentaires)
4.7
gsanggara

Hi There, I am interested to your project. I am an Excel expert and have a great experiences in Excel automation with formula and vba since my first career 15 years ago. I assured that you will be get high quality / hi Plus

£10 GBP / heure
(27 Commentaires)
4.2