Save this Search
     

All JobsMicrosoft ExcelIT & Programming

 (54 results)  
Sort by:
  • Posted Date
Fixed Price: Less than $500   |  Posted: 10h, 1m ago  |  Ends: 14d, 13h  |   18 Proposals
I need to design a receipt book in excel with some of the requirements listed below: - The receipt need to look like the attachment - Receipt No to be a recurring number and cannot be changed/edited - Date to be auto generated - Received from need to have 2 drop down options (Business / Individual) - If Individual is selected from drop down, then received from must prompt to fill 4 fields (first name, middle name, last name & gaam (city) all fields to be compulsory) - If business is selected then we only need one line to be filled (compulsory) - Field for amount (numerical value with 2 decimal) - Payment made type as per attachment (Bank Direct Deposit, Cash, Cheque, Eftpos, Other) - Received with thanks for: as per attachment - Received with thanks by: name of person signed in. Need this receipt book to require a user to enter their login details before they can access the receipt book to write any receipts. The name of the logged in user need to be added by default to "Rec...
Category: Other IT & Programming       
Skills: Microsoft Excel, Excel VBA       

k****ani
 [?]
Sign in to view client's details.
| k****ani
|    Australia
Fixed Price: $20 - $200   |  Posted: 20h, 4m ago  |  Ends: 6d, 3h  |   23 Proposals
This is the site:   [obscured]  /Best-Sellers/zgbs/ref=zg_bs_unv_e_0_e_1 We need list of all the products in top 100 best sellers in every department(37 or 38 departments ,every with 100 products) and to put them in excel spreadsheet. We are searching for 13 details to scrape of every product: Department Number Name of Product by: Customer Reviews Answers List Price: Price: You Save: Info1 Info2 Date First Available Star Rating Percentages More details to be provided individually.We are searching for people with experience.Add "West Ham" at the end of your message.
Category: Web Programming       
Skills: Microsoft Excel, Web scraping       

w****nho
 [?]
Sign in to view client's details.
| w****nho
|    Spain
Fixed Price: Not Sure   |  Posted: Aug 30, 2015  |  Ends: 13d, 9h  |   10 Proposals
I currently plot support and resistance zones manually on a chart like the attached image. Then I manually enter these figures into MS Excel to determine if today's price is within the Support and resistance zones. WHAT I NEED I need to calculate these support and resistance levels within MS Excel programmatically or using some sort of algorithm. I currently download daily data that includes open, high, low, and close values for each currency pair or stock symbol. So this granular data can be used to calculate what is required.
Category: Other IT & Programming       

a****503
 [?]
Sign in to view client's details.
| a****503
Fixed Price: $30 or less   |  Posted: Aug 30, 2015  |  Ends: 13d, 6h  |   27 Proposals
Hello, I have some data in excel...which is organized vertically..... Col A-D are: ID tp dg prm value prm are variaus variables like HS, CD etc.... value is the value of the prm variables... I just need a formula or VBA to find the smallest tp value when one of the prm variable is 0 or 1. I can send a sample and some examples if needed. It is not a simple if then else statement....you might need to use index array small etc type of formula....or maybe vba All F cells should have a value....(all IDs have only one possible value of F cell) Step 2 will be organizing this data horizontally...(this might be easy)
Category: Data Analysis       
Skills: Microsoft Excel, VBA       

j****son
 [?]
Sign in to view client's details.
| j****son
|    United States
Fixed Price: Less than $500   |  Posted: Aug 29, 2015  |  Ends: 12d, 7h  |   6 Proposals
Need someone to edit our Google Sheets spreadsheet and create a template. 1. The sheet needs to be able for us to enter a time (like 8:47 as an example) 2. The sheet needs to be able to add times (ie the time above is 8 hours and 47 minutes. I'll have another column where we might be able to enter 1:20 and then we can sum these numbers and the caluclation determines that the total is 10:07 3. Then we need to be able to take a date calcuation and divide it by a number. for example 8:48 divided by 2 would be 4:24) The number 2 would be in another column. I can share our current sheet with you to edit it for us (again, we are looking for a template)
Category: Data Analysis       
Skills: Microsoft Excel, google sheets       

p****nta
 [?]
Sign in to view client's details.
| p****nta
|    United States
Hourly Rate: $20 - $40 / hr   |  Duration: 1-2 weeks  |  Posted: Aug 28, 2015  |  Ends: 11d, 8h  |   31 Proposals
I am looking for someone to test existing software in a Sharepoint environment, and help modify the existing code base to support compatibility with Sharepoint. The software is a suite of VSTO add-ins for Excel, PowerPoint, and Word. The software is written in VB.NET, so the provider must be highly proficient in VB.NET or C#. If the provider is highly proficient in C#, but less so in VB.NET, I would expect the provider to at least assist with C# code conversion to VB.NET when needed. We will work closely together on testing part of this project, communicating via screen share, chat, phone, etc. as needed, so strong English verbal and written communication skills are important. The provider must also have access to and be familiar with Office 2010 or 2013, and develop in Visual Studio. It is difficult to say what the length of the project will be, or how much time is required before we begin, since I am not sure what we will uncover during testing, or how much code modification wi...
Category: Other IT & Programming       

r****acg
 [?]
Sign in to view client's details.
| r****acg
|    United States
Hourly Rate: $20 - $30 / hr   |  Duration: 7-9 months  |  Posted: Aug 28, 2015  |  Ends: 26d, 0h  |   174 Proposals
I am looking for Sr. .Net web developers to assemble a team to support a US based company with major web contracts with companies like Vidal Sasson, Coleman, P&G and various other big name companies. I am looking to build a strong relationship with a small development firm for 3 Sr. Devs to begin with with addition of more after proven and the team to work together for years to come. We are NOT looking for people to join for a short period and then leave. Must have good to excellent English speaking skills for EVERY developer. I cannot stress this enough. The team can not work through a single person because only 1 speaks good english. Primary Responsibilities Create web sites and applications utilizing the technologies listed Support web sites and applications Requirements Gathering Designing technical specifications Quality Assurance testing Perform maintenance on database-driven web applications Develop process improvements Knowledge & Understanding Multi-tier web ...
Category: Web Programming       

b****060
 [?]
Sign in to view client's details.
| b****060
|    United States
Fixed Price: Not Sure   |  Posted: Aug 28, 2015  |  Ends: 11d, 0h  |   9 Proposals
Create/ Customise Profit and loss accounts and balance sheet for Photography Company Must be simple and easy to use... as long as it is customise according to company's need It can even be just a simple excel but must work on MAC /OS X
Category: Other IT & Programming       
Skills: Microsoft Excel, MySQL Administration, HTML, PHP       

c****hiu
 [?]
Sign in to view client's details.
| c****hiu
|    Australia
Fixed Price: Less than $500   |  Posted: Aug 28, 2015  |  Ends: 10d, 21h  |   52 Proposals
Hi, I have a small excel project which will most likely require a VBA script as it involves around 1,000 rows of data for 308 days. It involves 1st searching the field of data to find a list of unique numbers then populating each day of with year (from 27/8/14 to 30/6/15) with an AM & PM time if found for those unique numbers. The 2nd requirement is filling another spreadsheet with unique numbers that have no AM & PM times in the data set & the 3rd requirement involves ranking those that do have AM/PM times in order of the number of days missed. I will share the file with those who apply & negotiate a set price then. It is difficult to fully explain without first seeing the file. Thanks
Category: Data Analysis       

d****e83
 [?]
Sign in to view client's details.
| d****e83
|    Australia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 28, 2015  |  Ends: 10d, 19h  |   28 Proposals
Combine 2 existing excel worksheets into a single workbook. Each sheet will be linked to the other. The number of visible/printable rows in one sheet, will determine the number of visible/printed rows in the second sheet. The sheet also needs to be able to SUM values based on a check box being checked/unchecked. It is very important that the page layout does not change in either sheet - it must remain exactly the same when merged.
Category: Software Application       
Skills: Microsoft Excel, VBA, Visual Basic       

a****r83
 [?]
Sign in to view client's details.
| a****r83
|    Australia
Fixed Price: Not Sure   |  Posted: Aug 27, 2015  |  Ends: 10d, 9h  |   6 Proposals
Need a script run, so can quickly grab all variables, and dependent variables to spit out a CSV of every variation possible. Many columns have multiple options, and others have dependent options. Please view the attached spreadsheet for reference. Please reference similar work you've done, cost, and time frame to be considered. Need done as soon as possible.
Category: Data Engineering       
Skills: Script Writing, Microsoft Excel       

q****ler
 [?]
Sign in to view client's details.
| q****ler
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 27, 2015  |  Ends: 10d, 6h  |   19 Proposals
Hi, We need an Excel or Access template that we can use to track our Warehouse Management and Inventory. We currently use several different forms and would like to automate this process as much as possible until we are able to afford a sophisticated software. The template will need the following: 1) Receive Shipment - Generate inbound shipment detail (Track how many pallets we received, weight, vendor), print a 4x6 label and print an inbound report. 2) Resale Inventory - Items we receive either has resale value or will be recycled. We will generate item details (Manufacturer, Model Number, Inbound No., Serial Number and etc.) and generate a barcode label. Inventory will need to have ability to filter and print out CSV file to send current inventory to customers or to upload to online to sale on our various ecommerce sites. 3) Recycle Inventory - Track items we are recycling by weight and category. 4) Reporting System - Track each inbound shipment by total weight received. Show what w...
Category: Database Development       

e****jwi
 [?]
Sign in to view client's details.
| e****jwi
|    United States
Fixed Price: $1,000 - $5,000   |  Posted: Aug 27, 2015  |  Ends: 20d, 19h  |   3 Proposals
PLEASE DONT BID IF YOU DONT KNOW POWERSHELL SCRIPTING 8+ years of experience Technical certifications (i.e., Microsoft, CompTIA) Excellent written and verbal skills; bi-lingual skills is a plus Excellent with programing languages such as .NET, VB Script, Powershell Bachelors degree in computer science, engineering, or equivalent work experience
Category: System Administration       

b****omu
 [?]
Sign in to view client's details.
| b****omu *
|    India
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 27, 2015  |  Ends: 9d, 22h  |   22 Proposals
We are due to launch our unique eCommerce store and in the pre-launching phase. We have a number of supplier spreadsheets given in excel format, which require scripting and customization. Example tasks will include scripting details from the product titles, scripting colors from the description etc and inputting into separate columns. Please apply if you are expert in this field and can start immediately. Any experience working with Magento formatted spreadsheets for configurable products would be a huge bonus. Thank you
Category: Other IT & Programming       
Skills: Microsoft Excel, Magento, Scripting       

k****p01
 [?]
Sign in to view client's details.
| k****p01
|    United States
Fixed Price: Less than $500   |  Posted: Aug 26, 2015  |  Ends: 9d, 13h  |   15 Proposals
i have an optimizer spreadsheet tool for fantasy sports , the tool needs couple new connections, speeding up the tool and also more modern look to it , fixing code
Category: Other IT & Programming       

R****o23
 [?]
Sign in to view client's details.
| R****o23
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 26, 2015  |  Ends: 8d, 21h  |   19 Proposals
we need someone who can develop a functionality on excel using Macros. Submit your bid with your previous experience. We need someone who can start working on it quickly or available to work on it after awarding. See attachment for functionality.
Category: Other - Data Science       
Skills: Microsoft Excel, VBA, Excel VBA       

e****ing
 [?]
Sign in to view client's details.
| e****ing
|    India
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Aug 26, 2015  |  Ends: 8d, 20h  |   19 Proposals
I am looking for a highly skilled MS Access, Excel developer who is excellent in VBA (Visual Basic for Applications). This is going to be a long term engagement for multiple projects. I am myself an advanced Access/Excel/VBA developer and I am very detail oriented, hence, my expectations are high for this candidate. Following are my core requirements: - Highly skilled in MS Access, Excel, VBA development - Detailed oriented & focused on developing good UI (User interface). If you are not UI focused, then do NOT apply - Flexible in approach & open to suggestions. As the Solution Architect on my projects, I will often provide direction/advise & candidate should be open to it - Be able to accommodate phone calls during US time zones - Be able to communicate via smart phone on updates - Good communication skills, English or Hindi - Thinks outside the box Again, I am not looking for mid-level, I am looking for advanced.
Category: Other IT & Programming       
Skills: VBA, Microsoft Access Programming, Excel VBA       
Preferred Location: India

d****onz
 [?]
Sign in to view client's details.
| d****onz
|    United States
Hourly Rate: $40 - $50 / hr   |  Duration: 1-3 months  |  Posted: Aug 25, 2015  |  Ends: 8d, 12h  |   13 Proposals
I am looking to hire 1-2 VBA developers to both train me in VBA for Excel. The ultimate goal of this project is to turn that training into a book on VBA for Excel. After each training session, I will turn my notes into a written chapter, which I will then ask you to edit to ensure technical accuracy. I'm looking for 2 individuals with minimum 5-6 hours of availability per week: 2-3 hours for training, and 2-3 hours of reviewing the written work I provide. The sessions will be held remotely via Skype. I have previously worked with a VBA developer team on this project, and so the first step of this project will be to bring you up to speed on what we've already accomplished. Among other things, we have provided a laymen's definition for all 280+ objects within VBA (as opposed to the extremely technical definitions provided by Microsoft). In short, I am looking to create a novel approach to teaching this language. My thinking is that the entire language is essentially two things: top...
Category: Software Application       
Skills: Microsoft Excel, VBA, Excel VBA       

a****eab
 [?]
Sign in to view client's details.
| a****eab
|    United States
Fixed Price: Not Sure   |  Posted: Aug 25, 2015  |  Ends: 10h, 16m  |   9 Proposals
Hello, We had a task for following: We are small recruitment company, we need to customize google sheet work flow to see works process, candidates' status etc . We will input works: Task type: Placement+WP (work permit) Placement Work Permit name of the employee, employer, status, gender, title, nationality and will be able to filter by these categories, job end date (somehow calendar will warn users particular time before job end date) we will keep this file on google drive and will be used and updated by our employees. Freelancer did most of tasks thay only left to input some creterias etc. Here is the file:   [obscured]  /folderview?id=0B4L2747o... We need to do on this file to organize the column employer and its facilities. We must be able to chose candidates' employer and facility where employee is working. So first need to input the employers and their facilities. Note that employer may have more than 1 facility. Shortly we need to improve this da...
Category: Database Development       

e****tun
 [?]
Sign in to view client's details.
| e****tun
|    United States
Hourly Rate: Not Sure   |  Duration: 7-9 months  |  Posted: Aug 25, 2015  |  Ends: 8d, 4h  |   40 Proposals
We are an MSP looking for Level 2 and 3 technicians to support our technicians and clients over phone, email, and remote desktop support. Successful Candidates must have excellent communication Skills in Spoken and written English. Must have access to reliable internet 24/7 (minimum of 4 MBPS). Must have experience in supporting clients in the US via voice and remote support. Support Areas: VMWare Administration, Windows Server, Windows Desktop, Active Directory, Server maintenance, Domain Services, Cisco Networking, and Exchange. Experience: -Installation/configuration, operation, and maintenance of systems hardware and software Maintain system-level security controls, system configuration documentation, and configuration management Review audit, system and application logs Store, retrieve, manipulate and analyze data from databases Minimum Requirements Technical background: o 6-8 years' experience with degree in Information Technology, Computer Programming, Co...
Category: System Administration       

r****din
 [?]
Sign in to view client's details.
| r****din
|    United States
Fixed Price: Not Sure   |  Posted: Aug 25, 2015  |  Ends: 7d, 17h  |   12 Proposals
We want to build a freight audit tool on an Excel platform - that will receive uniform invoice statements in Excel, and in real time, compare the "billed" rate to the anticipated rate for the trade route. We are looking for any experts that have experience in either freight audit or transportation audit who would like to build a tool for us, and this tool would have to have a graphical interface for customer access at some point. Preferred candidate might have worked in India or Philippines doing ocean freight programming for a large ocean carrier or 3PL.
Category: Software Application       
Skills: Microsoft Excel       

o****ght
 [?]
Sign in to view client's details.
| o****ght
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 24, 2015  |  Ends: 7d, 5h  |   27 Proposals
Job brief We are looking for an experienced Project Manager who will take on the management of key client projects with the goal of delivering every project on time, within budget and within scope. Must be conversant in English as many voice conference calls will take place as part of the job. Must be available during core (10am to 3pm) hours of US Eastern timezone. Responsibilities Ensure that all projects are delivered on-time, within scope and within budget Assist in the definition of project scope and objectives, involving all relevant stakeholders and ensuring technical feasibility Ensure resource availability and allocation Develop a detailed project plan to monitor and track progress Manage changes to the project scope, project schedule, and project costs using appropriate verification techniques Measure project performance using appropriate tools and techniques Report and escalate to management as needed Successfully manage the relationship with the client and all stakehold...
Category: Project Management       
Preferred Location: North America, Eastern Europe

a****phy
 [?]
Sign in to view client's details.
| a****phy
|    United States
Fixed Price: $50 - $150   |  Posted: Aug 24, 2015  |  Ends: 7d, 4h  |   4 Proposals
Excel file with 3 columns: customer number, article/product number and Amount are available. The invoice should be created in Fortnox (  [obscured]  /) with the data contained in the Excel file. One invoice per line from the Excel file. Customer number and article/product numbers are the same as already uploaded in Fortnox. Prices should be download in Fortnox from the customer's price list. The excel file comes from logistics programs and include deliveries to customers of the articles/products. The file contains 3 columns needed to create the invoice. Each row represents a dispatch, and each row / sendout should generate an invoice. 1) Customer number = Identifies the customer, the customer is posted in Fortnox with this customer number. Returning customers. 2) article/product number = Identifies which article it is that should be sent out. The article is structured in Fortnox with the same part article/product number. 3) Amount = Identifies the number of the article/pr...
Category: Other IT & Programming       
Preferred Location: Eastern Europe

m****ski
 [?]
Sign in to view client's details.
| m****ski
|    Poland
Hourly Rate: Less than $10 / hr   |  Duration: Not Sure  |  Posted: Aug 24, 2015  |  Ends: 6d, 21h  |   29 Proposals
We have 7 files which has data related to orders, invoice, bookings, users, merchants, all of them have unique id and other parameters. Based on the above data, we need someone to extract exact data that we need. The task should take around 2 hours. Deadline: 24 hours.
Category: Data Analysis       
Skills: Microsoft Excel       

m****rks
 [?]
Sign in to view client's details.
| m****rks
|    India
Fixed Price: $50 - $75   |  Posted: Aug 24, 2015  |  Ends: 6d, 19h  |   17 Proposals
We need an excel database developed that can be used to cross-reference part numbers from the original manufacturer numbers to a set of new part numbers as supplied by our own parts list. The original manufacturer number may also suit a range of different brands of equipment and we would need these listed whenever a filtered search is used. To sum up, a part number will be entered in to the spreadsheet using a filter (if this is the best method), and a range of parts (to suit different makes and models of equipment) that match this item or that the item can replace will be listed. We already have excel spreadsheets with the part numbers to be cross-referenced attached for use if this is easier. Many thanks, Craig Collins. Aussie Powersports.
Category: Database Development       

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