Microsoft Excel Powerpivot Jobs

58 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 - Expert ($$$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
Hi, I need someone expert with vba excel codes in order to modify the meny (menu Excel) also, I have dynamic charts with formula and want to transfer that to a mirror where the user will acces only numbers and buttons to rlate the data I'm a teacher and want to offer to my students the results online, without tehe menu who malkes possible alter or save the data by them, also, not exposing the formula. I have the solution to put my works online by excel, only that I cant preserve the formulas and possible saving the works outside. So, simple task: 1. dont expose the normal excel menu, only "open" function 2. all internal active plans in hide mode, protected by individual passwords 3. active external plan in mirror mode, where user can use all roll buttons to access the data, bat cant modyfy (saving) anything and cant-se nother than the results (with preserved forms, exactly like original presents) In Brazil we named that level as "papaya with sugar", for who knows, its very easy to make. Can You help me solve that? I atach a simple example above the definitive works are more complex, but the logic is ever the same... any doubts contact me please thanks
Skills: Microsoft Excel PowerPivot Excel VBA Microsoft Excel VBA
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I would like to mimic this spreadsheet into a user friendly format that has macros to develop invoices and proposals into different tabs of the spreadsheet. I would also like to have this spreadsheet be imbedded into an online documentation format such as google docs so I can send the link to our prospects and have each of them fill out a blank spreadsheet as needed. I need this project done within a by Monday of next week. Please let me know if you can assit me with this matter. I have a template that can be emailed to you
Skills: Microsoft Excel PowerPivot Excel VBA Google Docs Mac OS App Development
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
Hi I am an ice pop company and we have a number of recipes that we make. Looking at cleaning up our recipes and systems and having a good excel spreadsheet to: 1. Calculate quantities for batches depending on the number required. It will also show the amount for one, and calculate cost per pop for both ingredients and labour. At the moment we have 16 regular recipes and a number of bespoke flavours. 2. Ideally if we could also link the sales forecast and stock on hand so that it produces a list of what we need to produce, as well as a "shopping list" (from various suppliers and to be able to add the amount of same ingredients in different recipes) and calculate the number of hours of labour 3. It would also be great to have the method for each recipe underneath or easily accessible I already have a basic sales/ production forecast as well as recipes in excel based on things that I have made before, but it all just needs to be cleaned up and linked together. There is also the added complication of using raw ingredients - for example a recipe might call for 4L of lemon juice, but need to be able to approximately account for how many lemons or it might need 4L of coconut cream but how many cans does that require. Ideally I would also like to be able to track how long it takes to do certain tasks (i.e. juice 4kg lemons) and so we can calculate labour costs better. At the moment we work in batches of 12 moulds / 336 pops / about 24L although as we expand this will change. Once created, I would also like to be able to add another recipe that will link in easily. Thanks!
Skills: Microsoft Excel PowerPivot Excel VBA Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $1,000 - Posted
Looking for an experienced Excel guru who can set up over 40 quantitative models Each model is a linear equation with approx. 90-100 variables each. The equation has to be applied to over 1mm rows. At least 10-12 lookups (vlookups) need to be performed to for each equation We will provide detailed specifications and clarifications for 12 hours daily - from 8am to 8pm We need this completed in a 2 day period.
Skills: Microsoft Excel PowerPivot Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
Seeking an individual who is skilled with excel and data analytics for some market research. Need input and your ideas to help understand data better. Data is list of customers with many attributes including structured data scoring etc. This will be periodic work but needs fast turnaround. Not looking for cheapest but instead a partner who can add value. Expected output example will be follows: > Data buckets > Graphing > Averages, Mean , Median and Group Frequencies > Standard Deviations (some not all data requires it) > Combination analysis/Cross Tabs The data will be de-identified but you will still be required to sign a non-disclosure document. Please bid on an hourly rate. I'm happy to process weekly. Just please do not bid if you cannot be responsive (meaning within 48 hours or so) Thanks - Please cite a project and include results that you think fit this work scope. I will award to first qualified and valid candidate. Expect this to be active work cycle for upwards of one year. Expect 10 to 30 hours a month. Thanks
Skills: Microsoft Excel PowerPivot Financial Reporting Microsoft Excel
Hourly - Expert ($$$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I'm looking for some BI, data analysis freelancers with spare time on their hands and are interested in sharing there knowledge through engaging blog posts on: 1) Power BI • Why it is a top rated analytics tool • How using it adds value to businesses • Power BI reports • Power BI Dashboards • Monthly Updates • Embedding reports • Sharing Dashboards • Building reports * Content Packs 2) Power BI Desktop • Connecting to data • Cleaning data • Data modelling • Using DAX • Building reports • Publishing reports 3) Power Query & Power Pivot (as related to Power BI data modelling) 4) Data Visualization 5) Data Analysis Target audience: Small to medium size business in need of new BI tools – Managers, CFOs, CEOs, accountants etc. The goal of this blog is to attract target audience with relevant and valuable content, build brand awareness and generate new leads. Required Skills: - Power BI - Data analysis - Data visualisation - Research - engaging & personal writing style I am not after a factual report on Power BI that is copied facts from different websites and put into your own words. I'm after, a personal touch, i.e someone explaining how they get the best out of the tool etc. showing how to use the tool, and how certain features add value to business analysis etc. humour, opinions, personality are welcomed :) Rob Collie's blog is a good example. (if you don't know who he is, then you probably not suited for this job) Prerequisites: I am after people who have experience with BI, data analysis and Power BI. I am not after a good writer who is going to thumb suck info form Google on data analysis and Power BI. If you can build data models, know DAX, Power Query, etc. and can build insightful visuals, then please apply. Look forward to hearing from you.
  • Number of freelancers needed: 3
Skills: Microsoft Excel PowerPivot Blog Writing Business intelligence Data Analytics