Đang Thực Hiện

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

Kỹ năng: Excel

Xem thêm: 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

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

Mã Dự Án: #15008211

Đã 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
(17 Đánh Giá)
4.5

15 freelancer đang chào giá trung bình $114 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
(194 Đánh Giá)
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 Thêm

$155 USD trong 3 ngày
(12 Đánh Giá)
5.0
$155 USD trong 3 ngày
(9 Đánh Giá)
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 trong 3 ngày
(2 Đánh Giá)
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 Thêm

$155 USD trong 2 ngày
(1 Đánh Giá)
2.6
$50 USD trong 3 ngày
(1 Đánh Giá)
1.3
$155 USD trong 3 ngày
(0 Đánh Giá)
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 [url removed, login to view] Relevant Skills Thêm

$30 USD trong 3 ngày
(0 Đánh Giá)
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 Giá)
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 Giá)
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 Thêm

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0
$200 USD trong 10 ngày
(0 Đánh Giá)
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 Giá)
0.0
jaspaldztmm

I will be happy to complete the project within given timeframe

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0