Đã hoàn thành

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:

[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

Kĩ năng: Excel

Xem nhiều hơn: 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, query excel sheet excel expert needed, excel expert hire, excel expert on hire, excel expert services for hire, excel expert sg hire, Hire an excel expert, hire excel expert, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i want an excel expert who works on my excel sheet according to my requirements, i want to hire an excel expert in the leesburg va area, where can i hire excel expert, all list of excel expert person indian

Về Bên Thuê:
( 43 nhận xét ) Briar Hill, Australia

ID dự án: #15008211

Được trao cho:

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 Thêm

$70 USD trong 3 ngày
(30 Đánh Giá)
5.0

14 freelancer đang chào giá trung bình $111 cho công việc này

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 Thêm

$100 USD trong 0 ngày
(242 Nhận xét)
7.4
$155 USD trong 3 ngày
(49 Nhận xét)
6.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 Thêm

$155 USD trong 3 ngày
(12 Nhận xét)
5.0
$50 USD trong 3 ngày
(6 Nhận xét)
4.1
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 trong 3 ngày
(6 Nhận xét)
3.4
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 Thêm

$155 USD trong 3 ngày
(1 Nhận xét)
1.1
$155 USD trong 3 ngày
(0 Nhận xét)
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 Thêm

$30 USD trong 3 ngày
(0 Nhận xét)
0.0
waqaramin

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

$88 USD trong 1 ngày
(0 Nhận xét)
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 Thêm

$30 USD trong 3 ngày
(0 Nhận xét)
0.0
$200 USD trong 10 ngày
(0 Nhận xét)
0.0
pjraymond

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

$105 USD trong 1 ngày
(0 Nhận xét)
0.0
jaspaldztmm

I will be happy to complete the project within given timeframe

$155 USD trong 3 ngày
(0 Nhận xét)
0.0