Save this Search
     

All Jobspivot tables

 (5 results)  
Sort by:
  • Posted Date
Results for 'pivot tables'
Hourly Rate: $15 - $20 / hr   |  Duration: Not Sure  |  Posted: 20h, 17m ago  |  Ends: 14d, 3h  |   37 Proposals
I am looking for someone to to do monthly sales reports for our firm. The data comes in from 10 different manufacturers in both electronic and pdf forms. The data needs to be manipulated in to a standard format and then combined in to one data table. I am currently manually changing the customer names to a common format but this could conceivably be done with a vlookup. Once the data is updated I have several pivot tables that break the data out by sales person, territory, direct versus distribution and by product lines. The method I'm using works but I'm open to improvements. I am currently a year behind on entering data and need someone to catch up all of the data and then do the monthly reporting as it comes in. We will be paying off of this information so accuracy is essential and we will need to build in a double check to make sure the data is correct.
Category: Financial Reporting       
Skills: Data Entry, Microsoft Excel, Computer Skills       

S****int
 [?]
Sign in to view client's details.
| S****int
|    United States
Fixed Price: Not Sure   |  Posted: May 25, 2015  |  Ends: 13d, 16h  |   23 Proposals
I have a webscraper in place and I have excel spreadsheets of the data I need to be able to analyze. I need a template, macros or Pivot tables created so that I can run my own customer/sales reports throughout the month / yr. I'm not sure what would be the best approach to get this to happen. I'm looking for some 'best practice' suggestions as well. I'm not sure if I need a program to do this or if I can make it happen in excel.
Category: Data Analysis       

t****en4
 [?]
Sign in to view client's details.
| t****en4
|    United States
Fixed Price: Less than $500   |  Posted: May 23, 2015  |  Ends: 11d, 12h  |   22 Proposals
hello, I have a small company that sells drinks. Currently we use an excel spreadsheet to store the data and generate invoices. We have a range of 26 different products (12 drinks and 14 accessories) We have about 200 customers and about 1000 orders since we started. We currently use a macro to generate new invoices and use pivot tables to monitor payments received, outstandings, results... We are looking for a web-based solution that can be used by various users and with different permissions (read only, read/write...) We're looking for a simple and cheap solution that would allow us to create new customers, generate new invoices/orders check status of existing customers (previous orders, outstanding payment...)
Category: Software Application       

z****nis
 [?]
Sign in to view client's details.
| z****nis
|    United Kingdom
Fixed Price: Less than $500   |  Posted: May 20, 2015  |  Ends: 8d, 9h  |   21 Proposals
Dear all, very simple job I have this table : CASES: CaseID CaseDate CaseTypeID using pivoted table I need to generate following result in specific date range: please take a look at the picture to c the result
Category: Database Development       
Skills: Microsoft Access Administration       

e****ar1
 [?]
Sign in to view client's details.
| e****ar1
|    Saudi Arabia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 15, 2015  |  Ends: 3d, 10h  |   14 Proposals
Hands on accounting, reporting, and financial analysis role. Responsible for producing financial statements and supporting the month-end close process. Prepare management reports and support the budgeting and forecasting processes. Evaluate and implement policies and procedures, ensure adequate and effective internal controls and provide general business support to internal customers. Provide procurement and credit card administration and interface with external auditors and financial institutions. Excellent communications and problem-solving skills required. ? BA/BS in Accounting or Finance ? 1-3 years experience. Professional services industry experience preferred. Advanced Excel modeling skills including pivot tables, vlookup, etc. Advanced QuickBooks and/or Intaact preferred
Category: Accounting       
Preferred Location: United States

s****tz1
 [?]
Sign in to view client's details.
| s****tz1
|    United States
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job