Microsoft Excel Powerpivot Jobs

41 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: Less than 1 week, 30+ hrs/week - Posted
I am looking for someone to take data from a spreadsheet with a list of 50 different investors that invest in separate real estate deals. We need to take each separate real estate deal (and monthly distribution activity from the bank account) and input that data into a one page monthly report. Ideally the monthly statements would be sent automatically to the partners via email and US mail. I am going to attach an example of what the monthly statement should look like.
Skills: Microsoft Excel PowerPivot Microsoft Excel
Hourly - Expert ($$$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I need maybe an initial couple of hours of excel support to create a visual, engaging representation of some web traffic data. I have an example of roughly what I would like this to look like so there is a good start. I would like to run through the project with a professional first so we are on the same page. Ideally I need someone to help me with this tomorrow, Friday 29/04. This will form part of an on-going monthly report and so I will need support once a month. Please contact me if you are available and confident with pivot tables / data segmentation / graphs and I can send you the example and arrange.
Skills: Microsoft Excel PowerPivot Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I have been doing my bookkeeping in Excel for my real estate business and need someone to help me SIMPLIFY some of the processes within the file and therefore produce better REPORTS that show me key information about my business. There is no need for any VBA knowledge however, very good Excel knowledge is required - understanding of indirect formula and index matching preferred. Simplifying - just make it as user friendly as possible for when I update the file each week and presentation is very important (clean and tidy spreadsheet). Reporting - I want to see the following reports: 1) Company P&L 2) P&L by property 3) Transaction detail by property (by month and year to date) 4) Clear set of instructions of how to update the file each week 5) Visuals - I want to see charts/tables that show me the trends of the key areas of the business I have all the bank export details from July 2015 that I have previously reconciled. Most of it is organised but not all. I have also had to create some manual entries which means it won't tie back to the opening/closing balances in the bank account - this will need correcting but I can help with that.
Skills: Microsoft Excel PowerPivot Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
I need someone that can support both operational and administrative task. I'm a small business owner and full-time HR professional. In this role, you will need to availability EST to support our Boston office. The function of the role would include: Setting up auto-responding emails (Mailchimp) Draft and sending thank you notes & reminders Researching industry specific (webinar, conferences, industry news) Preparing PowerPoint presentations Managing social media accounts Calendar Management Email Management & filtering Managing contact list and spreadsheets Travel arrangements
Skills: Microsoft Excel PowerPivot Data Entry Email Etiquette Email Handling
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
i need to have created into a excel wb working rolling scaleable to be able to change $'s for cal year. Need to forecast year.Then row for ACTUAL. Ex: forcast April $250k But actual = 4 hires- 1 $75k @ 15% of base = Rev $11,250 2 hires @ 20% ea on base of $50k ea = rev $10k ea and 4th hire @ 15% $100k= $15,000 rev. = but be able to change it if needed and have flow. Then have row of actual against the forecasted. Make sense? I have little sheet with samples of ranges of positions, contract various %'s of bases. And one other category is CONSULTANTS (VS the direct placements that we utilize their base salary as the number in for forecasting) that work on projects. So i may have a consultant work for 3 months Bill Rate=$125.00 x # hrs worked that month would give me the Total Dollars for the forecast in month. SO example - I know proj is 3 months and i estimate that he will work 150 hrs per month for April, May & June. I would want to include $18,750 in the FORECASTED Base # for Apr-May & June. but ACTUAL hrs worked for April 160 hrs The Base Actual # would be $20k and the actual Rev would be the base of $20,000 minus payment to contractor ( $55/hr x 160 hrs= $8,800 - $20,000 = $11,200) giving $11,200 as my actual revenue number for month. Make sense? I'm attaching sample of what boss wanting to see but will need it formatted etc. for visual and for printing.
Skills: Microsoft Excel PowerPivot
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