Vlookup Jobs

30 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: More than 6 months, 30+ hrs/week - Posted
In order to be suitable for this role, you will need: - Extremely high attention to detail to ensure our website is compliant with all lending practices in the USA and all our product rates, fees and offers are correct at all times - Excellent written and verbal communication skills (and reply to an email to demonstrate this before getting the job) - Capabilities to complete tasks such as internet research (such as finding the best shopping and travel deals available), website content updates and database - Fluent in HTML - Experience using Wordpress - Proficiency with Excel (VLOOKUP/Pivot tables) Google Docs, Google Analytics - Access to and Adobe Photoshop or a similar photo editing tools - Be ready and available always during work hours on Skype to collaborate with your team members - Be self-disciplined to meet and exceed our expectations of you - A high understanding of the typical United States audience and its contexts - A sound understanding of the United States financial and telco, technology markets - To read all the resources and materials that we provide to you - Send an e-mail summary each day of the work you have completed - Sign a non-disclosure agreement and non compete agreement before starting - Always ask for help when needed - Have a positive energy and enthusiasm for your work - A desire to genuinely help people - Live and breathe our company values (which will be sent to you as part of your induction) - Have fun whilst working hard - Have a set weekly salary, based on a ~38 hour week Please only apply if you are fluent in English.
Skills: Administrative Support Content Writing Data Entry eBay Listing/Writing English Grammar Internet research Microsoft Excel
Hourly - Expert ($$$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
We would like a spreadsheet developed that uses exported information from a bidding program to allow for specialized reports and form printing. Vlookup and conditional formatting. This sheet/report would allow our designers to understand exactly how much our estimators have allotted or budgeted construction materials to cost.
Skills: Microsoft Access Programming Microsoft Excel
Hourly - Entry Level ($) - Est. Time: More than 6 months, 30+ hrs/week - Posted
In order to be suitable for this role, you will need: - Excellent written and verbal communication skills (and reply to an email to demonstrate this before getting the job) - Capabilities to complete tasks such as internet research (such as finding the best shopping and travel deals available), website content updates and database updating - Fluent in HTML, CSS and basic PHP - Proficiency with Excel (vlookups/sumifs/pivot tables)Google Docs, Google Analytics - Access to and Photoshop or a similar photo editing tools - Be ready and available always during work hours on Skype to collaborate with your team members - Be self-disciplined to meet and exceed our expectations of you - A high understanding of the typical Australian audience and its contexts - A sound understanding of the Australian telecommunications and technology markets - To read all the resources and materials that we provide to you - Send an e-mail summary each day of the work you have completed - Sign a non-disclosure agreement and non compete agreement before starting - Always ask for help when needed - Have a positive energy and enthusiasm for your work - A desire to genuinely help people - Live and breathe our company values (which will be sent to you as part of your induction) - Have fun whilst working hard - Have a set weekly salary, based on a 38 hour week Please only apply if you are fluent in English.
Skills: Administrative Support Google Docs Microsoft Excel Search Engine Optimization (SEO) SEO Audit WordPress
Hourly - Intermediate ($$) - Est. Time: 3 to 6 months, 30+ hrs/week - Posted
We are looking for someone with a strong working knowledge of Visual Studio Programming in .NET, C++ and Visual Basic to include regular expressions who can quickly build these complex spreadsheets and while also making them intuitive and easy-to-use. Must proficient in complex Excel Vlookups, complex pivot table usage, formatting, and easily communicate and work well with others who do not speak programming.
Skills: VLookup Tables Microsoft Excel Microsoft Excel PowerPivot Microsoft Office
Fixed-Price - Expert ($$$) - Est. Budget: $500 - Posted
I believe this is created in Excel and formatted, manipulated and data sorted by using VBA/Macros, pivot tables and vlookup. We would want to put pictures/diagrams/dashboard of the test results into a PDF/printable page.
Fixed-Price - Intermediate ($$) - Est. Budget: $75 - Posted
For example once the order is checked and packed we scan a barcode that identifies the customer, that pulls their email from a database via VLOOKUP, then we scan the courier tracking barcode (and perhaps a "send" confirmation code" and it sends a mailmerge email to the customer (with tracking number, invoice number, products).
Skills: Google Apps
Hourly - Entry Level ($) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
Need some quick help to move data in an excel file to one format to next. Need to be good at pivot tables, vlookups, VBA etc.
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 30+ hrs/week - Posted
Proficient with Excel reporting (Dashboard, Pivot, Vlookup, filters, validations and other useful functions) Knowledge and experience of E-commerce and CMS platforms Strong knowledge and experience on Google Adwords, Google Analytics, Twitter Analytics, Facebook Insights, Webmaster Tools Primary knowledge of HTML, Design & Development tools.
Skills: Facebook Marketing Google AdWords Google Analytics Internet Marketing Marketing strategy Pay per click Pay Per Click Advertising Search engine marketing (SEM) Search Engine Optimization (SEO) SEO Backlinking SEO Keyword Research Social Media Marketing
Hourly - Intermediate ($$) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
Attached are two samples of much larger data sets that will need to be evaluated together. To apply for work, please describe, in detail how you would complete the following analysis (assume thousands of lines of data vs sample of 10 lines) : - What is the AVERAGE life time value by customer registration type: REGISTERED vs ANONYMOUS - What is the AVERAGE average order value by customer registration type: REGISTERED vs ANONYMOUS - What is the AVERAGE lifetime coupons used by customer registration type: REGISTERED vs ANONYMOUS - What is the AVERAGE total by customer registration type: REGISTERED vs ANONYMOUS - What is the AVERAGE number of orders by customer registration type: REGISTERED vs ANONYMOUS - What is the AVERAGE total units ordered by customer registration type: REGISTERED vs ANONYMOUS - What is the AVERAGE first order units by customer registration type: REGISTERED vs ANONYMOUS - What PERCENTAGE of repeat customers (flag order from repeat customer = 1) are customer registration type: REGISTERED vs ANONYMOUS - What is the AVERAGE total of repeat customers (flag order from repeat customer = 1) vs new customers - What is the AVERAGE PERCENTAGE of coupons of repeat customers (flag order from repeat customer = 1) vs new customers Description of work should include: - Tools used for evaluation (excell, R, Tableau, SQL, or additional programs) - Method for evaluation (formulas, pivot tables, queries, or additional programs) - Approx. time to complete analysis - Long term hour rate Extra Credit: - What other interesting analysis could you complete from the attached data sets. Evaluation of work will be for ongoing projects with different data sets. Goal of evaluation is to understand method or analysis and time required to complete analysis. This could be a full-time and or long-term project for interested parties.
Skills: VLookup Tables Microsoft Excel Microsoft Excel PowerPivot R