Concluído

Hire an Excel Expert

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:

[url removed, login to view]

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

Habilidades: Excel

Veja mais: excel programmers for hire, excel freelancers, excel expert salary, excel experts online help, excel expert jobs, excel experts forum, excel expert online chat, excel expert tutorial, how to hire excel expert, hire excel expert tel aviv, hire excel expert for 2 hours, excel expert for hire in delhi, excel expert for hire, all list of excel expert person indian, where can i hire excel expert

Acerca do Empregador:
( 42 comentários ) Briar Hill, Australia

ID do Projeto: #15008211

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
(17 Comentários)
4.5

15 freelancers estão ofertando em média $114 para esse 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
(194 Comentários)
7.1
springdragon43m

I am confident that I can help you surely because i have good experience with this kind of project development before. I can start immediately. Let's discuss in detail Looking forward to hear from you Stay tuned, I'm Mais

$155 USD in 3 dias
(12 Comentários)
5.0
$155 USD in 3 dias
(9 Comentários)
4.2
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
(2 Comentários)
3.3
dongmei1993

Hi, I have many experience in Excel including Excel VBA, MACRO. I'll serve for you with high speed & good quality & low price. thanks. Relevant Skills and Experience Excel, data processing, vba, macro, mathematics Pr Mais

$155 USD in 2 dias
(1 Comentário)
2.6
$50 USD in 3 dias
(1 Comentário)
1.3
$155 USD in 3 dias
(0 Comentários)
0.0
Muhammadwaqas971

I am cost and management accountant having more than 5 years of work experience tasks like this is my routine job. I have all necessary skills, Tools and time to complete this task with in [login to view URL] Relevant Skills Mais

$30 USD in 3 dias
(0 Comentários)
0.0
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
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
(0 Comentários)
0.0
$200 USD in 10 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