Microsoft Excel Powerpivot Jobs

49 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
This job is to a large degree heavily routinized: exporting reports out of a web-based application to a series of Excel worksheets in an Excel workbook. But the reports would also benefit from additional SQL Server Analysis Services reporting, which we will explain how to do.
Skills: Microsoft Excel PowerPivot Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
Greetings, I'm swamped and I need a project budget budget template done in Excel for C level staff consumption (two to three year project). 75 to 50 budgetary line items to track (e.g., Fully Burdened Employee cost, capital expenditures such as hardware purchases, vendor costs, shipping, etc). Suggestions welcome. These need to be wrapped up in spend by month, quarter, and year over the two to three year period. It would need to have dynamic charts that update as fields are updated (second spreadsheet). It needs to be creative, to the point. The budget needs to fit on an 11 x 17 sheet (landscape) and the charting / graphing organized on a second 1 x 17 sheet. Screenshots of past advanced excel work required. Does not need to relevant. Preference will be given to those who have taken the EXCEL test on up-work and scored high. SEE JOB POSTING FOR RELATED OPEX SPREADSHEET THAT CAPTURES EXISTING OPEX COSTS. To be posted 9/29/2016. Thank you.
Skills: Microsoft Excel PowerPivot Business Development Excel VBA Financial analysis
Hourly - Entry Level ($) - Est. Time: 3 to 6 months, 10-30 hrs/week - Posted
I need an online marketing specialist who can help with: email marketing prospect list management marketing to trade associations, trade shows, industry groups, magazines, etc CRM Youtube channel Brochure creation Excel files, Presentations in Powerpoint Mailchimp and all Google products Coordinate with Webmaster, SEO freelancers to maximize use of both
Skills: Microsoft Excel PowerPivot CRM Email Handling Email Marketing
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
Hi! I have a sample data set containing time punch data of employees. Need to create measures to summarize timeliness and absenteeism. I have a fair idea of the dashboard required along with the metrics. This is an ongoing project and I would love to establish a stable working arrangement.
Skills: Microsoft Excel PowerPivot Microsoft Power BI
Hourly - Expert ($$$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
1- getting a couple of online sessions to take consultancies for some points in my company's power BI project. 2- the candidate should be able to solve this problem, and explain how: In the attached pbi file. The allCusttrans table (showing all transaction for all customers) is linked only with the HH_customer table (customers database). So, On page “dimitri” : I need to sum all the transactions that a customer made “after” the context filter. I made 2 measures: • One to get the last day of the context filter: [filter end date] = max(Date_Table[Date]) and assumed it will give the last date of the chosen month. Then I wrote: [after filter trx] = sumx( filter(allCusttrans , allCusttrans[Datez]>[filter end date]) , allCusttrans[Amount]) I need to get that sum for every customer. This worked fine for months: ( 4,5,8), BUT didn’t work for the other months (as the customer didn’t have transactions in those months so the system ignored all ) so if I am selecting month no 3, it gives no transactions while it should return the sum of all transactions after end of march. How can I fix that? https://dl.dropboxusercontent.com/u/4751690/newcustomers%20-dimitri.pbix
Skills: Microsoft Excel PowerPivot Microsoft Power BI
Hourly - Entry Level ($) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
I have to build a list of people for a certain initiative. I need them into Tier 1 and Tier 2 lists. I have the sources of data in multiple different places, with different formats and with different parts of their details. For example, I may have the full contact details in an email for one contact and a list of people on a powerpoint slide without any emails etc. for another few contacts. THe key thing is the names and emails. There would be an initial build of the list and then if you do a good job, i woul dkeep you on to do updates/enhancements as new contacts are identified that should be added. Also if they can get it out of a spreadsheet and into a format that can easily generate an email that wuold be a bonus and should be INCLUDED on the cover letter. Ready for this challenge? ;-)
Skills: Microsoft Excel PowerPivot Data Cleansing Data Entry mailchimp