Excel Vba Jobs

193 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 month, 10-30 hrs/week - Posted
We actually are quite savvy with Vlookup, Subtotal, a little bit with pivot tables, and manipulation of data to get a report that is usable to make decisions with. But the time spent each time with a new data set (in our case, a new time period - monthly, quarterly, seasonally, etc.) is extremely labor intensive and involves creating several temporary working work sheets to get to the final report that we use. I am looking for someone to design a solution for us so that we can simply dump in new data at any time and have the reports generate dynamically. Basically creating a Query, but within Excel is possible. Project Brief We have three channels of our business – our own website , Amazon.com, and a small wholesale (sell to stores) business. The sales reports available from Amazon outputs sales data in a different format and collation from the other two channels. The sales data is also output at a granular level - e.g. Women’s Crew Neck Tee, Color White, Size Medium. While we do need analysis at this level, we also need analysis at one level up – e.g. how did the Women’s Crew Neck Tee (all colors & sizes) sell vs the Women’s V-neck Tee (all colors & sizes)? Requirements 1) If at all possible, we would like to use Excel instead of Access. We have PC & Mac users and are not very familiar with Access. Would be open to another solution if suggested, just putting the strong Excel preference out there. 2) We would like to be able to “run” the reports dynamically. Maybe we want to see the reports for Oct 1-7 and then again for Jan 1-Dec 31. “Running” the report would simply be opening the spreadsheet and dumping in new data (new time period) to replace what was currently in it. 3) Once new data is dumped in, we want to do minimal manual manipulation of the reports to get the current results. 4) Slicing and dicing will include: a. Doing lookups from 3 different sales data sets we dump into the worksheet as well as one static product data table. b. Hiding or avoiding zero values, #N/A, #REF, #DIV errors. c. Rolling up (sub totaling) granular data (sku’s) to higher level data (styles, brands, categories). d. If possible, using weighted average calculations for some sub-total fields. 5) Ideally we would like the output reports to show only the sku’s that are contained in the sales data that we dump for the time period. If this is not possible or creates too much complexity, we can live with having zero values for the sku’s with no data for that time period. Please see attached worksheet for an outline. Prices, costs, and sales data are all dummy and disguised for confidentiality purposes.
Skills: Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
Looking for a software developer to create a business application off of 4-5 spreadsheets I currently use for business. I'd like a clean web portal that functions very similar to spreadsheets and business process I currently have. If the project is successful, I'd like to use the developer for on-going support\customization. Purpose of Application - Manage Profit & Loss per client and per project - Manage Invoice schedule for CPA reminders and tracking - Manage Consultant Payment schedule - Manage Account Receivables for CPA reminders and tracking - Manage Work Orders and Contracts in central storage Requirements: - Convert 5 Spreadsheets into Web application - Set up workflow for each spreadsheet\module - Create an Easily customizable web app - Integration with Docusign - Integration with Quickbooks - Secure Cloud Storage - Mobile Version - Set up a Multi-user system (3 users) - Nice user interface for clients with multiple projects Features 1. P&L Workbook that can separate by client - some clients will have multiple projects\budgets. 2. Consultant Payment schedule -either can be integrated into quickbooks and easily exported via email. 3. Track Invoice schedule to clients - easy customizable form to send accountant and customers to set schedule for invoice submission to client 4. Accounts recieveable tracking - integrate into quickbooks or easily exported AND important via email. 5. Work Orders for consultants (and contracts, NDAs etc.) simple workflow, signing and storage - integration with DocuSign. 6. Manage Proposal Templates > workflow for working on a proposal in googledocs and easily sending and updating for customer interaction. Ability to finalize and send proposal through DocuSign and create a simple customer tracking flow or mini-CRM
Skills: Excel VBA Amazon EC2 API Development Caspio Programming
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
Hi I already have an existing macro and would like to use that macro to build another accounting function based macro. Need some one who can write VBA code proficiently. He needs to be able to write logical macros with values and calculations that are dynamic in nature and referenced to cells that can be changed. Need some one who can start as soon as possible and well versed with accounting and has access to Skype.
Skills: Excel VBA Accounting Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: 3 to 6 months, Less than 10 hrs/week - Posted
I have a few different but interrelated tasks. 1) I have a lot of data in various spreadsheets. I need the format standardized with a user interface that can be used to extract the needed records. - Some of the spreadsheets are quite large. They cover the same information but were assembled by different entities and thus are in different formats. 2) I am generating new records every day. I need the records standardized and placed in their own spreadsheet organized by state. 3) I have been working on building an Excel VBA API call and I just don't have time for the learning curve. The task is urgent and must be built sooner rather than later.
Skills: Excel VBA API Documentation Microsoft Excel
Hourly - Expert ($$$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I have an excel form that I use to collect patient information. I need to make the form more user friendly in excel. And to use it multiple times to input patient's information, and have a dashboard where those information will display as well. I don't want to do this in paper form every time. I want to make it to where I use one excel form to input patient information, and it goes into an excel database (in the same document), and the information accumulates with previously inputted information and it shown on an excel dashboard. So there will be several sheets in the workbook, perhaps an input sheet, a database sheet, and a dashboard. In the attachment, the information highlighted in yellow are the ones that will be inputted into the databased and I also want displayed on a dashboard (except for line 48-52, which is the comment and recommendation section). I want a mixture of basic functionality for the input section and statistical analysis and formula for the dashboard. Please send me examples of past works as part of your proposal.
Skills: Excel VBA Microsoft Excel Microsoft Excel PowerPivot
Fixed-Price - Expert ($$$) - Est. Budget: $20 - Posted
• Calling to Financial Manager who has SAP and Oracle ERP to offer them Our Product. • Sending out emails and following up on the leads Closing the sale • Must have Oracle or SAP background. • After sales follow up sales with client for more sales. • You will be calling in Middle East and Africa. • Must have a working internet and head set. • Must have your own telephone number to add to the calling system Business leads are provided. • Must have strong excel background • Must have Accounting background Must be fluent in English (send voice sample if available) You will provisionally be given a list of 50 contacts to sell to. Base pay for first 50 contacts is $5.00 and every successful sale carries a $120.00 commission - potential earnings of over $4,000.00
Skills: Excel VBA Enterprise Resource Planning (ERP) Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $60 - Posted
Hi, Upworkers, I need the following work done in Excel: - data visualization of certain KPIs - spreadsheet organization - rechecking of the formula linkages among the cells I might also need you to add a few sheets for further analysis. File to be shared once shortlisted or as needed. Thanks.
Skills: Excel VBA Data Analytics Microsoft Excel
Hourly - Entry Level ($) - Est. Time: 1 to 3 months, 10-30 hrs/week - Posted
I am looking for a freelancer to assist in the development of various excel worksheets to automate elements of our workflow. This will range from calendar and roster visualization, development of dashboards, sales reporting and monitoring of other processes. There will be continual work as there are several projects planned and continual improvements of our existing systems. Good communication skills are essential.
Skills: Excel VBA Microsoft Excel