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, excel card, view pro, pivot tables, manipulate, excel charts, data tables, customer spreadsheet, charts, excel database visual basic, extended customer, looking sales rep, charts excel, access excel creation, excel manipulate data, customer sales database access, excel xml database, monthly database access, grouped, grouped product, excel data tables, customer spreadsheet example, looking rep products, customer contact spreadsheet, access sales contact

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

ID Projek: #388063

28 pekerja bebas membida secara purata $84 untuk pekerjaan ini

SourceBest

Hi Please refer my PMB Regards

$130 USD dalam 3 hari
(2 Ulasan)
2.9
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
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
KKFreeLancer

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

$50 USD dalam sehari
(0 Ulasan)
0.0
ranab4

easily done by access. let's start..

$50 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 you.send 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
edatacollection

Please see PM

$30 USD dalam 20 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 ASP.NET/C# 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
monis

hi i've 5years experience of vb6, access, sql, etc i have developed many project also using charts graphs etc.can 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
beststarsign

Please Check PMB for More details

$40 USD dalam 3 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