Hire an Excel Expert

Concluído Postado há 6 anos Pago na entrega
Concluído Pago na entrega

Hello,

I need some help from an excel whizz.

My bookkeeper has informed me that the following task is beyond his scope!! I need the formulas etc created to achieve the following:

***** Must be completed before 3pm AEST today

Objective:

Populate Worksheet 3 with a list of all current active products listing the product name, brand name, quantity of units sold from last financial year and

the current retail price.

Dummy excel sheet to see example:

[login to view URL]

Worksheet 1 - Current Active products

A1 - Name

B1 - Brand

C1 - Retail Price Inc GST

D1 - Stock Level

E1 - Date Added

Worksheet 2 - Unit sales for all products (including inactive) for last financial year

A1 - name

B1 - brand

C1 - orders

D1 - gross_revenue

E1 - qty_sold

Worksheet 3 (new master List) - Current Active products - new list with combined fetched data

A1 - Name

B1 - Brand

C1 - qty_sold

D1 - Retail Price Inc GST

Ideas on How:

Lookup W1 for product name A2

Find match in W2 for product name

Populate W3 with W1's respective product name, brand name, retail price & W2's unit sales.

STEP 2

----------

USE W4 (unit shipping costs)

A1 - brand name

B1 - unit shipping charge

Populate W3 (new column called shipping cost) matching ‘brand name’ from W4, brand from W3

Set so this price can be modified and any changes of 'unit shipping charge' are reflected / populated into master list W3 automatically

Excel

ID do Projeto: #15008211

Sobre o projeto

10 propostas Projeto remoto Ativo em há 6 anos

Concedido a:

daniyal3214

I posses expertise in using advance tools and functions of Excel to perform Financial Analysis, Financial Reporting, Financial Projections, Cash Flow Forecasting and Financial Modeling. Stay tuned, I'm still working Mais

$70 USD em 3 dias
(172 Comentários)
7.0

10 freelancers estão ofertando em média $102 nesse trabalho

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex Mais

$100 USD in 0 dias
(469 Comentários)
8.3
monettemejo27

I have great experienced on Excel both MS and Googlesheets Relevant Skills and Experience data entry Proposed Milestones $111 USD - 3 days

$111 USD in 3 dias
(10 Comentários)
3.8
sabeehajiffry4

Hello sir, it is my great honor to apply for this vacant job. Relevant Skills and Experience . I have excellent skills in Data Entry, Copy pasting, Web Research and Microsoft Office, Microsoft Excel and I have enough Mais

$155 USD in 3 dias
(13 Comentários)
2.8
waqaramin

I have a strong knowledge of excel and reporting Relevant Skills and Experience Ms office expert

$88 USD em 1 dia
(0 Comentários)
0.0
ashikrayhan000

Dear Clint, I read your project description. I'm understanding your requirement for this job. I've more than 3 years experience in related field. I've experience in Data entry, Internet Research, Relevant Skills a Mais

$30 USD in 3 dias
(0 Comentários)
0.0
pjraymond

Can solve this with 1-2 formulas. In excel every day with my job.

$105 USD em 1 dia
(0 Comentários)
0.0
jaspaldztmm

I will be happy to complete the project within given timeframe

$155 USD in 3 dias
(0 Comentários)
0.0