Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Create an excel pivot table to display survey results using filters.

    - or -

    Post a project like this
    1843
    $$
    • Posted: 5 years ago
    • Proposals: 8
    • Remote
    • #1564817
    • Awarded
    Darren V.
    Darren V.
    Accountant, Microsoft Excel & Sage 50 Specialist
    United Kingdom Lincoln
    Dave G.
    Dave G.
    Microsoft Office and Web Developer
    Top Endorsed
    United Kingdom Leighton Buzzard
    EDDS Consulting
    EDDS Consulting
    Microsoft Power BI and Excel Consultant
    Pakistan Lahore
    Syed A.
    Syed A.
    Excel expert
    Top Endorsed
    Pakistan Karachi
    Ash G.
    Ash G.
    VBA Programmer & Excel Expert w/ Data Analysis Skills. Experience with Power BI
    United Kingdom Telford
    Neha K.
    Neha K.
    STATISTICIAN/DATA SCIENTIST
    Top Endorsed
    India Gurgaon
    Jeanekey R.
    Jeanekey R.
    Data Entry Specialist |Virtual Assistant
    Philippines Mandaluyong City
    Ashley S.
    Ashley S.
    Personal Assistant
    United States Colorado Springs
    74947950666100777310176291371827145104516145391654470
    Darren V.
    Dave G.EDDS ConsultingSyed A.Ash G. + 3 others have already sent a proposal.
    • 1
    • 1

    Description

    Experience Level: Intermediate
    We are in the process of creating a survey that analyses consumers buying habits.

    The survey will contain between approx. 20 product purchased questions (e.g. type of product, model number, where did you buy this product or where did you first see this product) as well as a number of key demographics (e.g. age, gender, region, home tenure and marital status).

    We want to be able to upload the data to the excel file with the pivot table once a month and refresh results, thus allowing the user to view the latest statistics.

    We then want the user to be able to click on multiple selections to drill down further. For example, you might want to see the results of people who live in the North East of England, are aged between 45-54 and purchased their product from Amazon.

    It would be good to have charts but raw numbers and percentages are probably more important of the two.

    -I have attached something we have put together on the back of watching a 15 minute Yu Tube video which shows at least the direction we are travelling in. We know it can be done much better.
    •  
    Simon W.
    Simon W.
    100% (1)
    Projects Completed
    3
    Freelancers worked with
    3
    Projects awarded
    100%
    Last project
    13 Jun 2017
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

      There are no clarification messages.
    1843
    $$

    - or -

    Post a project like this
    Simon W.
    Simon W.
    100% (1)
    Projects Completed
    3
    Freelancers worked with
    3
    Projects awarded
    100%
    Last project
    13 Jun 2017
    United Kingdom

    Related project Searches


    video statistics survey design analysis

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2022 People Per Hour Ltd
    We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy