Ditutup

Build a Microsoft Excel Model - Product Reconciliation

Job Description:

Note - I will only look at submissions that answer the specific requirements below. I am expecting this to be initially 2 days work - probably with more after if the work is satisfactory:

Background - I need a model built in excel that allows me to reconcile between two excel files. The source data is regularly being updated, so I need the model to be formula driven to identify any issues that arise from these updates or to cater for adding additional products.

This will require advanced excel skills.

For your submission:

I have attached an excel file with two sheets. The "Master" tab shows the quantity and SKU Lookup Ref required for every instance of the Bundle Lookup Ref on the "Data" tab.

To show you are capable and understand what is required, please submit an excel file showing which rows on the data tab do not match the required Qty and SKU Lookup Ref from the Master tab (based on the Bundle Lookup Ref).

It is late here so I will check responses in 12-18 hours from posting this job

Kemahiran: Excel, Pemprosesan Data, Data Analytics, Data Analysis

Tentang Klien:
( 3 ulasan ) Kew East, Australia

ID Projek: #35274886

51 pekerja bebas membida secara purata $20/jam untuk pekerjaan ini

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Lagi

$20 AUD / jam
(538 Ulasan)
8.4
TonmoyRoy111

Dear client, "Everything is correct in the Master Tab when compared to Data tab in terms of quantity and SKU Lookup Ref I have sound knowledge in Excel and I have previously carried out a number of projects in excel u Lagi

$25 AUD / jam
(500 Ulasan)
7.5
daniyal3214

Hello, I will be glad to assist you with that. I am an experienced Financial & Business Analyst and Excel expert holding years of experience in Data Analysis, Data Visualization, Financial & Business Analysis. Lets dis Lagi

$15 AUD / jam
(197 Ulasan)
7.1
suyashdhoot

Hi I am a very experienced statistician, data scientist and business analyst. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation ski Lagi

$50 AUD / jam
(97 Ulasan)
7.0
Devrits

Hey! I am skilled Data Entry programmer with skills including Data Processing, Data Analysis, Excel and Data Analytics. I have read your all given information in description and i am ready to do various type of work fo Lagi

$15 AUD / jam
(70 Ulasan)
6.3
PERPETUAL0

Hello there Iam excel and VBA EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do yo Lagi

$20 AUD / jam
(207 Ulasan)
6.2
hamidr2020

Hello, (Please check below the answer to the specific requirement) I am an Advanced Level Excel and VBA/Macro expert. I offer my services to build a formula driven Excel Model that allows to reconcile between two excel Lagi

$20 AUD / jam
(78 Ulasan)
6.0
merinsinha

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom Lagi

$20 AUD / jam
(145 Ulasan)
5.7
bdrudra

Hello, I hope you're doing really well. We are reviewing your requirements and we can do this work. We are a team of highly skilled individuals having 8+ years of experience in the IT Industry. We have worked with Mi Lagi

$20 AUD / jam
(13 Ulasan)
5.9
obadiakipkemoi

Hello there, I will help with project on Build a Microsoft Excel Model - Product Reconciliation.I have read the instructions carefully and I clearly understand what is required of the project. I have handled several as Lagi

$17 AUD / jam
(20 Ulasan)
5.3
rabbiawebjuggler

Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!

$15 AUD / jam
(28 Ulasan)
5.1
Ahsan2526

Hey, I have prepared a demo sheet for you. Please send me a message so we can discuss further. Thanking You

$20 AUD / jam
(50 Ulasan)
4.8
ismail80196

Hi, I gone through your project description " Build a Microsoft Excel Model " I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about it. I am ready to start work right Lagi

$20 AUD / jam
(9 Ulasan)
3.4
ammarqureshi5999

Hi, I have more than 10 years of experience in professional consultancy regarding Microsoft Excel and Power Bi. I am an expert in formulating scenarios, logic, and criteria outputs based on user requirements. I am als Lagi

$20 AUD / jam
(4 Ulasan)
2.3
mwajidsabir786

I there, I am professional Data Entry and excle Expert. I have 3+ years experience in data analysis.I am see your attachments. I will doing your work perfectly with 100% accuracy. Please come in private chat and let's Lagi

$20 AUD / jam
(1 Ulasan)
1.9
doctorkashaf

I will do this task for you. . I have been freelancing since many years. I have completed more than 150 projects successfully. I know professional content writing as well as Coursework writing. I have an experience in Lagi

$15 AUD / jam
(1 Ulasan)
1.8
enervell

Hello, I found the ROWS with errors, and I have the excel to show you, this excel also updates everytime you chage the values, so if there are more errors it shows you, and if you correct the information you will get t Lagi

$20 AUD / jam
(1 Ulasan)
0.8
mohitsharmaoaf7

Hi! I specialize in Excel Certificated in BBD. My priority is to achieve the clients´goals and I have the necessary knowledge to do so. I´m very interested in your project. Regards,

$20 AUD / jam
(0 Ulasan)
0.0
belal09101980

If you need any kind of Data Entry, Copy Paste, Data Collection, Web Research, Web Scraping and Product Listing project on your time with 100% accuracy. Here we can do all type of Data Entry work. We have a strong and Lagi

$20 AUD / jam
(0 Ulasan)
0.0
vishalweb179

Hi, I am expert in excel and can make functionality with my knowledge as you want to reconcile between two file so can we discuss on personal chat for further scope of work. Regards Vishal Kumar

$16 AUD / jam
(0 Ulasan)
0.0