Learn Google Sheets & Excel Spreadsheets
Learn Google Sheets & Excel Spreadsheets
  • Видео 475
  • Просмотров 39 332 505
Pivot Tables in Google Sheets A-Z Tutorial
Pivot Tables in Google Sheets A-Z.
In this tutorial we'll cover:
00:00 How Google Sheets Pivot Tables Work
03:31 How to Create a Pivot Table in Google Sheets
15:07 Multiple Value Fields in Pivot Tables
16:52 Using Different Functions
17:53 Display Percent of Total in a Pivot Table
19:22 Group By Year, Month, Date in a Pivot Table
25:00 Slicers & Filters in Google Sheets Pivot Tables
27:46 Automatically Update Pivot Tables when You Update Your Data
34:57 Calculated Fields in Google Sheets Pivot Tables
39:20 How to Use External References in Calculated Fields
#pivottables
Просмотров: 1 534

Видео

Google Sheets Tables & Formulas
Просмотров 6 тыс.22 часа назад
Learn how Google Sheets Tables work and how they integrate with formulas in spreadsheets. #googlesheets #formulas #tables
Chat GPT vs Google Bard for JavaScript, Apps Script Code
Просмотров 17 тыс.Год назад
Compare Chat GPT & Google Bard for JavaScript, Apps Script code. #chatgpt #googlebard #javascript
Automate Google Sheets with Chat GPT Macros & Apps Script
Просмотров 67 тыс.Год назад
How to automate Google Sheets using Apps Script macros generated by with Chat GPT? #googlesheets #chatgpt #appsscript
Combine Data/Sheets in Excel & Google Sheets
Просмотров 12 тыс.Год назад
Combine Data/Sheets in Excel & Google Sheets. 00:00 Combine Data/Sheets in Excel & Google Sheets 00:25 VSTACK & HSTACK functions 05:35 Combine Ranges with Dynamic Updates in Excel & Google Sheets 09:33 BYROW & LAMBDA functions 13:22 LET function 16.53 Combine Multiple Worksheets to a Master Sheet in Excel & Google Sheets 20:54 How to Combine Data with Different Columns? #excel #googlesheets
How to Link to Other Spreadsheets (Files) in Excel & Google Sheets
Просмотров 18 тыс.Год назад
Learn how to link to (refer to) data form other spreadsheets (files) in Excel & Google Sheets in a super dynamic way. #excel #googlesheets #sheetsexcellence
Google Sheets Links
Просмотров 32 тыс.Год назад
Learn how to create links in Google Sheets. We'll use the conventional way & HYPERLINK function methods. #googlesheets #tutorial
Pivot Table GETPIVOTDATA Function in Excel & Google Sheets
Просмотров 8 тыс.Год назад
How to use GETPIVOTDATA function with Excel & Google Sheets Pivot Tables? Support This Channel www.patreon.com/chicagocomputerclasses Pivot Tables with Google Sheets & Looker Studio Tutorial ruclips.net/video/1z6KTYAoTr4/видео.html #excek #googlesheets
Connect Google Sheets & BigQuery - Connected Sheets
Просмотров 28 тыс.Год назад
Support This Channel www.patreon.com/chicagocomputerclasses How to Connect Google Sheets and BigQuery? In this tutorial we'll use Connected Sheets to get BigQuery data to Google Sheets and then we'll create a live link from BigQuery to access Google Sheets data directly. 00:00 Connect Google Sheets & BigQuery Tutorial 00:20 Pull BigQuery Data to Google Sheets with Connected Sheets 05:59 Use Spr...
Pivot Tables with Google Sheets & Looker Studio Dashboard Tutorial
Просмотров 23 тыс.Год назад
Support This Channel www.patreon.com/chicagocomputerclasses Tutorial: Create Pivot Tables with Google Sheets data and present in a Looker Studio (Data Studio) dashboard. 00:00 Pivot Tables - Introduction 02:54 Create a Pivot Table with Google Sheets Data 17:59 Add Multiple Metrics, Values, Measures to Your Pivot Table 20:44 Create a Dashboard with Multiple Pivot Tables 24:42 Group Dates in Pivo...
Google Sheets - Dropdown Multi-color Chips
Просмотров 14 тыс.Год назад
Google Sheets - Dropdown Multi-color Chips
Find Duplicate Entries in Excel - Power Query
Просмотров 9 тыс.Год назад
Find Duplicate Entries in Excel - Power Query
Running Total, Array - Excel & Google Sheets, SCAN, REDUCE, MAP
Просмотров 17 тыс.Год назад
Running Total, Array - Excel & Google Sheets, SCAN, REDUCE, MAP
Excel - Generate Random Numbers, No Repeats (No Duplicates), Unique List
Просмотров 17 тыс.Год назад
Excel - Generate Random Numbers, No Repeats (No Duplicates), Unique List
2 Way Lookup, INDEX MATCH, VLOOKUP - Excel & Google Sheets
Просмотров 10 тыс.Год назад
2 Way Lookup, INDEX MATCH, VLOOKUP - Excel & Google Sheets
Named Ranges - Excel & Google Sheets
Просмотров 4,6 тыс.Год назад
Named Ranges - Excel & Google Sheets
XLOOKUP - Advanced Excel & Google Sheets Reference Formulas
Просмотров 15 тыс.Год назад
XLOOKUP - Advanced Excel & Google Sheets Reference Formulas
Advanced Array Formulas in Google Sheets & Excel
Просмотров 21 тыс.Год назад
Advanced Array Formulas in Google Sheets & Excel
Excel Power Query - Word-count Calculator - Live Stream
Просмотров 2,2 тыс.Год назад
Excel Power Query - Word-count Calculator - Live Stream
How to Convert Text to Number in Excel & Google Sheets
Просмотров 18 тыс.Год назад
How to Convert Text to Number in Excel & Google Sheets
Excel Form - Office Script Basic Data Entry Form (JavaScript)
Просмотров 9 тыс.Год назад
Excel Form - Office Script Basic Data Entry Form (JavaScript)
Create Named Functions in Excel & Google Sheets - LAMBDA UDF
Просмотров 11 тыс.Год назад
Create Named Functions in Excel & Google Sheets - LAMBDA UDF
XLOOKUP - Excel & Google Sheets, XLOOKUP function from Other Worksheets, Join/Merge Data
Просмотров 30 тыс.Год назад
XLOOKUP - Excel & Google Sheets, XLOOKUP function from Other Worksheets, Join/Merge Data
Excel Power Query Tutorial - M Language
Просмотров 17 тыс.Год назад
Excel Power Query Tutorial - M Language
Excel Power Query Parameter from a Cell Value (using a Named Range or a Table)
Просмотров 45 тыс.Год назад
Excel Power Query Parameter from a Cell Value (using a Named Range or a Table)
Random Selection from a List in Excel & Google Sheets
Просмотров 15 тыс.Год назад
Random Selection from a List in Excel & Google Sheets
Excel - Inventory Management System Template
Просмотров 27 тыс.Год назад
Excel - Inventory Management System Template
Multiple Criteria LOOKUP (VLOOKUP, XLOOKUP) in Excel & Google Sheets, Multiple Matches Supported
Просмотров 11 тыс.Год назад
Multiple Criteria LOOKUP (VLOOKUP, XLOOKUP) in Excel & Google Sheets, Multiple Matches Supported
Gmail - How to Schedule Emails
Просмотров 4,9 тыс.Год назад
Gmail - How to Schedule Emails
How to Sort a Pivot Table in Google Sheets?
Просмотров 17 тыс.Год назад
How to Sort a Pivot Table in Google Sheets?

Комментарии

  • @shinhoyoung8426
    @shinhoyoung8426 15 часов назад

    Happy to comeback from korea 🇰🇷

  • @NourishMoveRestReflect
    @NourishMoveRestReflect 19 часов назад

    Im so glad you're back! Ive learned so much from you. Your teaching style is so clear and simple and I love your voice. Fun fact: Every time I hear your voice, I picture Kumail Nanjiani. Might just be weird me. 😂 Awesome energy. 👏

  • @frayxiii
    @frayxiii 20 часов назад

    Can you advice if I need each item repeat in specific number, different time for each item?. Like Apples repeat 4 times but Oranges repeat 2 times.

  • @essamkhalifa4375
    @essamkhalifa4375 20 часов назад

    Sir , your English ,Voice & Explaination are EXCELLENT Thanks & best regards

  • @amardeepsingh5714
    @amardeepsingh5714 21 час назад

    Thanks for great session on Pivot 👌👌

  • @ponnobari1
    @ponnobari1 День назад

    TNX BRO

  • @davidtitz2346
    @davidtitz2346 День назад

    Would filter formula work if I wanna pull data from multiple tabs?

  • @djlslinet
    @djlslinet День назад

    may I ask which one is better? importrange or this?! tks!

  • @ashamael
    @ashamael День назад

    Hey man, thank you so much. This is fantastic information. I have one question: What if I only care about the sum of each Sales' Rep's top 3 (or 5 or whatever number) sales? Is there a quick way to filter that in the pivot table?

  • @lapneto
    @lapneto День назад

    Cristal clear, as usual. Thanks for sharing - your videos are the best! Cheers from 🇧🇷

  • @johnrumm4786
    @johnrumm4786 День назад

    Nice intro, thanks. Does it cope with pulling in source data using a query function or some external data source? Can you use a user defined (apps script) function in the custom calculated field?

  • @patpat8141
    @patpat8141 День назад

    Fuck yes you are back! Instant like , and now watching this video..Curious what I‘ll learn while watching it :)

  • @66Komodo
    @66Komodo День назад

    Welcome back.

  • @mercyfrs
    @mercyfrs День назад

    Really the great master!

  • @RahulKumar93555
    @RahulKumar93555 День назад

    Very good videos Sir great 👍👍

  • @ajadsingh1652
    @ajadsingh1652 День назад

    Pls make the tutorial app sheet.

  • @tannerbobanner9453
    @tannerbobanner9453 День назад

    What did we do to deserve the return of the google sheets magician

  • @sam_safari
    @sam_safari День назад

    am gonna be active

  • @DIN-Norm
    @DIN-Norm День назад

    Thanks, that you are really back! Just the best channel for Excel & Google Sheets. <3

  • @ajjuchandrawanshi
    @ajjuchandrawanshi День назад

    1st Viewer

  • @samniengpollong7841
    @samniengpollong7841 2 дня назад

    Thank you sir. I've learned so much from your video. You are amazing. More video pls..s

  • @gabrielamilla
    @gabrielamilla 2 дня назад

    Welcome back! We love you! :)

  • @Ben-cc3fj
    @Ben-cc3fj 2 дня назад

    Welcome Back!!

  • @ianbendelow2292
    @ianbendelow2292 2 дня назад

    Fantastic video! Thank you so much.

  • @desrajsingh1345
    @desrajsingh1345 2 дня назад

    So happy to hear your voice again 🙏.

  • @DirectorOffice-ok7qc
    @DirectorOffice-ok7qc 2 дня назад

    this is what i was looking for thanks a lot ...here is like for you

  • @sharitambasco9780
    @sharitambasco9780 3 дня назад

    Welcome back. I hope you are doing well. You are my favourite content creator and I have made so many useful things based off of your lessons. If life takes you away from the channel we will all understand, but for now I am so happy to see you back.

  • @shubhamtimoli8506
    @shubhamtimoli8506 3 дня назад

    Welcome Back Sir! Thanks for making this valuable content. Lot's of love from 🇮🇳

  • @mazaruddin9261
    @mazaruddin9261 4 дня назад

    Could you please make a video on the sql in sheets video again because the old one is not working anymore

    • @ExcelGoogleSheets
      @ExcelGoogleSheets 3 дня назад

      RUclips removed the video for violating their terms of service. They said it was removed for posting offensive content, bullying. I've tried to appeal, but everything is automated these days, so it was rejected and their customer service is AI bots too and it said they stand behind their decision. Can you believe it? :) It was a one hour video, it took over a week to make it. Anyways, I don't think I'll be posting one again, sorry.

  • @mazaruddin9261
    @mazaruddin9261 4 дня назад

    Welcome back

  • @richardthemagician8991
    @richardthemagician8991 4 дня назад

    Do you have a question. Let's say make a table. For the data and column one, I want to pull in data from another sheet. Something like a form response. So every time I get a new form response, the array formula will pull the data in to the table. Will that expand the table as well? And if I delete data from the table, will it automatically shrink the table range? For example, if I'm pulling in data from another sheet using an array formula, if I delete one of the rows from the data range, then the listing column one of the table will decrease. Will that affect the table range itself?

    • @ExcelGoogleSheets
      @ExcelGoogleSheets 4 дня назад

      No, I don't believe formula updates will grow or shrink your tables, at least not at the moment.

    • @richardthemagician8991
      @richardthemagician8991 4 дня назад

      @@ExcelGoogleSheets gotcha. I appreciate the reply. What about pulling in data within the ray formula? Do you think that might work? It would at least be one problem solved.

    • @ExcelGoogleSheets
      @ExcelGoogleSheets 3 дня назад

      I don't think array formula will grow or shrink the table. The purpose of the table is for formulas to react to table growth, not the other way around.

  • @richardthemagician8991
    @richardthemagician8991 4 дня назад

    I can't wait to see how tables can work with JavaScript

  • @sangeetarora
    @sangeetarora 5 дней назад

    Very helpful and informative

  • @MattDog_222
    @MattDog_222 5 дней назад

    Oh wow I havent seen one of these thumbnails show up in my feed in a long time. I first subscribed 5+ years ago when working on some random side project in high school, and then stumbled across ur import HTML/XML parsing videos and thought it was some crazy magic I was populating my spreadsheets with... and now I'm a web developer. Thank you xD

  • @sfrunze
    @sfrunze 5 дней назад

    Great tutorial, thanks a lot for this. What would be the solution when you have to add /filter for the same parameter but multiple values, let’s say Olivia and Grace"?

  • @12thatguyoverthere
    @12thatguyoverthere 5 дней назад

    You are the best!!!

  • @monasmemo9307
    @monasmemo9307 5 дней назад

    You’re a god send thank you

  • @AlaaNoureldien
    @AlaaNoureldien 5 дней назад

    Welcome back ❤🎉

  • @AlaaNoureldien
    @AlaaNoureldien 5 дней назад

    Welcome back ❤🎉

  • @AlaaNoureldien
    @AlaaNoureldien 5 дней назад

    Welcome back ❤

  • @AlaaNoureldien
    @AlaaNoureldien 5 дней назад

    Welcome back ❤

  • @AlaaNoureldien
    @AlaaNoureldien 5 дней назад

    Welcome back ❤

  • @AlaaNoureldien
    @AlaaNoureldien 5 дней назад

    Welcome back ❤

  • @aeviternity8344
    @aeviternity8344 5 дней назад

    Thanks for this. I just wanna ask I tried the WHERE in Column A for dates. It didn't work.

  • @nikhilbhukhri2838
    @nikhilbhukhri2838 5 дней назад

    Welcome sir

  • @beatqueenlyricsofficial2180
    @beatqueenlyricsofficial2180 6 дней назад

    How to delete duplicate rows and columns

  • @amandamartinez7922
    @amandamartinez7922 6 дней назад

    This would be amazing if it added the in and outs for lunch for overnight shift 😩😩😩

  • @ExcelGoogleSheets
    @ExcelGoogleSheets 6 дней назад

    Thanks everybody!

    • @xiaer
      @xiaer 5 дней назад

      Nice to see you again

  • @DaveGhidiu
    @DaveGhidiu 6 дней назад

    Thanks!

  • @mushfiqulislam8898
    @mushfiqulislam8898 6 дней назад

    how to get this from different google sheet ?