ISO Excell Expert

$10-30 USD

Dokončeno

Zveřejněno

před více než 5 roky

$10-30 USD

Zaplaceno při doručení

I have this clerking sheet that i have been using, and i have tried using pivot tables, but i can not get the information to show like i need it to. the line # is the number we assign the the item won (col a), consignor (column B) bid and qty, then who it was sold to. i want to consolidate buyers purchases. for example in the sheet attached, frank bought more that on thing, and i would like that to show up in a table, telling me what frank bought, with a total amount due. I would also like a consignors report of what consignor sold what. My next "want" for this sheet... is i have an area at the top of clerk sheet where i enter the data, for current item being bid on. i fill it out hit enter, and it populates below and keeps a running tab of everything i enter. I've spent a few weeks trying to figure it out and i fold. i have an example sheet of what data i need drawn into groups

Excel

Excel Macros

Excel VBA

IČ projektu: 17578802

O projektu

6 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@haleem0786

i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please contact with me for [login to view URL]

$40 USD v 1 dni

4,9

(15 recenze)

3,6

6 freelanceři nabízejí v průměru $31 USD za tuto práci

@afenache

Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.

$55 USD v 1 dni

5,0

(14 recenze)

4,1

@otweyo

Hello, I have despicable past experience and excellent work record with regards to making dashboards in PowerBI, Tableau, Sisence and other BI Tools. I have developed several Dashboards and I am ready to show some past samples that I developed. I have excellent time management skills and I am ready to negotiate to accept a lower price. Kindly reply my request. Thank you

$25 USD v 1 dni

0,0

(0 recenze)

0,0

@jdtcj5

I have been working with excel for the past 12+ years in a corporate environment. I am quick, reliable, and have an ability to communicate data well to the end user. I am known for creating user friendly excel reports, and tight, concise, efficient returns of data.

$27 USD v 1 dni