Save this Search
     

All JobsMicrosoft ExcelIT & Programming

 123 results  
Sort by:
  • Posted Date
Fixed Price: Not Sure   |  Posted: 3h, 40m ago  |  Ends: 14d, 20h  |   10 Proposals
We need an excel formula that will take the following format (3 days 7 hr 37 min) and convert that into two columns. We need to be able to convert this format based on the current date and time. One that will be the end date in MM/DD/YY format and second another that will be in HH/MM format so that we can sort on those columns. These two formulas would have to work with Excel 2007.
Category: Other IT & Programming       
Skills: Microsoft Excel       

P****rop
 [?]
Sign in to view client's details.
| P****rop
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 3h, 57m ago  |  Ends: 1d, 20h  |   2 Proposals
Good day people of Elance - hope you're well and I look forward to the possibility of working together. I'm posting here today because I have need for some help with data analysis of an Excel spreadsheet. The data is organized into 10,610 lines and a total of 7 columns. In the end, I would like the spreadsheet returned with your creations built into additional tabs along with the appropriate tables answering the questions below. Given the small size of the project I would appreciate a super quick turn around time, I would even ask ASAP if your schedule allows. Some of the data is lightly masked, so when your work is completed, I'd simply like to unmask the data on my end and have all of your work adjust to those changes. In short, I need everything linked together so that a change made on the data tab will roll through everything. Raw data integrity is high and has been reviewed. I will need a total of 5 tables summarizing the data. I will subsequently use your constructed tab...
Category: Data Analysis       

W****ire
 [?]
Sign in to view client's details.
| W****ire
|    United States
Fixed Price: Less than $500   |  Posted: 5h, 52m ago  |  Ends: 14d, 18h  |   14 Proposals
I have a list of first names and cities these people live in that are political donors. I need them matched to a list of 270,000 full names and addresses to tie the donors to the full list of people that live in the cities of our county, etc. I need someone who is a VERY good Excel programmer and can turn this job around quickly. Thank you!
Category: Database Administration       
Skills: Microsoft Excel       

a****usa
 [?]
Sign in to view client's details.
| a****usa
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 10h, 48m ago  |  Ends: 2d, 13h  |   21 Proposals
We need to create a set of dashboards. The first is a small one with only a few data points but needs to be graphically interesting as it will be pushed into an app (pdf). After this, there are metrics we would like to track in dashboard format - all data sources come from our monthly financial report.
Category: Data Analysis       
Skills: Microsoft Excel       

a****635
 [?]
Sign in to view client's details.
| a****635
|    United States
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: 13h, 59m ago  |  Ends: 40d, 6h  |   6 Proposals
We are a third party construction consultant for construction lenders who is hired to monitor commercial construction projects and their monthly billings for our clients. We have a word template that we use, but we are producing 40-50 a month and need to increase efficiencies in our template and report preparation processes. Our template is Microsoft word based with an embedded excel spreadsheet, drop downs, etc. we need a Microsoft word expert in Portland, OR
Category: User Experience Design       
Preferred Location: United States

b****ald
 [?]
Sign in to view client's details.
| b****ald
|    United States
Fixed Price: Less than $500   |  Posted: 19h, 1m ago  |  Ends: 14d, 4h  |   9 Proposals
I want to develop a simple GUI which will show a form and ask user to input a file name. Application will call another vb script to do some processing with that input file. user can enter file name and execute now. or can submit a job to windows task scheduler. Please give me quotation or let me know if you need more details. Check attached excel for more details
Category: Software Application       
Skills: Microsoft Visual Studio, Java       

g****ath
 [?]
Sign in to view client's details.
| g****ath
|    India
Hourly Rate: Less than $10 / hr   |  Duration: 7-9 months  |  Posted: 22h, 30m ago  |  Ends: 14d, 1h  |   5 Proposals
ABOUT US: Latitude 365 provides customized subscription software designed for managing operating expenses for yachts, private homes and planes worldwide. It is built to simplify, streamline, and automate accounting for these special properties. The company was founded in 2010 in the US and is now building its presence in Europe. We already support clients in the US, Monaco, France, United Kingdom, Germany, Russia and more. You can find more information on our website   [obscured]   TIMEZONE: Work on european central time QUALIFICATIONS: Excellent English writing and speaking skills Experience providing tech support Understanding bookkeeping SOFTWARE SKILLS: Filemaker Helpdesk software (like zendesk) Photoshop Quickbooks Excel, Word, Powerpoint Windows & Mac OS Social Networks (LinkedIn, Facebook) Would be a plus to have knowledge of: Salesforce Wordpress HTML SEO Great Attention to detail Extremely organized Good with people on the phone, charismatic Analytical skills ...
Category: Technical Support       
Preferred Location: Philippines

l****tes
 [?]
Sign in to view client's details.
| l****tes
|    United States
Fixed Price: $25 - $35   |  Posted: 23h, 56m ago  |  Ends: 6d, 0h  |   11 Proposals
I need to manipulate Excel data from Sheet-A to Sheet-B as per attached 2 sheets. There are two types of fields: (1) Fixed "as is" data and (2) data to be manipulated from Sheet-A to Sheet-B. You will use Sheet-A to create Sheet-B. I need a simple and short Windows application program to manipulate this data within 2 days. 07/12/2014 at 14:53 EDT - Additional information submitted Addendum: I want to clerify additional points. 1. This is an import to Quickbooks Inventory addition. 2. Colors are not required. I colored them to show relationships between data fields 3. The data fields are two types: a. Data in colored boxes is variable and also colored. This is the data that is to be copied to destination worksheet-B b. Data in other fields remains "as is" 4. Items names ending with ^ are Parents. In this example, TIL12951#1^ & 8-368412#12^ are parents. 5. Items without ^ are children. So for example I buy 1...
Category: Other IT & Programming       

i****aya
 [?]
Sign in to view client's details.
| i****aya
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: 4-6 months  |  Posted: Jul 11, 2014  |  Ends: 13d, 19h  |   19 Proposals
We are looking for someone who is used to manipulating data in excel for new product uploads. Ongoing work. The amount of products in the spreadsheet will vary. From a couple hundred lines to a couple thousand per spreadsheet. We will provide template to convert data into , the product spreadsheet and image library. Feel free to post per hour rates or per sku rate..
Category: Data Analysis       
Skills: Data Entry, Microsoft Excel       

k****ery
 [?]
Sign in to view client's details.
| k****ery
|    United States
Fixed Price: Not Sure   |  Posted: Jul 11, 2014  |  Ends: 13d, 15h  |   12 Proposals
I would like a FMP database that will store sortable work order info. The fields are: Building/ Room Number, Due Date, Task Number, Crew Leader, Completion Date, Area Manager, Work Order Amount. Building / Room Number will be a drop down menu whereby the Building name will be in the menu and I would then add the room number to the field. The Area Manager field will be a look up based on the Building / Room Number field. Crew Leader a drop down menu (or auto fill). Completion Date will be Today -1. (because the info will be entered the day after the work is actually done) One purpose of this data base will be to sort the data (find) by completion date , copy and paste a table into the body of an email to send to area managers daily. We work in different "areas" and need to to sort the data alpha then numerically by Building / Room Number. The data needs to be "chunked" by Building name (building name headings followed underneath by the Building / Room Number info. ...
Category: Database Development       

r****ony
 [?]
Sign in to view client's details.
| r****ony
|    United States
Fixed Price: $500 - $1,200   |  Posted: Jul 11, 2014  |  Ends: 5d, 14h  |   30 Proposals
-Convert 100 Excel/PDF pages to clean HTML - (  [obscured]  /catalog/ets.pdf) -Add borders to the tables -add table mouse over effect to highlight the row in the tables -Images must be added individually, not collaged -Images named by their presentation name and label -Pages titled per my instruction -Create a header and footer from my concept -Dynamically attach headers and footers on pages so they can be changed from one file each. Please send 1 sample of an HTML page you code from a page from the PDF link above. Make sure it is a product page, not an index page.
Category: Website Design       
Skills: Microsoft Excel, HTML, PDF       

t****y67
 [?]
Sign in to view client's details.
| t****y67
|    United States
Fixed Price: Less than $500   |  Posted: Jul 11, 2014  |  Ends: 13d, 14h  |   11 Proposals
We currently have about 4,800 orders that we need to import into Woocommerce as we switch eCommerce solutions. We have purchased and installed "Customer/Order/Coupon CSV Import Suite" (  [obscured]  /document/customer-order-csv-import-suite/). Our csv from the previous ecommerce system has exported all orders so that products in a single order are listed in sequential rows - for example if a customer ordered 12 products in order #4000, the csv will have 12 rows of attributes for the order. The problem is that the woocommerce extension to import these products request that every order be placed in the same row, and data be consolidated so each product be placed in a column, not a row as in our export data. There are over 19,000 rows of export data. We are looking for someone to do the following: 1. Provide the simplest solution to import data for our 4,800 orders into woocommerce, either with the CSV import suite extension or without. 2. If with the CSV, figure a...
Category: Database Administration       

I****Med
 [?]
Sign in to view client's details.
| I****Med
|    United States
Fixed Price: Less than $500   |  Posted: Jul 11, 2014  |  Ends: 1d, 10h  |   19 Proposals
Hi, We operate a training business and advertised for an Enquiry Management System (EMS) last year. It was meant to be a simple system to allow us to move away from Excel and we had a mixture of Access based (with an SQL backend) and PHP based solutions. We opted for an Access based option on the basis that many of our offices are in Africa and internet connections sometimes drop off for a day or so, and we wanted a system that could be used offline and would synchronise when the internet was back up. Unfortunately the Elancer chosen for the job has let us down in a major way. The system has some minor bugs and we have been promised each week that the elancer will fix then, but having had the run-around for several weeks, we would like the database cleared so we can restart it from blank. Some issues are: 1. when we enter things into fields which are meant to be compulsory, when we come back to the enquiry page, those fields are blank. 2. when we try to edit enquiries, we get a &...
Category: Database Development       

T****286
 [?]
Sign in to view client's details.
| T****286
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 10, 2014  |  Ends: 12d, 23h  |   12 Proposals
I am a real estate appraiser and currently use a tool that I designed (was programmed by an excel expert). The current excel-based tool requires that I cut-and-paste the data I want to analyze, then it fills in calculations on a spreadsheet that I then print to a pdf. If I want to run a different report (for example, for a different subdivision, different group of properties, different market area, different date, etc.), then I need to delete the data I pasted in, then go cut-and-paste the new set from the file I exported from the local MLS (the realtor sales system). Also, it is pretty "static" in that it is only programmed to work with my MLS exports, with the exact order of columns, sales are delineated a certain way, listings are delineated a certain way, and so on, so that I can't share the tool with others, since it is a very "manual" task to run any report. As my local MLS systems change formats, labels, etc. for the data and columns, then I have to manually ...
Category: Data Analysis       
Skills: Microsoft Excel       

j****itt
 [?]
Sign in to view client's details.
| j****itt
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 10, 2014  |  Ends: 87d, 22h  |   13 Proposals
CCNA Job Description: Your responsibilities: - Review business requirements working with other team members - Perform a technical analysis of requirements - Produce a solid, detailed technical design - Write clean, modular, robust code to implement the desired requirements with little or no supervision - Work with the QA and Customer Support teams to triage and fix bugs with rapid turnaround - Contribute ideas for making the application better and easier to use Your qualifications: - A work style that is extremely detail oriented - Strong communication skills - A complete Elance profile - References or an established reputation on Elance preferred
Category: Networking & Security       
Skills: Microsoft Excel, C, HTML, CCNA, Photo Editing       

s****r_5
 [?]
Sign in to view client's details.
| s****r_5
|    Bangladesh
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 10, 2014  |  Ends: 12d, 20h  |   20 Proposals
Hello, We are a large company that sells products on Amazon. Every two weeks we receive a report on the sales/returns/reimbursements. We then take that file in excel and start reporting on each model/sku how many were sold and at what price. We are looking to automate this process every two weeks so that there is no room for error. If you have experience with Amazon and Excel on how to program the report to give us the data that we need each time on demand. Looking forward to your proposals and experience.
Category: Data Analysis       
Skills: Microsoft Excel, Sales, Accounting, Database       

A****904
 [?]
Sign in to view client's details.
| A****904
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 10, 2014  |  Ends: 12d, 18h  |   27 Proposals
Our database offers a label download that is not copyable with the style of labels we are forced to use (by virtue of our copier). We need a macro that will structure the data from our csv file to fit in a custom label format.
Category: Database Development       
Skills: Microsoft Excel       

b****slc
 [?]
Sign in to view client's details.
| b****slc
|    United States
Fixed Price: $5,000 - $10,000   |  Posted: Jul 10, 2014  |  Ends: 12d, 16h  |   61 Proposals
We're looking for a web developer to build an online tool to allow users to examine their performance in forecasting the sales of individual products. We've attached a functional specification which includes screenshots of the type of charts & drill down functionality required. Here's a summary of the functional specification : 1. Allow users to upload an excel template file containing sales & forecasting data. 2. Validate that the data in the excel file does not contain any errors or missing values. 3. Clean the data (e.g. Remove any zero or negative values). 4. Calculate the forecast performance: we will provide the calculation which involves calculating the average and standard deviation of the sales & forecast of each product. 5. Display results in 3 graphs: 5.1. The first graph is a bubble chart of all products with different colours for different product categories. When users select a specific bubble the second graph is activated: 5.2. The second grap...
Category: Web Programming       

B****use
 [?]
Sign in to view client's details.
| B****use
|    United Kingdom
Fixed Price: $500 - $1,000   |  Posted: Jul 10, 2014  |  Ends: 12d, 12h  |   14 Proposals
I need some one with real experience developing accounting system and Point of sales to develop my project. The system need the following modules as any normal ERP: - General accounting * Cycle Accounting management (open and closing monthly and yearly period). * Chart of Account (by nature, periodicity of flow, etc) * Account History. * Major * General Ledger. * Payable Accounts Managent. * Receivable Account Management. * Fixed Assets. * Bank Reconciliation. * Print Voucher Transactions. * Financial Reports. * Budget management. * Import Chart of Account by uploading an cvs or excell file. * - Point of Sales * Inventory Management. * Cashier Role Asigment. * Open and closing Cashier. * Printing Recipient. * Returning Merchandise. * Sales. * Reports. * Post in General Ledger by WebApi - Membership asigning up and payment information. This project should work over microsoft framework 4.0 minimum, asp.net MVC, AngujarJS, Boostrap for look and feel (should be a ...
Category: Web Programming       

R****oft
 [?]
Sign in to view client's details.
| R****oft
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 09, 2014  |  Ends: 12d, 3h  |   21 Proposals
I need a sellers inventory and sales spreadsheet created to run my company. We are growing fast and need a spreadsheet that will track all sales and keep inventory count and also do a few more things. We would eventually like to create our own database and app as well.
Category: Database Development       
Skills: Microsoft Excel       

T****alk
 [?]
Sign in to view client's details.
| T****alk
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 09, 2014  |  Ends: 12d, 2h  |   7 Proposals
I need to extract data from a cloud based system (API method and documents available). Then I need to create custom reports. I will need multiple data extracts from multiple customer files. I will need mulitple reports. I will need to deploy these tools across multiple customers to meet requirements. Excel 2013, Access 2013, SQL, or other tools will be required
Category: Data Analysis       
Skills: Report Writing, Microsoft Excel, API, Database       

g****cfo
 [?]
Sign in to view client's details.
| g****cfo
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 09, 2014  |  Ends: 11d, 23h  |   8 Proposals
Hi, we wish to make our price list more efficient and look nicer Plus get a quotation spreadsheet Thanks
Category: User Experience Design       
Skills: Microsoft Excel, Spreadsheets       

P****l_J
 [?]
Sign in to view client's details.
| P****l_J
|    Australia
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Jul 09, 2014  |  Ends: 11d, 21h  |   6 Proposals
Excel expert. I have created an automatic report that downloads from a company's general ledger. I this report, with a couple of additional reports with supplemental information, populate a report that is required by a tax agency for VAT reporting.
Category: Database Administration       

F****-as
 [?]
Sign in to view client's details.
| F****-as
|    Guatemala
Fixed Price: Less than $500   |  Posted: Jul 09, 2014  |  Ends: 11d, 19h  |   23 Proposals
I need someone to Design a Simple Practice Management Database based on my existing excel files. Contact and Services Management, Session Credit Purchase and Use log and Paid in Paid out Ledger
Category: Database Development       

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