Save this Search

All Jobspivot tables

 (4 results)  
Sort by:
  • Posted Date
Results for 'pivot tables'
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 21h, 33m ago  |  Ends: 14d, 2h  |   14 Proposals
I have been prototyping some custom Excel templates and charts with one of our clients. Although I'd like to stay away from it as far as possible, it seems that I will not be able to escape some VBA (1,000+ lines) in the templates that I provide to them. Their main characteristic is that I (heavily) apply pivot tables, and am trying to get PowerPivot and PowerQuery to work for me as well - which has its pros and cons. My customized charts involve Gantt charts and milestone charts, cover pages, data model indexes, etc. The VBA is working roughly as required. I now need to get it re-written in a much more dynamic, fast, robust, full-proof, bug-free, intuitive, error-trapping, junk-clearing, non-hardcoded manner. I expect the workbooks to be used by at least 10 different end users. And I need them to be robust, reliable, and informing the user of status, etc. I expect that we will be working together until the end of the year, but I also expect that we might be working together more on...
Category: Software Application       

Sign in to view client's details.
| d****bel
|    Norway
Hourly Rate: Not Sure   |  Duration: 3-4 weeks  |  Posted: Nov 23, 2015  |  Ends: 12d, 9h  |   14 Proposals
Hi , I need someone that knows VBA , how to automate process on windows, so for example. 1. pull data from access database 2.update pivot table and graphs in excel 3.generate outlook email and attached excel spreadsheet 4.update sharepoint with excel spreadsheet All of these steps need to be automated. I will like someone close to me ( new york, NYC or long island) Thank you
Category: Business Intelligence       

Sign in to view client's details.
| M****015
|    United States
Fixed Price: $30 or less   |  Posted: Nov 17, 2015  |  Ends: 5d, 19h  |   6 Proposals
I wrote part of the code but got stuck with one problem I want to count the unrepeated variables for each groups within a tabulate For example, I have Product Customer Time 1 A Morning 1 B Afternoon 1 A Evening 1 A Morning 2 B Morning 2 C Evening What I want to get is Morning Afternoon Evening All Product no of customer 1 1 1 1 2 2 1 0 1 2 like for product 1, one customer(A) bought it in the morning and two customer (A and B)bought it for all. There is another amount column which I already analysed with product and time, it would be great if the two pivot tables can be integrated.
Category: Data Analysis       
Skills: SAS, SAS Business Analytics       

Sign in to view client's details.
| c****may
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Nov 16, 2015  |  Ends: 79d, 11h  |   3 Proposals
Responsible for: - Assisting in the maintenance and monitoring of keyword bids, account daily and monthly budget caps, in tune with industry know how, optimization, quality score and other important account metrics. - Managing and maintaining updates for large keyword lists. - Providing creative copy suggestions. - Assisting in the management of display network placement lists on AdWords and through other contextual advertising platforms. - Providing recommendations and execute strategies for keyword opportunities, campaign structuring, targeting, display network, and other facets of paid search in accordance with the goals. - Providing support with the generation new paid search campaigns, ad groups, and accounts and aid in the creation of new paid search marketing initiatives. - Helping with media planning and buying. - Liaise with publishers, plan and strategize media schedules. - Generating tags for publishers via 3rd party tracking tools. - Troubleshooting creatives and tags if t...
Category: Search Engine Marketing       

Sign in to view client's details.
| o****ent *
|    Australia
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