Microsoft Excel Powerpivot Jobs

56 were found based on your criteria {{|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, Less than 10 hrs/week - Posted
Seeking to trial new VA for longer term commitment. The trial involves tidying up 6 months of transactional data in Xero, which is all currently loaded and coded in XL. Needs to be reconciled in Xero. And then the Xero accounts will be shut down. So the transactional level information in Xero is not a priority (I dont need it for management purposes), and need only be posted in summary eg income., costs with gst costs without gst. This means the tidying up of xero is only a few hours / days long to do. We need to submit 2016 June GST asap, and verify that the submission (which was an estimate) for March 2016. So this is a priority. Once this is done the Xero accounts for this company will be shut down and the company then wound up. This is the main task but the successful applicant will also be assessed for a longer term support role for the new business. This will entail 20-40 hours of work a week depending. Including - - bookkeeping - contact management - research assisting - family assistant - file mangement all depending on skill levels - in general supporting the launch and maintenance of this business long term. The first task is the accounting task. Applicants need to have thorough understanding of reconciliation principals, to succeed with 1st task. From here we will assess the suitability for a longer term engagement.
Skills: Microsoft Excel PowerPivot Administrative Support Microsoft Excel Virtual Assistant
Fixed-Price - Entry Level ($) - Est. Budget: $5 - Posted
The attached excel filehas 3 accounts each with dates and amounts. the "project" is simply to get a DAX formula to grab the amount from each of the 3 accounts that corresponds to the earliest date in the account. For anyone who knows DAX, I'm thinking it should be a couple minutes. I must use DAX, not SQL nor an excel formula. for more on DAX:​ Write a DAX code​ excel powerpivot with DAX
Skills: Microsoft Excel PowerPivot
Hourly - Expert ($$$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
Take an excel file, create Pivot table and output new Excel with data displayed like output template provided. Files to be sent: 1-raw file 2-Template and instructions Template instructions are attached
Skills: Microsoft Excel PowerPivot Excel VBA
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
We have .csv files exported from Wistia (a video hosting service). These files contain video viewing data such as # of plays, hours watched, % viewed, etc. We would like to get more granular information based on these data by breaking down each stat according to user, type of video, etc. Please find the attached Excel file to see Wistia data (see "Wistia raw export" worksheet) and the type of information we'd like to extract from it (see "Information needed" worksheet). We would then like to have a way of visualizing such information easily, for example if we want to see how many hours user X spends viewing video type Y. Excel should be adequate for our purpose, but we are open to suggestions.
Skills: Microsoft Excel PowerPivot Excel VBA Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $200 - Posted
We're looking for someone who can help us develop the financial plan for our start-up. We're both creative individuals and we're not great with numbers and statistics, however we understand the importance of the finance aspect of a business. With that said we need help with figuring out cost of goods, break even point, expenses, payroll, and pricing. **We currently have no data and we are unsure where to start. With that said we are looking for someone who will be willing to help us put together all the pieces of the puzzle.
Skills: Microsoft Excel PowerPivot Accounting Cost accounting Excel VBA
Hourly - Expert ($$$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I use an online share brokerage firm that produces live share data for the FTSE 350, NYSE and NASDAQ stock exchanges in real time. Unfortunately, this live data does not extend to the share graphs they produce which has a 15 minute delay. The data I am specifically after that needs a line graph for each entry is the "top risers" for these exchanges which consists of the top 20 stocks for each exchange. As previously stated, this data reflects the live share price but the graphs they produce do not. Here is an example : This information is best stored in an excel document that can be manually refreshed when needed. The type of graph format is a line graph format similar to what the above site has. Any questions let me know
Skills: Microsoft Excel PowerPivot Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
Want to qualify chart in Excel. (We will convert it to php) The calculator will be located in the existing site. Which allows surfers to get an estimate for their business. Need help from professionals who did such a thing in the past. Only examples that work - will answer reference
Skills: Microsoft Excel PowerPivot Business Coaching Business Development Business Management