Google Forms - Analyze Response Data (Results) with Pivot Tables

แชร์
ฝัง
  • เผยแพร่เมื่อ 13 ก.ย. 2024

ความคิดเห็น • 29

  • @mommyontime3380
    @mommyontime3380 4 ปีที่แล้ว +4

    This is exactly what I needed today. I can’t believe I’ve ignored the pivot group option but not after today.

  • @yesterdayimetj2m926
    @yesterdayimetj2m926 2 ปีที่แล้ว +2

    This is exactly what I was looking for! Thanks for posting. :D Really clear and concise while also explaining thoroughly~

  • @Sacchidanand
    @Sacchidanand 4 ปีที่แล้ว +3

    Thanks, I regularly use query, never knew pivot tables, now I can combine them for even better analysis.

  • @mercyfrs
    @mercyfrs 4 ปีที่แล้ว +2

    Great master teacher..for all videos.....Tranks

  • @esunok
    @esunok 4 ปีที่แล้ว +1

    Good to know data group features...loving it.

  • @smritiverma5419
    @smritiverma5419 3 ปีที่แล้ว +1

    Thankyou so much for this. You are a time and life saver here.

  • @vincemartindubouzet8697
    @vincemartindubouzet8697 2 ปีที่แล้ว

    This is what I needed! Thank you!

  • @siddharthjain6629
    @siddharthjain6629 4 ปีที่แล้ว +1

    It was easy one!! I appreciate your work!! 😀😀😀

  • @tanveerhussain3881
    @tanveerhussain3881 4 ปีที่แล้ว +1

    I love all videos

  • @hanisami4634
    @hanisami4634 4 ปีที่แล้ว +1

    Hi. Please i have a question that make me without sleep for 6 days now. I want to use macros recorder for google sheet with tiger, to copy first row (line) from sheet 2 to paste it in the first row in the sheet 1 , after that, i want delete the first row i copied from sheet 2 , than copy row 2 from sheet 2 to past in the next empty row in the sheet 1....than répète that every 5 or 10 minute on usine trigger un google sheet...please hello me

    • @andrewbolderson3673
      @andrewbolderson3673 3 ปีที่แล้ว

      Thanks for the very useful video. If I make a quiz in Google with different sections, say for example one section with multiple choice questions for grammar questions and another section for reading comprehension questions, is there a way that I can easily see the number of points scored by individual responders by section, or can I only see the total number of points overall? Any clarification would be much appreciated!

  • @genaminin
    @genaminin 4 ปีที่แล้ว +1

    super!

  • @eduardsdundurs2256
    @eduardsdundurs2256 2 ปีที่แล้ว +1

    Why is there no "Pivot table" extension under my data tab?

  • @coolmonkey619
    @coolmonkey619 4 ปีที่แล้ว

    I have so much to learn. How many years of experience do you have

  • @christopherroque9659
    @christopherroque9659 4 ปีที่แล้ว

    I'm not using pivot tables because of annoying popup sidebar. Is there any option to disable or to view all the settings when i need it?

  • @garikipati2000
    @garikipati2000 3 ปีที่แล้ว

    % of row in data in excel pivot table like , can we get in in Google sheets pivot table

  • @melissaw7
    @melissaw7 2 ปีที่แล้ว

    Great video! But how do you create a pivot table from a multi-answer, multiple-choice survey?

  • @krishnabarfiwala5766
    @krishnabarfiwala5766 3 ปีที่แล้ว

    How to make pivot table and then graphs for 3 columns?

  • @FeriFajarS
    @FeriFajarS 2 ปีที่แล้ว

    Is it possible to get the live result in Spreadsheet before responses submitted?

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  2 ปีที่แล้ว

      I don't understand, how would you get results when there are non-submitted?

    • @FeriFajarS
      @FeriFajarS 2 ปีที่แล้ว

      @@ExcelGoogleSheets there is a new feature (maybe) on Google Form that can save response temporary. Can we use these feature to make a live score to Google Sheet? Sorry for my bad english

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  2 ปีที่แล้ว

      I see, I don't think you can.

  • @yuzunikaidou7197
    @yuzunikaidou7197 3 ปีที่แล้ว

    Is there a way to make the total not show?

  • @cuneiformscript2665
    @cuneiformscript2665 4 ปีที่แล้ว

    🙏🏻

  • @HagridThoughts
    @HagridThoughts 3 ปีที่แล้ว

    Are you able to create dashboards based on data from multiple sheets?