VLookup Tables Freelancers

Browse VLookup Tables job posts for project examples or post your job on Upwork for free!

VLookup Tables Job Cost Overview

Typical total cost of Upwork VLookup Tables projects based on completed and fixed-price jobs.

Upwork VLookup Tables Jobs Completed Quarterly

On average, 2 VLookup Tables projects are completed every quarter on Upwork.

2

Time to Complete Upwork VLookup Tables Jobs

Time needed to complete a VLookup Tables project on Upwork.

Average VLookup Tables Freelancer Feedback Score

VLookup Tables Upwork freelancers typically receive a client rating of 4.65.

4.65
Last updated: June 1, 2015
More options
Clear all filters
  1. Kale Nostrand

    Kale Nostrand

    Freelance SEO/SEM * Webmaster * Account Manager * Data Analyst

    United States - Last active: 10 days ago - Tests: 2

    Multifaceted, efficient & reliable manager of projects, accounts and escalations with extraordinary interactive people skills, intuitive customer service and 100% resolution via management or coordinator roles across consumer and B2B entities. Cultivate, fortify and validate multiple technical skills including SEO, SEM, webmaster, web analytics, data analysis and a wide range of technical support topics. Consistently and creatively, execute strong leadership abilities within diverse groups as well as facilitate all affairs cross-functionally & cohesively.

    $27.78 /hr
    120 hours
    4.85
  2. Teena Soni

    Teena Soni

    Statistical analyst, Excel Expert & Macro Developer

    India - Last active: 1 day ago - Tests: 3 - Portfolio: 4

    Over the last 8 years, I had the opportunity to use a number of statistical/data/Presentation software tools, these are MS Excel, Minitab, Power point. These tools were primarily used to manage & compiling data, create analysis, produce reports and dashboards. I worked in MNC’s as a process engineer and I have 8 years experience as statistical analyst. My core expertise is statistical analysis and dashboards creation using line chart, bar charts, bubble chart, scatter plot, Gantt charts, trend analysis, pivot tables, macros, filters and formulas. My skills on Excel listed below. Recording and Running Macros • Recording Macros • Adding Macros to the Quick Access Toolbar • Editing a Macro • Start the Vba Editor • Absolute and Relative Recording • Macro Storage Locations • Running macros from toolbars, menus or worksheet buttons Calculating Data with Advanced Formulas • Using Logical Functions • Understanding of Sumifs and Countifs Function • Dealing with one and multiple conditions • Summing values in a range which has error values (without sorting/filtering/deleting) • Summing values (based on one/multiple conditions) from another workbook • Using Statistical Functions • Using Date Functions o Converting non dates to dates o Displaying non dates as dates o Retaining date/number formatting when concatenating with data in cells • Using VLOOKUP o Making the column index in a VLOOKUP() function dynamic formula when new rows get added o Looking up data within upper and lower limits o Performing lookup in a range where there are multiple occurrences of a string. o How to make Column Index Dynamic in Vlookup Function. o How to provide a good error message Instead of “#N/A” in Vlookup. • Using HLOOKUP • INDEX AND MATCH FUNCTION • ARRAY FUNCTION Analyzing Data Using Pivot Tables and Pivot Charts • Performing calculation in pivot tables What to be careful about when working with pivot tables Resolving problems when grouping numeric data / dates in a pivot Addressing issues when writing formulas within pivot tables Use Slicer to filter Pivot Table data to Excel 2010.Using External Data Sources • Multiple consolidation ranges • Pivot table advance options • Creating a PivotTable Report • Analyzing and Modifying a PivotTable • Creating Pivot Charts and Dashboard • Sorting and Filtering Worksheet or Table Data • Using Database Function • Applying Data Validation to a Worksheet Basics of graphing and nuances • Creating 2 y axis charts • Dealing with dates in the x-axis • How to create Interactive Charts Using Excel Objects? • Customising data labels on charts • Presenting data in “Bar of Pie” and “Doughnut charts” • Getting total labels in stacked column charts • Use of XML and its mapping in excel • Creating forms in MS excel

    $11.11 /hr
    354 hours
    4.63
  3. Mithuna Subramanian

    Mithuna Subramanian

    Google Shopping Feed | Excel Expert | Data Researcher | Data Entry

    India - Last active: 11 days ago - Tests: 7

    Reliable contractor who fulfills the needs of client 100%. Strives hard for customer delight and five star rating. Over the last 3 years, I'm working on Microsoft Office (Excel, Word, Powerpoint) on a daily basis. I have experience in data researching / data mining apart from data entry. I also have experience in fixing remote computer problems using teamviewer.

    $10.00 /hr
    0 hours
    4.98
  4. Michelle H.

    Michelle H.

    Experienced Excel Guru & Graphic Designer

    United States - Last active: 10/01/2014 - Tests: 6

    Data Management: Generating workable graphs and charts for sales analysis & presentations, creating pivot tables, creating readable sales projections and dynamic availability charts for clients, creating efficient working spreadsheets for a variety of data management purposes. Proficient in Visual Basic and Macro programming for excel. Examples available upon request. Graphic Design: Experienced in Constant Contact management, creating a variety of advertisements, logo and branding, signage and display, packaging & product marketing development. Design Portfolio: http://www.michelleharshberger.blogspot.com/

    $20.00 /hr
    22 hours
    5.00
  5. Jacqueline C.

    Jacqueline C.

    Hard working, self-motivated, experienced in marketing and design

    United States - Last active: 12/09/2013 - Tests: 9 - Portfolio: 4

    I have over eight years experience as a Marketing Assistant/Secretary as well as 4 years of experience in a customer service/sales support outsourcing environment working with one of the world's leaders in the entertainment industry (Fortune 500 company). With a keen attention to detail, strong communication, organizational, time management, analytical, and problem solving skills, I am an excellent choice for your next virtual assistant.

    $20.00 /hr
    806 hours
    5.00
  6. Hannah Gornik

    Hannah Gornik

    Experienced Excel and Tableau Data Analyst, QA and Business Analyst

    United States - Last active: 12/02/2014 - Tests: 3

    Working in IT since high school means I've done almost everything... and my seven years of full-time work experience range from quality assurance/software testing to business analysis and design to data analysis. I have worked in most project tracking platforms and have experience with project management and implementation. On a freelance/contract basis, I have done a lot of data analysis with Excel and Tableau, across a range of industries. I am flexible (due to my student schedule) and easy to work with. My analytical skills will help you design, build, test and gain insights from any data set or project. I also have experience working with Google Analytics and can advise you on site content, as well as offering training services on a variety of software packages. I am currently working on my MBA at an elite university, so I can also create awesome presentations and help with any strategic needs you may have in technology or marketing.

    $30.00 /hr
    221 hours
    4.55
  7. Kirstin Bosworth

    Kirstin Bosworth

    Office Professional Expert (management, systems, processes, documents)

    South Africa - Last active: 11/11/2013 - Tests: 1 - Portfolio: 1

    I am passionate about improving productivity - working clever, not hard! I have expert experience in designing office management systems, processes and documents. I am highly motivated and knowledgeable in the successful and purposeful integration of people and technology, inline with the business strategic goals and objectives. I have been a popular facilitator, workshop leader, guest speaker and presenter at various national events and for various corporate clients.I am passionate about sharing knowledge, empowering stakeholders to make informed decisions based on current business and industry trends.

    $33.33 /hr
    10 hours
    5.00
  8. Lucena C.

    Lucena C.

    5 STARS DATA ENTRY SPECIALIST, WEB RESEARCHER, VIRTUAL ASSISTANT

    Philippines - Last active: 6 hours ago - Tests: 5 - Portfolio: 4

    EXCEL SPREADSHEETS EXPERT-TEXT TO COLUMNS, FORMULAS, VLOOKUP, HLOOKUP, SUMIF, PIVOT TABLE, CONDITIONAL FORMATTING I am here to continue my career and earn while at home by providing my employer a full satisfaction in terms of quality, quantity and delivery of work given. I finished my studies from elementary to college with consistent honors and strong scholastic records. I have worked for 13 years in the field of purchasing and inventory control where I handled thousands of items. I am hard working, fast-learner, reliable and dependable individual. I thank my would-be employer for believing in my skills, ability and capability for awarding the job to me and wish to have long term working relationship.

    $6.67 /hr
    3,927 hours
    5.00
  9. Mcgrace Vergara

    Mcgrace Vergara

    Senior Specialist Qlty Reports & Analytics/Web Research/LeadGen Expert

    Philippines - Last active: 17 days ago - Tests: 5 - Portfolio: 5

    • Expert level familiarity with Operating Systems (Windows 2007 and up). • Proficient statistical and mathematical logic function. • Excellent research skills with proficiency in application of mathematical and statistical analysis. • Excellent problem solving skills with the ability to interpret statistical data analysis and provide logical recommendations. • Adept in: MS Excel MS Word MS PowerPoint MS Access Visual Basic Script Macro MS Query Hyper Text Markup Language Hyper Text Application SQL

    $5.56 /hr
    107 hours
    5.00
  10. Siddiq M.

    Siddiq M.

    Web Research/Data entry/Bookkeeping

    India - Last active: 1 day ago - Tests: 9 - Portfolio: 2

    I am seeking to make an online career in expanded web research, bookkeeping & data entry. Over the time at oDesk I have done complex web research on different subjects. I am well versed in excel functions & macros. I am also experienced in Quickbooks Pro & other accounting applications with meticulous attention to detail.

    $7.78 /hr
    1,016 hours
    4.67