You've landed at the right place. oDesk is now Upwork. Learn about the new platform.

Microsoft Excel Powerpivot Jobs

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

show all
  • Hourly ({{ jobTypeController.getFacetCount("hourly") | number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("fixed") | number:0}})
show all
only
only
only
show all
only
only
only
only
only
show all
only
only
only
Looking for the Team App?
Download the New Upwork Team App
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
1. We want create a report that outputs 5 scenarios of investment returns based on different inputs 2. We may send the model to potential clients and allow them to input their own data - so it needs to look good and cells would need to be locked as below 3. We would enter numbers into a assumptions section of sheet 4. The calculations would be done based on assumptions 4. The 5 scenarios then displayed 5. The assumptions could be changes and new scenarios calculated as many times as necessary This is not very complicated and a spreadsheet showing how the calculations work, the assumptions inputs and the scenario outputs is attached.
Skills: Microsoft Excel PowerPivot Data Analytics Financial analysis Microsoft Excel
Hourly - Expert ($$$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
We are a DRTV ( Direct Response TV) specialist Company that have offices in Australia and the UK. We have 2 contact centres and we need to some reporting in place taking it from paper based excel reports that are manually filled in to moving into Google apps so we can streamline and automate the whole process. The workflow is 1. contact centre data entries their numbers into google form( matches the attached Daily Call tracking sheet) via link on their chrome browser 2.data goes into master spreadsheet - format already created but needs improvement 3. management 1 page summary created - format already created but needs improvement Ideally once updated I want subscribed people to receive email alert the doc has been updated Additional to this : - Staff database - keep all updated in place - staff roster document- format already created but needs improvement- need to have it so when we update it subscribed team members get the email notification The company has google apps email address , however there are 2 different companies so need to ensure we can share across drives as the reports need to go to . I need it to be simple enough that I can outsource it to a Virtual assistant to do daily if it cannot be completely automated from data entry. Ideal Candidate: - I need someone who has done this before and execute this quickly. - Excellent english is required - You must be able to to coach us and perhaps record a screen cast of the process once complete - you can make suggestions and introduce us to how to get more out of the google apps products and create efficiencies if this is successful then there could be ongoing work as the company currently uses Dropbox for file storage and I am keen to move it across to google apps once we are comfortable we can achieve what we need to as outlined above, Some testimonials would be useful and examples even better. I require a cover letter on why you are the best candidate and your resume . Resumes without cover letters will not be responded to.
Skills: Microsoft Excel PowerPivot Excel VBA Google Apps Google Docs
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I am currently looking for 3 expert and experienced freelance tutor only who can teach MS Excel like how to create Macros,professionally how to use in office and all to my USA/UK/Australia based students. How you teach online - Experience in Online field - At what time you can take class - Payment method - can you send me your excel syllabus that you teaches to your student along with course price - Need best price Email id/skype id -
  • Number of freelancers needed: 3
Skills: Microsoft Excel PowerPivot Excel VBA Microsoft Excel VBA
Fixed-Price - Intermediate ($$) - Est. Budget: $300 - Posted
If you are good in: 1) Data Analysis 2) Programming in VBA 3) Strong understanding & application of Excel formula 4) Familiar with basic accounting (cost & revenue) 5) Organizing data 6) Strong in logical thinking Then, you’re on the right track! We are looking for people who: • wants to explore their own talents • wants to be recognized for their work • have skills and not fully utilized • are driven out to make money • wants to acquire more knowledge • are workaholic • are not afraid to fail • are eager to upgrade your skill • are looking for full career advancement Skills required: ACCOUNTING & FINANCIAL ANALYSIS We are also looking for other skills like: • Data Analytics • Microsoft Excel VBA • Microsoft Excel PowerPivot
Skills: Microsoft Excel PowerPivot Accounting Data Analytics Excel VBA
Hourly - Entry Level ($) - Est. Time: More than 6 months, 30+ hrs/week - Posted
Job Title: Executive Assistant (from a reputable Philippine University) KEY DUTIES Reporting into our Virtual Assistance Manager. Your duties will be in aid of assisting the various departments including Customer Happiness, Operations, Marketing, Retail and Product in smooth operations. These include the ff: ● Actioning refund requests for customers across all channels (offline and online) on a daily basis ● Granting credits to customers on a daily basis ● Sending follow up emails to our customers as frequently as required regarding refunds, ETAs for their orders, credits, deliveries and updates as required by the company ● Stepping in to help the Customer Happiness team when workloads spike ● Placing bulk shoe orders for marketing, product and retail operational purposes ● Data entry ● Ad hoc duties Training will be provided, but the right candidate will have the critical awareness needed to do their duties in a timely manner with minimal supervision, reliability and accountability.
Skills: Microsoft Excel PowerPivot Administrative Support General Office Skills Microsoft Office
Fixed-Price - Intermediate ($$) - Est. Budget: $30 - Posted
Hello -- I am seeking someone to create an automatic report with Marcos and VLook Ups to analyze first an last touch attribution for my marketing spend. I would like to discuss this further -- please give me your experience creating a document like this, an example of such document and your skype information so that I can contact you and explain the job further. Thank you
Skills: Microsoft Excel PowerPivot Excel VBA IMacros Microsoft Excel
Hourly - Expert ($$$) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
Job Description I’m looking to hire an experienced Power BI and Excel Dashboard developer to help build an Executive Dashboard to report on Software Product Usage. I have a sample dataset which contains all of the required fields and I need help to format a dynamic Dashboard to help visualise the data for decision making. There are a number of “views” I have in mind including: 1. Executive Summary – Very High Level 2. Finance Summary – High Level 3. Procurement Summary – High Level 4. Operations Summary – Mid-High Level I need to be able to move tiles into different views depending on business requirements, but the information I’m looking to deliver via dashboard is: • Overall Software Spend • Software Spend by Operating System • Software Product over-utilisation by $ (non-compliant) • Software Product over-utilisation by Qty (non-compliant) • Software Product under-utilisation by $ (not value for purchase) • Software Product under-utilisation by Qty (not value for purchase) • Overall costs to bring business to compliance (based on over utilisation * price/products) • Capital costs to bring business to compliance (based on over utilisation * price/license) • Operational costs to bring business to compliance (based on over utilisation * price/license) • Total $ Spend by vendor • Top 5 Vendors by spend • Top 5 Vendors by compliance risk (based on overall costs to bring business to compliance) • Surplus software licenses by product • Surplus software licenses by Vendor • All of the Above to be available by timeline (Specific Month; trend/actual over 3, 6, or 12 months for example) • Contract information (free text) for quick review; including: o Contract Number o Contract Owner o Contract Record ID o Contract Start Date o Contract End Date o Contract Negotiation Lead Time o Key Contract Information (Free Text with multiple line items) These are initial criteria that I’d like to showcase but I am open to advice based on your reporting experience. The sample dataset may be incomplete in parts but is representative of the information that will be used to populate this dashboard. I am hoping that Dashboards in BOTH Power BI (Desktop) and Excel can be developed initially with similar views (and functionality where available). Power BI has not yet been deployed in my organisation and so an Excel version is required as an option, however a working dashboard in Power BI (Desktop) may demonstrate the power of this product, so I’m hoping this example will sway opinion. Note: Dashboard is not to be published to Microsoft Power BI. Candidate I’m looking for someone who is available immediately for ongoing work over the next 4 weeks. There will be updates and new versions required as we refine our reporting requirements and new data becomes available. Please consider and if interested, contact me with your availability, quote, and any portfolio examples you have available in support of your application will be well received. Thanks in advance, Glen
Skills: Microsoft Excel PowerPivot Data Visualization Microsoft Excel
Looking for the Team App?
Download the New Upwork Team App
Fixed Price Budget - ${{ job.amount.amount | number:0 }} to ${{ job.maxAmount.amount | number:0 }} Fixed-Price - Est. Budget: ${{ job.amount.amount | number:0 }} Open to Suggestion Hourly - Est. Time: {{ [job.duration, job.engagement].join(', ') }} - Posted
Skills: {{ skill.prettyName }}
Looking for the Team App?
Download the New Upwork Team App