Save this Search
     

All JobsMicrosoft ExcelIT & Programming

 (158 results)  
Sort by:
  • Posted Date
IT & Programming
Hourly Rate: $10 - $30 / hr   |  Duration: Not Sure  |  Posted: Apr 25, 2015  |  Ends: 12d, 2h  |   10 Proposals
This is a chart for a report for a medical company. Attached is the excel chart and notes as well as a draft of the report it will fit it. It is essentially a chart with a two-tiered date axis with proper day in month spacing. This needs to be completed in the next 24 hours and I assume that an expert could complete the job in less than 2 hours. I will be using this on a mac, so as long as I can copy it to mac format and have it work that is ok. Please look over the excel data and report it goes into and be sure you are able to do this before responding. I am open to having this done in numbers or another program if it is better done in something else. I am hoping to find someone who can also assist me with other excel, and presentation materials in the future.
Category: Other IT & Programming       
Skills: Microsoft Excel, 9       

l****ing
 [?]
Sign in to view client's details.
| l****ing
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 24, 2015  |  Ends: 11d, 12h  |   4 Proposals
I would like to analyze text collected from online job postings to identify trends--changes in skills requested or types of tasks or problems being addressed in the posted jobs. Approach: Detect changes in keyword frequencies in job postings. I'm interested in both single keywords and bi-grams for the initial phase of the project. Specifically, we want to detect when large (either by percentage or by total frequency) changes in keywords occur month by month and quarter by quarter. Data Source: To be provided. Sample data provided in Excel. There will be on the order of 25K job posting records per calendar quarter. There will be 3-4 years' of data. Deliverables: A database that includes a means of identifying large changes in keywords in the job descriptions. Bulk boilerplate language from the job descriptions should be automatically cleansed to improve analysis. (e.g. Remove text such as "When you choose KPMG as the place to build your career in tax, you can really add value...
Category: Data Science       

d****sky
 [?]
Sign in to view client's details.
| d****sky
|    United States
Fixed Price: Not Sure   |  Posted: Apr 24, 2015  |  Ends: 11d, 11h  |   7 Proposals
Hello, If your reading this, then your an expert excel / API coder who can build awesome macros, or someone with a new type of solution. If your not, then no need to apply. I have a client that needs his database imported from his patient management system, into Infusionsoft CRM. His client management system doesn't have an open API, so he is going to export a CSV every day into dropbox with his current client list. Each client will have a unique ID (this would be the client management systems ID, NOT Infusionsoft ID) It is your job to get this patient management CSV uploaded to a dropbox folder, and automatically merge it with his existing database within Infusionsoft. I assume this can be done with an Excel Macro, as I had someone do something similiar to this with that program. I'm not a coder, so I don't know how this can be achieved, I'm open to suggestions on what this will take. Please tell me how you will accomplish the following (as well as a quote) 1. Take lates...
Category: Database Development       
Skills: Microsoft Excel, MySQL Administration, PHP       

c****ass
 [?]
Sign in to view client's details.
| c****ass
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 24, 2015  |  Ends: 11d, 10h  |   4 Proposals
Current status: a) We at head office have a LOT of outlook groups in our team. Its really difficult to manage additions to the new group / deletions - many times instead of outlook groups - we use a long list of just names (sometimes even 100+) b) We constantly keep getting requests to add users / remove users from specific groups etc. And the personal secretaries need to do this - but they find it complex since there is no central management method - we need to train them and do this manually... or we do it ourself instead of them. Needed: c) The idea is to find a solution (which doesnt need an installation): - allow head office to easily manage outlook groups in a really simple way without having to deal with outlook mechanics - sync up the tool - for e.g. the tool could be word excel or outlook itself to outlook address list - allow easy and quick searchability to edit / add / delete users in the group - Allow groups to be shown to people in an open environment (they are all on s...
Category: Project Management       

a****at1
 [?]
Sign in to view client's details.
| a****at1
|    India
Fixed Price: Less than $500   |  Posted: Apr 24, 2015  |  Ends: 11d, 9h  |   2 Proposals
We are in need of a Google Doc that can manage our inventory. We have some requirements that are needed Left hand side column: PO # Company Name Date Ordered Top horizontally: On Hand Inventory (what we started with) Current inventory (what we currently have in warehouse) % of inventory sold for each item Item Name We already have all of this produced, what we need to incorporate is below... Ability to add quantities of inventory from inbound shipments that will automatically update the inventory to "current" Example: 2/3/2015: Current: 137 2/4/2015: Inbound Shipment: 250 Current: 2/4/2015: 387 Or some variant of that, it needs to be seamless and easy to add inventory that is coming in. Re Order Point: We also need a re order section put in for product with alerts to remind us when we are low and need to re order. Back Order System: We need an equation to handle back orders to keep them in system, but when we fulfill the back orders it will update the entire sh...
Category: Business Intelligence       
Skills: Microsoft Excel, Google Spreadsheets       
Preferred Location: North America

k****j11
 [?]
Sign in to view client's details.
| k****j11
|    United States
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 24, 2015  |  Ends: 11d, 7h  |   13 Proposals
You will be converting 5 excel spreadsheet into a usable access database with reports and queries. You will be creating a raw material planning / procurement tool that will feed a purchasing plan. This tool will take into leadtimes, different material grades and supply source
Category: Database Development       
Skills: Microsoft Access Programming       

u****927
 [?]
Sign in to view client's details.
| u****927
|    United States
Fixed Price: Not Sure   |  Posted: Apr 24, 2015  |  Ends: 26d, 7h  |   6 Proposals
SUMMARY OF THE POSITION: Participate for the Applicative Solutions group in the administration of Microsoft SQL databases required by projects or support / maintenance activities. Responsibilities: ?Advise users in defining their needs (processes and systems); ?Approve data models and tables produced by other technical resources; ?Advise developers on techniques used to achieve better performance and work together with them in SQL query rewrite as needed; ?Migrate BD components in development environments, integrated testing, pre-production and production; ?Special Back-up/Restore requested by the development team in the development and pre-production environments; ?Optimize application performance by adding required indexes, doing re-indexation of BD, identifying non performing SQL procedure and recommending optimizations, etc.; ?Manage access rights to the DB; ?Participate in the evaluation, design and / or acquisition as well as the implementation of new applications or major imp...
Category: Database Administration       
Preferred Location: Romania

A****a_M
 [?]
Sign in to view client's details.
| A****a_M
|    Romania
Fixed Price: Less than $500   |  Posted: Apr 24, 2015  |  Ends: 3d, 5h  |   19 Proposals
We're looking for a Web Developer to build a microsite with 3 simple web applications. Page 1 - "Main Page" (see image 1) WEB APPLICATION 1 Page 2 - "Combinations" (see image 2 and 3) ? Two dropdown lists with a number of options ? User selects an option from each list ? Depending the combination, an outcome is shown ? An excel sheet with all possible combinations and outcomes will be provided ? A sample excel file is attached WEB APPLICATION 2 Page 3 - "Product Search" (see image 4 and 5) ? User chooses a product category from a dropdown list ? The products from the selected category are shown Page 4 - "Product Page" (see image 6) ? Each product has a page ? Product title, image, price and description ? More products from the same category ? An excel sheet with all products, prices and descriptions will be provided WEB APPLICATION 3 Page 5 - "Product Characteristics Search" (see image 7 and 8) ? Product dropdown list ? User sele...
Category: Web Programming       

c****e12
 [?]
Sign in to view client's details.
| c****e12
|    Greece
Fixed Price: Less than $500   |  Posted: Apr 23, 2015  |  Ends: 10d, 21h  |   18 Proposals
I'm creating an invoice in excel with macros. Need some work to fix it so it prints to PDF correctly. I need the columns to reference the invoice via the headers and not the cell location.
Category: Software Application       
Skills: Microsoft Excel, Excel VBA       

t****kle
 [?]
Sign in to view client's details.
| t****kle
|    United States
Fixed Price: Less than $500   |  Posted: Apr 23, 2015  |  Ends: 10d, 16h  |   5 Proposals
I have developed over the years and excel spreadsheet program that tracks the progress of people that like to lift weights. The program is in excel spreadsheet format and I would like to have it converted to a traditional software program. Included are some screen shots of the program that are on my website. To get a free copy of the program go to   [obscured]   and download your free copy. If you are interested I can send you an unlocked version to examine. 4/24/15 Just some more clarification on what I would like.. 1. Has to be a desktop application in microsoft using Java 2. 1 time license Please contact me and I will e mail you a unprotected version
Category: Software Application       

r****on4
 [?]
Sign in to view client's details.
| r****on4
|    United States
Hourly Rate: $30 - $40 / hr   |  Duration: 1-3 months  |  Posted: Apr 23, 2015  |  Ends: 66d, 12h  |   8 Proposals
We are looking for someone who can work at our Houston, Texas office for the following database project: * Develop new features for an existing Microsoft Access database. * Integrate database features with Excel * Work directly with end users to analyze business needs and requirements. * Upgrade MS Access database applications to support the management of information. * Identify and document the maintenance procedure for the existing MS Access applications to ensure security and integrity of the data. *Recommend on future technology platform and support the system / data migration. * Identify performance tuning opportunities and optimize the MS Access application. Experience and Competencies Qualifications: * 5 years of experience in Windows application development environment. * 3+ years of leading development experience or working independently. * Communication skills. * Project management skills including change request management and customer service. Core ...
Category: Database Development       
Preferred Location: United States

m****123
 [?]
Sign in to view client's details.
| m****123
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 23, 2015  |  Ends: 10d, 14h  |   0 Proposals
I'm looking to organize/automate much of my trading through excel. So have a need for assistance on the eSignal side establishing some of the stat/indicator values and presenting them realtime in excel. My trading is primarily in pairs (ie: 1.3 * XOM - CVX). So for this engagement I'm looking for the following: 1) Correlation calculation that takes in the timeframe and two symbols from excel and returns the correlation for those time series. 2) Average daily range which takes the timeframe for the calculation along with the pair symbol from excel and returns the average daily range for that pair over the defined timeframe. average daily range being sum of high-low for timeframe divided by the number of periods in the timeframe. 3) Looking for a way to select a record (or link or button) in excel and have the associated symbol in excel, load in eSignal. Assume you may have some expertise or know where i can go for that. Have tried doing this through scripting but it was quit...
Category: Other IT & Programming       
Skills: Microsoft Excel, esignal       

j****ins
 [?]
Sign in to view client's details.
| j****ins
|    United States
Fixed Price: Less than $500   |  Posted: Apr 23, 2015  |  Ends: 10d, 14h  |   23 Proposals
Hi there, I have a small-ish de-identified data set from a study that involves test scores and activity records (the study involved the use of a software program) from a control group and an experimental group. I need a someone with statistical and data analysis skills to analyze this date to find any significant differences between the two groups. Examples: -Did the experimental group score higher on a certain test than the control group? -Did the experimental group spend more time, on average, using the software? -Did the experimental group do different things when using the software? Requirements are a small writeup (with statistical language) of findings as well as depiction of data in graph form (excel is okay but tableau graphs would be amazing). Budget is $100 but can be negotiated. Work is needed in 7 days' time.
Category: Statistics       
Skills: Microsoft Excel, Tableau Software       

c****lak
 [?]
Sign in to view client's details.
| c****lak
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 23, 2015  |  Ends: 10d, 12h  |   20 Proposals
Looking to convert reports that are built using Excel (pivot tables) and Word into Tableau Dashboards.
Category: Data Analysis       
Preferred Location: United States

a****ota
 [?]
Sign in to view client's details.
| a****ota
|    United States
Fixed Price: Not Sure   |  Posted: Apr 23, 2015  |  Ends: 2d, 10h  |   9 Proposals
We already have the domain and hosting. The website is up but we want to develop a subscription based website that allows for different levels of subscriptions with access to different levels of information supplied by the website based on the subscription level. We are going to provide auction results from several different live auctions which we want to input manually either through excel or similar data based software to create a market report for items sold through these auctions. Access to the different levels of market report information would be based on your subscription. We also want to be able to tease users with limited information to get them to subscribe and sell up or down to users and have email notifications to users. We would also like information to be protected from downloads or from printing and limit users from sharing their account login information with non-subscribed users if possible. We are looking at WordPress at the moment. Any help or suggestions on this p...
Category: Database Development       

e****ces
 [?]
Sign in to view client's details.
| e****ces
|    United States
Fixed Price: Less than $500   |  Posted: Apr 23, 2015  |  Ends: 10d, 9h  |   4 Proposals
I need a long list of clinical research centers/institutes input into EXCEL/CSV that that each LEAD includes the following details below: Name of Owner/Medical Director/Main Doctor if applicable Name of Research Coordinator(s) Currently Running/Enrolling clinical trials (list) Direct Contact Number -----> to owner/director/coordinator/and at least the SITE Direct Email Information (if info is available) State/Location in United States - must be in abbreviated format (ex: NV, CA, FL) EXCLUDE the following: --No Education Institutes or Universities --No Hospitals KeyWords include: clinical research, trials, association, institutes, enrolling clinical trials, phase I-IIIV, research studies
Category: Database Development       

e****ers
 [?]
Sign in to view client's details.
| e****ers
|    United States
Fixed Price: $20 - $100   |  Posted: Apr 23, 2015  |  Ends: 10d, 9h  |   37 Proposals
I have two excel spreadsheets that have conference attendees contact information listed on them from 2014 and 2015. I need them combined into one. For the 2015 list: 1. Do not overwrite the existing email addresses and phone numbers. They are correct. 2. Otherwise, use the 2014 list to update the phone numbers and email addresses on the 2015 list.
Category: Data Analysis       

T****IDE
 [?]
Sign in to view client's details.
| T****IDE
|    United States
Fixed Price: Not Sure   |  Posted: Apr 23, 2015  |  Ends: 25d, 3h  |   0 Proposals
We are looking for someone proficient in XML programming and familiar with Cygnus (  [obscured]  /cygnus/) that can help us create bespoke reports to facilitate our needs.
Category: Software Application       
Skills: Microsoft Excel, XML, Cygnus       
Preferred Location: United Kingdom

A****rce
 [?]
Sign in to view client's details.
| A****rce
Fixed Price: Less than $500   |  Posted: Apr 23, 2015  |  Ends: 10d, 0h  |   6 Proposals
I need someone who can create a reporting dashboard using Microsoft Excel for Mac. I'm looking for a dashboard to track registration data of our membership spread out over multiple worksheets. We have anywhere from 1500-2000 members each year. I can provide you with all the metrics and the labels that has to go into the dashboard. I want to also be able to track returning members and non returning members to determine retention statistics. I need to be able to use this dashboard each year as I add each membership year to it on a ongoing basis. Please reply with links to any of your previous work related to excel dashboards. Thanks,
Category: Data Analysis       
Skills: Microsoft Excel       

c****n54
 [?]
Sign in to view client's details.
| c****n54
|    Canada
Hourly Rate: Not Sure   |  Duration: 3-4 weeks  |  Posted: Apr 22, 2015  |  Ends: 24d, 21h  |   10 Proposals
Hello everyone thank you for looking at our ad, We are seeking an EXCEL expert to tutor our CEO in using EXCEL. We use VLOOKUP formula we sort LARGE amounts of DATA over 1MILLION lines of data. We need someone to start slow to tutor an hour a day for few weeks.
Category: Data Analysis       
Skills: Microsoft Excel       
Preferred Location: United States

s****dco
 [?]
Sign in to view client's details.
| s****dco *
|    United States
Fixed Price: $1,000 - $2,000   |  Posted: Apr 22, 2015  |  Ends: 9d, 18h  |   11 Proposals
Position available for EXPERIENCED SEO and WEBSITE guru/master! We are seeking an SEO & Website GURU/MASTER for a permanent position paid monthly. About us: We currently own and operate 5 different websites (some niche) and plan to have more in the future. We have been in business since 2008. Job Description/Duties include: Individual must be experienced and creative. Individual must specialize in search engine marketing and Website designing or at least familiar with Bootstrap templates / Shutterstock icons. SEO - Must have a strong understanding of SEO including Google Analytics (be prepared to show some of your work in which you have a website ranked right now). Analytics - Correlating data, Translating results, Rank Reports, Work Reports, Etc; The person chosen will be managing/building anywhere from 10-25 websites. Individual should be able to: Be expected to proactively identify and improve areas via audits performed on websites regularly. Analyze campaigns and s...
Category: Other IT & Programming       
Preferred Location: North America, Western Europe, Eastern Europe, Australia/Oceania

o****tyc
 [?]
Sign in to view client's details.
| o****tyc
|    United States
Fixed Price: Less than $500   |  Posted: Apr 22, 2015  |  Ends: 9d, 17h  |   28 Proposals
I need a formula or method to quickly merge data. In short, i need the prefix in column A added to data from column B for the result of column C. The data taken from column B needs to be arranged as follows: oldest year-newest year + vehicle makes (ie honda, toyota, bmw etc....) see the attached example.
Category: Data Engineering       
Skills: Microsoft Excel       

a****ics
 [?]
Sign in to view client's details.
| a****ics
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 22, 2015  |  Ends: 24d, 14h  |   1 Proposal
Seeking expert with experience in Microsoft Excel 2010/2013 in combining xml file feeds and manufacturer pricelists from disparate systems into a maintainable and usable dynamic file in support of contract product and service offerings. - Accuracy and fast turnaround are top priorities. - Some knowledge of Etilize ecommerce categories helpful Contract work on a somewhat regular schedule. Prefer local to central NC for ease in communication/onsite meetings. Email preferred. Send resume citing specific germane experience. Contact: Susan Jabbusch Carolina Advanced Digital, Inc. EVP   [obscured]   (919)460-1313, ext. 102   [obscured]  
Category: Other IT & Programming       
Skills: Microsoft Excel, xml Web Services, Excel VBA       
Preferred Location: North America

s****sch
 [?]
Sign in to view client's details.
| s****sch
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 22, 2015  |  Ends: 9d, 13h  |   21 Proposals
i have attached a file please send final proposal amount for what is listed if you have any snapshot of databases you have done please include them I have an existing database unfortunately the person never finished it.we have about 10,000 records . this is attached file is 2 years old with 380 . the database works fine for finding what we need. which is what our customers have ordered in the past. i would like to upgrade it for functionality. -we would like the database to defaut open in main order status page "OrderList" -add button on main order page to add "NewCustomerEntry " form -search or query or page for find by either all boat names or last name from the main order page -That will allow us to find what our customers have ordered in the past "NewCustomerEntry " form -not letting us put in the same boat name and customer name in a record -our customers can order 3 different types of printing from us Embroidery new silkscreen new boat lette...
Category: Database Development       

b****que
 [?]
Sign in to view client's details.
| b****que
|    United States
Hourly Rate: $15 - $20 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 22, 2015  |  Ends: 9d, 10h  |   4 Proposals
Data related to traded power derivatives are passed to our company through an Excel marco and Active-X control. We have no control of how the data arrives. A file containing (edited for IP reasons) sample data is attached. The data details different products traded. These can be in different countries - Germany, the UK, and have different time lengths - a year, a month, a single day etc. (A fuller description of all the different kinds of products will be passed to the successful candidate) The problem comes from distinguishing between two kinds of products. Products of the length of one day are stored in most countries as 'Wed 22-Apr-15', such the first line in sample file. Month long products are stored as a date string "15/05/2015", formatted by Excel YY-MMMM, or '15-May', such TradeID 6 in the sample file. (Due to lazy inputting, the day of the date string is the same as the year, but the day is arbitrary) The issue is in the UK days are not recorded with the day text,...
Category: Software Application       
Skills: Microsoft Excel, Python       
Preferred Location: Western Europe

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