Save this Search
     

All JobsMicrosoft ExcelIT & Programming

 (94 results)  
Sort by:
  • Posted Date
Fixed Price: $20 - $30   |  Posted: 2h, 36m ago  |  Ends: 14d, 21h  |   7 Proposals
Macro adding row The purpose off this macro , add an extra row if there are more then 2 products with the same product IDs. If answer is yes then add an extra row and fill in collums with others values The double product ids are orange marked in the sheet Rows Copy a row from this product ID range (green marked) Make the following changes Add the lowest price of to the collumn price Add the lowest price to collumn lowest price within this product rang Add text FATHER to collumn CH-FA Add the price gap between the lowest price and normal price in collumn All other values are the same as from another row within this price range Collums to fill 1. CH-FA Add CHILD into collumn CH-FA Add FATHER into collumn CH-FA fort he new added row 2. Lowest price (red marked) Find the lowest price withhin the same product ID Range (red marked) 3. Price gap (purple marked) This ist he price between the lowest price and the price fort he sku in this row Add the lowest priceinto collumn lo...
Category: Data Engineering       
Skills: Microsoft Excel, Excel VBA       

M****ort
 [?]
Sign in to view client's details.
| M****ort
|    Netherlands
Fixed Price: $20 - $100   |  Posted: 3h, 15m ago  |  Ends: 14d, 20h  |   7 Proposals
Hello, I have 5 price sheets similar to this:   [obscured]  /ee/sample.pdf I want them to be converted into .xlsx with some feilds locked and some editable. There are 4 similar ones to convert and 2 more to create (they are about the same just different data. I need this to be done this morning.
Category: Other IT & Programming       
Skills: Microsoft Excel, .pdf, .xlsx       

e****oxy
 [?]
Sign in to view client's details.
| e****oxy
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 7h, 49m ago  |  Ends: 14d, 16h  |   9 Proposals
Looking for a project manager to migrate a project plan from excel to MS Project and create a proper scheduling and critical path plan with stakeholders to followup. I have all data on excel. need the project to be done by Saturday 4th of July.
Category: Project Management       

m****yad
 [?]
Sign in to view client's details.
| m****yad
|    United Arab Emirates
Hourly Rate: $10 - $15 / hr   |  Duration: 4-6 months  |  Posted: 12h, 10m ago  |  Ends: 14d, 11h  |   6 Proposals
PROPOSALS WITHOUT INDIVIDUAL RESUME (not company) and +91******** number WILL NOT BE CONSIDERED. Hey, I am Ravi Kumar. I am permanent Resident of USA. I do consulting for many companies here. Since I have much work at hand, I do hire freelancers from India to help me with my work. To be frank, I outsource my job on a full time basis to the people in India and pay them monthly. NOTE: Candidate can work remotely and will be paid monthly. So you pursue the job in my name and get paid monthly. THANK YOU, if you have any questions, please feel free to contact me. Below posted is one such requirement (given is a link to a similar job, where you can find similar requirements of this job). If anyone is interested and has a genuine experience of around 4-5 years or more, please do feel free to contact me. Working with a team of 4 Oracle DBA's as the SQL DBA SME Overseeing a SQL production database Setting up SQL Server databases (v2008 and v2012) Performing monitoring and alerting Configur...
Category: Database Administration       

r****ult
 [?]
Sign in to view client's details.
| r****ult *
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 15h, 3m ago  |  Ends: 14d, 8h  |   12 Proposals
I need to add a hyper link to a current spreadsheet I have. I need to show quantity on hand.   [obscured]  /cs/ws/ws.ashx?service=wheel&wheelpartno=AR68328512 this is the info we use to plug in the part numbers we have and then the quantity will show up in a XML file. need help soon
Category: Database Development       

n****777
 [?]
Sign in to view client's details.
| n****777
|    United States
Fixed Price: Less than $500   |  Posted: 15h, 22m ago  |  Ends: 14d, 8h  |   9 Proposals
I'm looking for a solution that can regularly upload opportunity line items to Salesforce also with PDF attachments that have automatically had a company logo attached to them. 1. We will have a CSV file that contains the opportunity line items from a piece of software called VRPRO (kitchen design software), 2. This CSV file contains products that are already listed in my Salesforce database, their price is already in the standard pricebook (also currently in the salesforce database) 3. User experience should look like this: I need the user to input a customer name and opportunity name into Excel (probably an opportunity already created on Salesforce, but not necessarily) I need the user to be able to select the CSV output file (described above) from the local machine, which will provide the opportunity line items to be uploaded I also need the user to be able to add several PDF's (which should automatically have a company logo added to the same position on each pa...
Category: Software Application       

j****nar
 [?]
Sign in to view client's details.
| j****nar
|    United Kingdom
Fixed Price: $1,000 - $5,000   |  Posted: 20h, 43m ago  |  Ends: 14d, 3h  |   15 Proposals
We need a platform the keeps a database of information (name and corresponding information to the name) that the user will enter into a page on our website. After the information is entered in the website we need this to go into our database and be able to be retrieved through varies fields entered by the user. We are going to need a the organization (one of the fields that will be entered by the user) to be able to access the information associated ONLy with their organization via user name and password. We will also need the "back of the house" (employees) to have access to the information. Functions needed: 1. user enters name, address, etc 2. user will enter an organization they are with via drop box 3. as the administrator, we need to be able to add organizations to this drop box as we sign them up to use our service 4. we have authorize net as our billing service so this will need to be integrated 5. we are going to need reports run based on the fields (i.e. by name, ...
Category: Database Development       

c****lin
 [?]
Sign in to view client's details.
| c****lin
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 22h, 23m ago  |  Ends: 14d, 1h  |   18 Proposals
My firm (an alternate asset manager) intends to get on-board on a long term basis a developer with 5 to 7 years' experience in Microsoft technologies to assist with application development and maintenance. The role requires the following, 1. Excellent working experience in developing Windows forms and web applications in Visual Studio 2012; Expert level .net development skills (e.g. C# or VB.NET,ASP.NET, .NET framework 4.0 and above). 2. Expert level working knowledge of SQL server 2005 or higher, fully hands on in writing stored procedures, functions, triggers; well verse in data modeling, table design, data types, table relationships, indexes and code performance tuning. 3. Working knowledge of Excel Macro programming (VBA) is desirable. 4. Good communications skills, strong aptitude in learning new systems and technologies, prior experience of dealing with direct business users is a big plus. 5. Ability to write technical documentation to articulate technical design and implementati...
Category: Software Application       
Preferred Location: United States

c****l74
 [?]
Sign in to view client's details.
| c****l74
|    United States
Fixed Price: Not Sure   |  Posted: Jun 29, 2015  |  Ends: 13d, 23h  |   2 Proposals
From Capital IQ, I'm looking for 2 specific data lead lists in Microsft Excel. I'm looking for very detailed contact info for each of the two company call lead lists below. From each company on the list, I want to know who is the: Founder, CEO, and Board members. I'll need to know: Name, Title, Phone number, Email, Address. Phone number and email are a must. I would also like to know if they are on any other boards or associated with any other companies. Private company Search #1: M&A ? Looking for contact information on the person who sold a private business Company Sold: 2014 or later Location: United States Amount: $50 Million minimum Private company Search #2: General ? Looking for contact information on the person who owns a private business Location: United States EBITDA: $10 Million minimum I'm willing to pay $0.20 per lead.
Category: Database Development       

r****r08
 [?]
Sign in to view client's details.
| r****r08
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 29, 2015  |  Ends: 13d, 14h  |   15 Proposals
I buy / sell Memory sticks and many of the sticks vary in part #. Some part #'s vary in Date Code ( a # printed on each stick that specifies the date of manufacture ) I would like excel to get the totals of how many of each part #, and also how many of each Date Code of Each part #. I've almost figured it out via excel, i know it's a simple task, just need a little more knowledge to make it happen. We can do a screenshare so i can better show you what I'm looking for. Greg
Category: Other IT & Programming       
Skills: Microsoft Excel, Inventory Management       

g****360
 [?]
Sign in to view client's details.
| g****360
|    United States
Fixed Price: $1,000 - $5,000   |  Posted: Jun 29, 2015  |  Ends: 13d, 12h  |   35 Proposals
We wish to port existing Excel VBA implementation to database driven web (including mobile) application. We wish to have the application developed for not more than 20 users. Browser based secure access, output and controls will be accessible through workstations and mobile devices and pads. A DB imports on request pricing data through API from a range of data sources such as Bloomberg. Periodicity of the data ranges from 1 hour to 1 month, and data is in the form of Open, High, Low and Close. A range of simple analytics are applied to this data on request (for example simple moving average), and the resulting time series are being stored alongside the raw pricing data. Charts are being generated and displayed on the basis of stored pricing and analytics data; subject to discretionary control, certain analytics will be recalculated and redrawn.
Category: Database Development       

m****ke1
 [?]
Sign in to view client's details.
| m****ke1
|    Switzerland
Fixed Price: Less than $500   |  Posted: Jun 28, 2015  |  Ends: 13d, 6h  |   36 Proposals
I have a budget sheet that right now pulls prices from a large master Excel price sheet. I am growing past Excel and need something more powerful to quickly pull budgets. I am looking for someone who can make a database that will be able to make budgets for my products. An example of the budget can be found below. I have 40 Products in my line of work: Each product can be made in 3 levels each product takes about 100 items (labor and materials) each item has 1-5 vendors to choose from who do the labor and material at different prices. I have all of this information in a relatively big excel sheet. I have attached a sample of the budget that I need Access to pull. Please let me know if you need to see some of the other data first and I can show it to you. Even if we can start with a few plans I can enter the data myself, I more or less just need the database built with a few plans so I know how to enter the rest of the data.
Category: Database Development       

J****ing
 [?]
Sign in to view client's details.
| J****ing
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: Not Sure  |  Posted: Jun 28, 2015  |  Ends: 13d, 5h  |   13 Proposals
Hello, I'm looking for an Excel expert to help me with my sheet. I have two data sheets (NEW & OLD) and a third sheet to compare between the two data sheets. If there is any change between the data, then it would be highlighted. I did a Conditional Formatting. I already finished all of these. However, now I'm looking for help to design a tracker that would record every time the search shows a mismatch. Its a quick job I already design everything, but I can't do the coding part to make it work. IMPORTANT: I won't be able to upload the file for confidential purposes. So you will access my PC and work on the project. Thanks, Mo
Category: Database Administration       

m****oud
 [?]
Sign in to view client's details.
| m****oud
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Jun 28, 2015  |  Ends: 13d, 4h  |   26 Proposals
A couple (8 files) of excel-files that needs to be converted to a new datastructure. Backup available with new database structure. Required: - experience etl knowledge - analytical skill - experienced tsql knowledge Excel files are in used now so the convert should work even when the system goes live.
Category: Database Development       

2****dic
 [?]
Sign in to view client's details.
| 2****dic
|    Sweden
Fixed Price: $20 - $30   |  Posted: Jun 28, 2015  |  Ends: 13d, 1h  |   4 Proposals
I would like to pull the free Moz.com data onto an excel sheet. There are free tools to do this for Excel and Google Docs. But I have been unable to make them work correctly. Looking for a solution I can replicate I am only for the free MOZ information The two for Google docs are: spreadsheetbooster.com, supermetric.com Here is an example: Here is an example file of MOZ data:   [obscured]  /spreadsheets/d/1uSaRTybRl9xElqIvyy7Ql5rIgSKiH1US5JAZjzxSJSg/edit?usp=sharing Thanks, let me know if you need another information.
Category: Other IT & Programming       
Skills: Microsoft Excel, Google Docs       

l****SEA
 [?]
Sign in to view client's details.
| l****SEA
|    United States
Fixed Price: $500 - $1,000   |  Posted: Jun 28, 2015  |  Ends: 4d, 23h  |   31 Proposals
Create a Microsoft Access Database with a simple GUI for a logistic company. The required functionality: - Linkage to pull data from the different databases to auto populate fields - Import orders from an excel spreadsheet - Auto generate printing labels using a certain template - Generate monthly reports by pulling data from various database - Mass email (batch email) with a template populated with data from the different databases via Microsoft Outlook
Category: Database Development       

f****898
 [?]
Sign in to view client's details.
| f****898
|    Hong Kong SAR, PRC
Fixed Price: Not Sure   |  Posted: Jun 28, 2015  |  Ends: 12d, 22h  |   42 Proposals
Business background and requirements Develop for IT consultancy, whose works falls into 2 main categories ? Time based consulting, where clients are simply charged an hourly rate for consultant time ? Pre-paid support agreements, where a number of hours is purchased up-front, and the support work is completed as required The goal for this engagement is to obtain a database driven time-sheet application which will allow for strong reporting on many details of client and consultant time. Back-end Database: SQL 2012 or 2014 Reporting: SQL reporting services 2012 or 2014 Interfaces C# or VB.NET front end, may also be HTML 5 or Bootstrap or Angular web interface Compatibility .Net 4.5 Source Code All source code will be delivered to us as part of the project Security AD-integrated auth (for consultants), SQL internal authentication (clients) Support Bug fix support must be provided for a minimum of 3 months after delivery A quote for on-going support and minor upgrades sho...
Category: Software Application       

v****u22
 [?]
Sign in to view client's details.
| v****u22
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 28, 2015  |  Ends: 12d, 16h  |   18 Proposals
I have 5 months of itemized accounting and labels. I want to streamline it so everything is auto in the future. I want it to have live reports of financials. Income and expense from multiple sources. Bank. My customer system and historical measurement. I can discuss it more in depth on phone. Long story short I need an extremely easy to use accounting excel sheet that potentially pulls macro data from sources live and processes it.
Category: Data Analysis       

Q****yRy
 [?]
Sign in to view client's details.
| Q****yRy *
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 28, 2015  |  Ends: 12d, 16h  |   24 Proposals
I have a macro for my business that needs refined. A friend of mine wrote it a month ago but he is helping with water wells in the Congo and has no time. It involves the golf industry and is quite simple.
Category: Business Intelligence       
Skills: Microsoft Excel, Excel VBA       

Q****yRy
 [?]
Sign in to view client's details.
| Q****yRy *
|    United States
Fixed Price: Not Sure   |  Posted: Jun 27, 2015  |  Ends: 12d, 5h  |   42 Proposals
I want to improve ranking for my page below...   [obscured]  /content/barcode-generator-excel for the keywords "barcode generator excel", "Excel barcode generator" and "barcode generator software excel" and "barcode generator microsoft word" So, both on page and off page optimizations needed. Thank You
Category: Search Engine...       

a****ces
 [?]
Sign in to view client's details.
| a****ces
|    United Kingdom
Hourly Rate: $10 - $15 / hr   |  Duration: 7-9 months  |  Posted: Jun 27, 2015  |  Ends: 23d, 3h  |   10 Proposals
Employer Background: Leerdam Properties is an experienced real estate investment and full service brokerage company serving some of the largest institutional buyers in the world. While our primary focus is residential properties, our experience also includes high-level real estate such as vacant land, development, office, and commercial. Position: Database/Technology Assistant Start Date: June 2015 Hours: P art - Time ( 20- 3 0 h ou rs/ we ek ) Pay Rate: $10-14/hour depending on experience. Job Responsibilities: ? Write queries in Microsoft Access. ? Build macros in various platforms for online data mining. ? Use Google Sheets and Excel to prepare budgets and run analysis. ? Support staff with basic desktop support. ? Support in migrating Access database into web based platform. Required Skills: ? Working knowledge of Microsoft Access. ? Dependable and available in morning hours during weekdays. ? Verbal and Written Communication skills. Ample future growth opportunities a...
Category: Data Analysis       
Preferred Location: United States

L****ies
 [?]
Sign in to view client's details.
| L****ies
|    United States
Fixed Price: $500 - $1,000   |  Posted: Jun 27, 2015  |  Ends: 27d, 0h  |   6 Proposals
I need help from someone who is expert in the field of Java and Excel, to convert my xls file that contains macros into a single Java program that can be displayed on my website. Terms: 1. I want all buttons, tables, views within the website looks modern 2. I want to use mysql database 3. I want someone who has expertise in this matter because this big project 4. The person must have skype and should have a pleasant working attitude 5. Must be able and understand Indonesia language for a database project in the Indonesian language Only a qualified person who will be interview via skype Thanks Job Description: Your responsibilities: - Convert Excel (xls 2013) with Macro to Java - Create a website that displays the entire program - The website should be accessible via mobile, tablet, iphone, etc - Fast Response via skype, eg : if i want to ask anything - Creating a demo of the application, because my clients want to know how it looks like, no down payment until i see the demo...
Category: Web Programming       

d****ndo
 [?]
Sign in to view client's details.
| d****ndo
|    Indonesia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 27, 2015  |  Ends: 11d, 20h  |   5 Proposals
We are looking for a talented UX/UI designer to help us in creating a first-class user experience for a modern Windows desktop application. We have been through a first prototyping stage in-house, and are now looking for a designer that can help us create a user-friendly and aesthetically pleasing design based on our partial prototypes, design sketches and conceptual wireframes. Excellent communication skills and working knowledge about Microsoft User Experience and User Interface Guidelines is essential.
Category: User Experience Design       

C****014
 [?]
Sign in to view client's details.
| C****014
|    Sweden
Fixed Price: Less than $500   |  Posted: Jun 27, 2015  |  Ends: 11d, 14h  |   6 Proposals
Hello, This job is very urgent basis. I need person or group who has experience in Rest, Excel Upload and scraping. Basic requirement is we have to create a panel where we can add client data with some excel and basic information. Monthly basic we have to scrap data for this particular client and save it. Also need functionality of post some news. Monthly basis update via mail(Mailchimp). We will use this api for data feed for client side . You have to build client portal also where he/she can able to see their monthly basis data. Job Description: We're looking for a Web Developer. Your responsibilities: - Review business requirements - Perform a technical analysis of requirements - Produce a solid, detailed technical design - Write clean, modular, robust code to implement the desired requirements - Contribute ideas for making the application better and easier to use Your qualifications: - A work style that is extremely detail oriented - A complete Elance profile - ...
Category: Web Programming       

a****aha
 [?]
Sign in to view client's details.
| a****aha *
|    India
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 27, 2015  |  Ends: 26d, 14h  |   8 Proposals
Seeking for Tableau Visualization Expert in Bangkok (Thailand) area. We are a growing startup located in central Bangkok. Responsibilities: - Collaborate and consult with other staff, including subject matter experts and business analysts, to gather data visualization requirements - Participate in design sessions and provide technical expertise - Develop Tableau reports, dashboards and other visualization solutions - Support the Tableau environment Working permit is available. Please contact for more info.
Category: Business Intelligence       
Skills: SQL, Microsoft Excel PowerPivot, Tableau       

m****rli
 [?]
Sign in to view client's details.
| m****rli
|    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