Save this Search
     

All JobsVBAFinance & Management

 (275 results)  
Sort by:
  • Posted Date
Fixed Price: Less than $500   |  Posted: 7h, 7m ago  |  Closed  |   7 Proposals
Please help me create the following rules for the attached work bookwork. 1. On the LLC, Sales, Dev, GC, SI, A, A01 and FM tabs create the following conditional formats 1.a. If any number both positive and/or negative is entered into Current Adjustment (Column G), turn the corresponding Note cell in Column P light green. See LLC tab for hard coded example. 1.b. If Cost to Date (Column M) exceed Total Committed Cost Column K, turn the corresponding Cost to Date cell Red 1.c. If Total Committed Cost (Column K) exceeds Current Budget After Adjustment (Column J), turn the total Committed Cost Orange. 1.d. In the Cash Flow tab, please setup a conditional format to change the cells a color that fall between the Start Date and Fish Date Range 2. On the Allocation Tab please create a multiple array function or some other type of formula that will pull the cells that have "Current Adjustments" on the Allocation Summary tab in order by tab. See hard coded example in the Allo...
Category: Other - Finance & Mgmt       

m****b21
 [?]
Sign in to view client's details.
| m****b21
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: 12h, 39m ago  |  Ends: 14d, 11h  |   8 Proposals
Looking for someone to build, design and send 5 Area Managers weekly reports on their individual Sales representative's Commission Balances on a weekly basis. Details of the assignment: Initally: 1. Design data format to be able to present "Copy of Commission Statement" attachment in pivot table format based. The data will be a combination of the data sources I send to you: Data sources: 1. Zoho CRM report for sales (Students) that have passed confirmation date (Census date) - please see Zoho Report Example 2. Excel Workbook of how weekly pay has been calculated each week, includes the database of the students that were paid against. Please see "Commission Data 07-07-15" attachment as an example. - Best to work off of this and build your data format to spit out the report For the calculations: Each student is $450 confirmed at Census Date for an EA (Sales Representative Each student is $75 confirmed at Census date for a Team Leader including their own sales. Ongo...
Category: Financial Reporting       

D****Ltd
 [?]
Sign in to view client's details.
| D****Ltd
|    Australia
Hourly Rate: $20 - $30 / hr   |  Duration: 1-3 months  |  Posted: Jun 26, 2015  |  Ends: 3d, 22h  |   6 Proposals
I am very interested in learning the basics of financial modelling, in particular projecting the three statements, linking them, calculating IRR etc... As of now I have a sound working understanding of a number of concepts in both accounting and finance, having completed the CFA Level I exam and having recently sat the 2015 CFA Level II exam. I am also open to any suggestions that you may have, i.e. directing my learning toward what you feel is most important to know around analyst/starting level in IBD or Sales & Trading at an investment bank. I look forward to hearing from you. SP
Category: Investment Analysis       
Skills: VBA, Accounting, BASIC       

S****993
 [?]
Sign in to view client's details.
| S****993
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 22, 2015  |  Closed  |   11 Proposals
please see attached PDF. It is not necessary for the programmer to understand anything about finance. just Excel programming. The description PDF should be clear enough.
Category: Investment Analysis       
Skills: Microsoft Excel, Excel VBA       

k****d01
 [?]
Sign in to view client's details.
| k****d01
|    United States
Fixed Price: Less than $500   |  Posted: Jun 18, 2015  |  Closed  |   3 Proposals
attached is the file with the explanation inside. its simple to understand - i have not found a quick solution while googling it - so if you take a look and know the solution please bid. if not - don't waste my time, if i had 3 days to research myself i would do it myself. thx
Category: Financial Reporting       

g****ova
 [?]
Sign in to view client's details.
| g****ova
|    Israel
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 14, 2015  |  Closed  |   19 Proposals
Looking for some quick Excel guidance with likely more work to follow. Specifically, seeking assistance creating a nested ISERROR AND OR statement for an average function. I want to exclude '0' values. Please reach out if you're interested in the job and think that you can provide assistance. Additionally, please let me know your rate. Thanks.
Category: Financial Reporting       
Skills: Microsoft Excel, Excel VBA       

****
 [?]
Sign in to view client's details.
| Client
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Jun 10, 2015  |  Closed  |   28 Proposals
Excel Expert needed for consulting, estimating, and problem solving several questions. Example would be parsing out data from single cell into multiple (using formulas), creating chart to better visualize data, etc. Only need a few hours of your time. Please respond ASAP.
Category: Other - Finance & Mgmt       
Skills: Microsoft Excel, Excel VBA       

j****cld
 [?]
Sign in to view client's details.
| j****cld
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: Not Sure  |  Posted: Jun 07, 2015  |  Closed  |   6 Proposals
guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded
Category: Financial Reporting       
Skills: Excel VBA       

D****sen
 [?]
Sign in to view client's details.
| D****sen
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 07, 2015  |  Closed  |   21 Proposals
I need to extract all the products/items I sell to a specific customer from my Quickbooks file. After that I have a very large master item file in Excel in which I want to cleanse to display the item data that was extracted from Quickbooks. The reason for this is the master file has more relevant info and data that a customer of mine needs to import into there purchasing system.
Category: Other - Finance & Mgmt       

j****one
 [?]
Sign in to view client's details.
| j****one
|    United States
Fixed Price: $100 - $200   |  Posted: Jun 05, 2015  |  Closed  |   5 Proposals
The VAYCC Organisation has been established to be able to have their own band or singing groups or choir, however there are many singers who are going to be part of this organisation and it is going to be hard for the managers to manage them all. Now the manager wants a simple app that able them to manage all of them, their information and time in a very efficient way. The functionality of the app will be explained as soon as you apply and contact me. Skills: Access, VBA, Makro Excel
Category: Management Consulting       

b****oy1
 [?]
Sign in to view client's details.
| b****oy1
|    Austria
Hourly Rate: $10 - $15 / hr   |  Duration: 1-3 months  |  Posted: Jun 01, 2015  |  Closed  |   7 Proposals
Using Excel and VBA, analyze data to prove or disprove an hypothesis. Basic knowledge of SQL is necessary. Must use VBA, not just excel be successful at this position.
Category: Financial Planning       

o****dev
 [?]
Sign in to view client's details.
| o****dev
|    United States
Fixed Price: Less than $500   |  Posted: Jun 01, 2015  |  Closed  |   21 Proposals
I require someone to help me with a set of excel sheets which need tidied up and made a little bit more advanced. I require someone who understands scenario manager, goal seek, whatifs, data tables and similar advanced excel functions to mould existing data into a more presentable format, with charts, dashboards, scenarios and similar functionality. This model will be used for raising capital, so should be in a format which is intuitive for investors. I want them to be able to play around with the starting conditions and growth rates and see the outputs easily. I have two files, both with multiple sheets. One file is for input (revenue model) and one for output (financial statements). The output sheet is from the accountants software package, Xero. I need to take the output and add it to the input sheet so that everything is self calculating and automated. I also want scenario manager for all metrics in the revenue model so that we can run a sensitivity analysis and see how the ou...
Category: Financial Reporting       

a****n11
 [?]
Sign in to view client's details.
| a****n11
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: May 25, 2015  |  Closed  |   9 Proposals
I would like to automate a procedure. The procedure will copy cell ranges in MS Excel, and several charts, and paste them into a PowerPoint presentation. This procedure occurs on a monthly basis for me. I will provide the Excel document and Powerpoint.
Category: Other - Finance & Mgmt       
Skills: VBA, Excel VBA       

t****429
 [?]
Sign in to view client's details.
| t****429
|    United States
Fixed Price: About $20   |  Posted: May 21, 2015  |  Closed  |   3 Proposals
Hi, I would like to create new workbook files from each row in an excel file. If the workbook exists, then to add the row to the file. Here is more information- I have a pretty basic Excel macro request. I am attaching a file called FinanceTotalsAllStores. This is a file generated every day in the same format. If you could open that file, you can follow the steps that I need performed. Basically every line in column A which is NOT bolded is a different store. The date on the top is the date of the report. I need a macro which will add data from that day to individual workbook file (store file) for each store. In each store file, I want it to copy the date to column A and then the data from that day. Keep it in date order. If data exists for that date, show a popup showing that data exists and do nothing.
Category: Accounting       
Skills: Microsoft Excel, Excel VBA       

p****mit
 [?]
Sign in to view client's details.
| p****mit
|    United States
Fixed Price: Less than $500   |  Posted: May 19, 2015  |  Closed  |   20 Proposals
I'm looking for someone that is an expert in creating visual stories from excel data. Ideally, the final dashboard will reviewed on a quarterly basis and include: - Actual to projected revenue - %/$ Change from previous period - See additional areas in "Sample Dashboard" I've attached a copy of a sample dashboard. This is my ideal vision, if you can get to the end goal using a different format, I am open to your suggestions. I've looked at several online dashboard creators but, none of them seem to offer an excel plug and play option. All of the online tools want data imported from various accounting software, but data is not available in an accounting software. In your response, please let me know the following: Have you ever built a dashboard for a staffing firm? If you have a portfolio that is not on Elance, include a link to your work? How long this would take and what additional information will you need from me (aside from the budget) If there are other KPI's th...
Category: Financial Reporting       
Skills: Microsoft Excel, Data Analytics, Excel VBA       

B****day
 [?]
Sign in to view client's details.
| B****day
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: Not Sure  |  Posted: May 17, 2015  |  Closed  |   11 Proposals
Need assistance creating an excel model that allows me to manage a small vacation rental businesses basic accounting (have most data inputted already). We have about 150 vacation rental tenants we manage for 15 properties and need help building on existing excel workbook to manage the key data and create reports for owners. Key functions: *Build on existing excel workbook/formulas (Attached) to create an easy monthly report for each property owner (currently 15) on weeks booked, amount of rent received, rent distribution for current month, etc. First key need is on "Leases" tab TO CREATE MACRO/INDEX FUNCTION OR OTHER WAY TO AUTOMATE PULLING IN MULTIPLE PAYMENTS. I created a Vlookup which pulls first payment but need a more complicated function (Index or Macro) to pull in subsequent payments by same tenant. *Once this is complete would like to create fairly automated way to produce monthly reports for each property (what has been paid etc.) We can discuss in detail once jo...
Category: Financial Reporting       

K****t99
 [?]
Sign in to view client's details.
| K****t99
|    United States
Fixed Price: Less than $500   |  Posted: May 15, 2015  |  Closed  |   2 Proposals
I need an excel based spreadsheet to track and manage the payment fees for a money manager trading for clients. The sheet will have all the client details contact details, account info and automatically calculate fees due at the end of the month as per the High Water Mark profile. Ability to add new clients and multiple accounts to existing clients is required. Need a scorecard that shows all fee results that can be presented monthly for multiple years.
Category: Investment Analysis       
Skills: Microsoft Excel, Excel VBA       

s****e72
 [?]
Sign in to view client's details.
| s****e72
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: May 11, 2015  |  Closed  |   6 Proposals
Hello, We would like to create a macro to help us consolidate worksheets and create a master report (as another worksheet.) We are looking for a generic macro that we can run to automatically create a master sheet with the consolidated data. We need this soon, however it is a fairly easy task. We have an automatically generated payroll excel file with multiple worksheets each representing another store. Each sheet lists individuals and the hours they worked. Each worksheet is another store. We would like to create a Master sheet which has the information on each employee from all the other sheets (stores). If an employee has worked at multiple stores in the same day, we would like to add their hours in the master sheet so we have a total amount worked each day. On the master sheet, we would like to keep the store number with the employee (possibly in the additional information) Please see attachment for an example file. It is a sample payroll file generated by our computer dail...
Category: Accounting       

p****mit
 [?]
Sign in to view client's details.
| p****mit
|    United States
Fixed Price: Less than $500   |  Posted: May 09, 2015  |  Closed  |   2 Proposals
Excel 2010 VBA programming help needed to complete a workbook. I don't imagine the job to be very difficult for an experienced programmer, I just need someone to create a macro to get the job done as I am short on time. Timeline - We must agree on a time deadline. My time limit for this workbook is 1 to 2 days - firm. The faster you can complete the macro, the better. We can discuss further details with regards to the deadline over skype. Pricing - We must agree on a reasonable price estimate beforehand. If it's too hard to give an estimate of how much time you need, then this is not the job for you. The reason for this is simple - I need the macro finished within the time frame set above. Further discussion can be held over skype, but I'll be clear that I don't pay for skype time, I only pay for a 100 % finished workbook (this means also testing and re-editing if something doesn't work). I've attached the excel workbook for you to take a look at. As a heads up, it is rather large...
Category: Investment Analysis       

M****_v1
 [?]
Sign in to view client's details.
| M****_v1
|    Finland
Hourly Rate: $40 - $50 / hr   |  Duration: 1-2 weeks  |  Posted: May 03, 2015  |  Closed  |   8 Proposals
Requires a simple userform to retrieve data from a worksheet. This user form will include drop-down menus as well as text boxes.
Category: Other - Finance & Mgmt       
Skills: Excel VBA       
Preferred Location: United States

d****er1
 [?]
Sign in to view client's details.
| d****er1
|    United States
Fixed Price: Less than $500   |  Posted: May 02, 2015  |  Closed  |   23 Proposals
its a workbook where you put in all your information about the company that you work for including all rates of pay and inc early start money and nights out etc. then there is a daily input page for start time end time etc and your daily wages are calculated etc also a VDO pages where you put in your tacho information. i do have a partly working workbook already but i just need it finishing. im new to programming and ive run out of time to complete this myself and need to hire someone to finish this project for me. i do have a file for viewing if required.
Category: Financial Reporting       
Skills: Microsoft Excel, Excel VBA       

F****011
 [?]
Sign in to view client's details.
| F****011
|    United Kingdom
Hourly Rate: $20 - $30 / hr   |  Duration: 4-6 months  |  Posted: Apr 28, 2015  |  Closed  |   19 Proposals
Ideal candidates will hold strong analytical and programming capabilities. Prior analytical and financial modeling experience is necessary. Prior experience in a financial analyst program is a plus. Candidate must have experience in making simple, yet robust excel models with the use of sophistic excel functions. Proven expertise in automation of excel workbook, dashboard creation and data flow management within an excel+excel-vba format is needed. Ability to create excel outputs using data tables, pivot tables for sensitivity analysis is required. Understanding of accounting and financial statements is useful. Ability to handle multiple assignments on a timely basis with a high degree of accuracy Ability to work independently and deliver results. Candidate needs to be able to perform from remote location and receive instructions over phone
Category: Financial Planning       

A****345
 [?]
Sign in to view client's details.
| A****345
|    United States
Fixed Price: Less than $500   |  Posted: Apr 25, 2015  |  Closed  |   26 Proposals
I would like a monthly and YTD management dashboard report based on various financial statements below. The report should include critical operational and financial data and kpis. Monthly data is actual and plan and will be uploaded every month. - Balance sheet - PL account - Cash flow - Cost analysis Please feel free to provide with samples with your proposal. Model should be excel base and no programming. Attach is just an example of how it could look like.
Category: Financial Reporting       

****
 [?]
Sign in to view client's details.
| Client *
|    Norway
Fixed Price: Not Sure   |  Posted: Apr 24, 2015  |  Closed  |   20 Proposals
Looking to have a finance/excel ace build out of workbook financial model for our IPO clients. Workbook would consist of a detailed discounted future cash flow model with variable inputs; risk free rates, tax rates, beta, cost of equity, terminal growth rate compared against various initial public offering scenarios - number of shares offered, price per share, total dollar amount of offering. We want this to be a tool that we can use to both propose pre-ipo valutions and price (we are a law firm) and dilution to the original shareholders, as well as having the ability to utilize tthe workbook to run various scenarios. I myself have extensive excel knowledge and financial knowledge, but lack the time to devote myself to this project.
Category: Investment Analysis       

a****esq
 [?]
Sign in to view client's details.
| a****esq
|    United States
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job