Ditutup

Tables and Charts

I have an Excel Spreadsheet that I will be adding rows to every month. (this could also be imported into an access database) I would like to analyze and view this data in multiple ways. I am looking for someone who is a pro with Pivot tables and charts (unless you have a better solution). I would like some of the products grouped together. The items to be grouped together will be sent in a separate spreadsheet.

The spreadsheet consists of the following fields:

Product Number

Product Name

Customer Name

Sales Rep

Quantity

Extended Amount

Ways I would like to see the data:

1. By Product Group Overall

2. By Product Group Monthly

3. By Customer Group – By Product Group Overall

4. By Customer Group – By Product Group Monthly

5. By Sales Rep – By Product Group Overall

6. By Sales Rep – By Product Group Monthly

I would like charts by product – by quantity and by extended amount. I would like to be able to view one month against the next.

However this is developed, it has to be simple enough for me to manipulate after the initial creation. For example, if I want to add a product or customer to a group.

Please contact me via PM with questions/suggestions. I look forward to your replies.

Thank you.

Kemahiran: Pemprosesan Data, Excel, Visual Basic, XML

Lihat lebih lanjut: rep am, it sales rep, i am looking for sales rep, i am looking for a sales rep, excel card, view pro, pivot tables, manipulate , looking for a sales rep, excel charts, Data tables, customer spreadsheet, charts, analyze some data please, analyze some data for me, analyze some data 3, excel database visual basic, extended customer, visual basic database excel database, looking sales rep, charts excel, access excel creation, simple product grouped product, excel manipulate data, customer sales database access

Tentang Majikan:
( 0 ulasan ) Las Vegas, United States

ID Projek: #388063

27 pekerja bebas membida secara purata $86 untuk pekerjaan ini

SourceBest

Hi Please refer my PMB Regards

$130 USD dalam 3 hari
(4 Ulasan)
3.2
zszabo

Hello Pamela, I do a lot of same projects near daily for our planing department. This request a hear like from someone of my coleags. :) So the grouping the products, orders, sallers, etc. is very familiar in this d Lagi

$40 USD dalam sehari
(3 Ulasan)
2.2
danholo

Hi I could create an MS Access database for you, based on your spreadsheets. This will allow me to create the reports you need, in addition to allowing you to add more items as necessary. Feel free to contact Lagi

$200 USD dalam 5 hari
(2 Ulasan)
2.4
beststarsign

Please Check PMB for More details

$40 USD dalam 3 hari
(0 Ulasan)
0.0
MikeFlanagan

Hi Pamela I'm a professional information analyst, so this is the kind of task I carry out routinely. The task you describe sounds straightforward. What you really need to be sure of though, is that you your charts Lagi

$50 USD dalam 3 hari
(0 Ulasan)
0.0
jazzeem

i am ready to work with [url removed, login to view] me further details

$250 USD dalam 14 hari
(0 Ulasan)
0.0
bgvnick

Hello Pamela, like the other guy I am good in MS Excel and also in pivoting. Actally I'm not just good love to manipulate data with pivots. Please refer to PM for a suggestion. Best Regards, Nick

$50 USD dalam 2 hari
(0 Ulasan)
0.0
samdon2009

hi sir i am very good at Excel,I am ready to take up your challenge,and i promise to give good results.

$50 USD dalam sehari
(0 Ulasan)
0.0
maghazi

Good Day, Please check PM. Regards,

$100 USD dalam 2 hari
(0 Ulasan)
0.0
Ntronixs

I’m GURU for PHP, JAVA & Microsoft Technologies and 9+ Yrs experience in [url removed, login to view] from version 1.0 to 3.5. I’ll make sure/commit to give 100% Quality/Bug Free/1Week Free 24*7 Support in the agreed budget. I may take Lagi

$250 USD dalam 7 hari
(0 Ulasan)
0.0
kvcpk

Hi, I would like to bid on your project to create pivot tables or charts for your data. I have ample experience in working with Excel sheets. However, i am new to getafreelancer and hence looking for a break to show Lagi

$30 USD dalam 3 hari
(0 Ulasan)
0.0
mrinaljjoshi

Hi, Pls see my PM for details.

$40 USD dalam sehari
(0 Ulasan)
0.0
ranab4

easily done by access. let's start..

$50 USD dalam 3 hari
(0 Ulasan)
0.0
KKFreeLancer

I am an EXCEL / VBA Programmer. I'll do this for you. Cheers.

$50 USD dalam sehari
(0 Ulasan)
0.0
monis

hi i've 5years experience of vb6, access, sql, etc i have developed many project also using charts graphs [url removed, login to view] send u exe if u r interested i can give u more Better suggestions if u want pls contact.

$150 USD dalam 10 hari
(0 Ulasan)
0.0
bobby006

I can do this quickly with Excel or with Access. The choice is yours :) If you prefer Access I can make you form for easy input. Also data can be imported with macro/VBA code. With Access you can have a report for bett Lagi

$75 USD dalam sehari
(0 Ulasan)
0.0
Jasony

I am the master of Pivot tables. But you'll never know unless you try me.

$33 USD dalam 0 hari
(0 Ulasan)
0.0
avhijit11

Hi I am a professional WEB and WINDOWS application developer. I develop a lot of Website in ASP.NET. But for agreement purpose i can not give u the link here because this is an open area. I also develope a total bankin Lagi

$250 USD dalam 7 hari
(0 Ulasan)
0.0
friendshipman

I can do it easily.

$120 USD dalam 3 hari
(0 Ulasan)
0.0
snigdhasaha

Hello Sir, I am very interested to do the job. Waiting to hear a positive response. Best Regards

$50 USD dalam sehari
(1 Ulasan)
0.0