Google Sheets - Pivot Tables Tutorial - includes Grouping by Date using Year, Month Functions

Video tutorial Pivot Tables in Google Sheets. You will learn how to analyze data using Pivot Tables in Google Sheets using different functions, group years and months and more.
Google Sheets
www.google.com...
Website:
www.chicagocom...

[@Limesh]

Things to Learn in this video: F4 to repeat the last action. SUM Function SUMIFS Functions F4 inside the formula to lock the range selection. Things in SQUARE Brackets are optional Using Format painter to copy formats from one cell to others. YEAR Function MONTH Function TEXT Function (convert numerical Months to names) :: PIVOT Tips:: No blank roles. What to put in Values, Rows, Columns and filter. More options go in Rows and lesser options go in Columns. We can drag and drop from ROWS to COLUMNS directly, in the configuration. Getting SUM, AVG, Count

[@brendanwenzel]

My mind is completely blown by this tutorial. I had no idea all of these shortcuts existed for Sheets. You are a God!!

[@natarajanrajaraman5190]

You've done such a great job in structuring your traching here to walk us through the concepts step by step. Thank you!

[@ExcelGoogleSheets]

Glad to hear!

[@hammockmonk]

I feel grateful for your teaching efforts. I’m really enjoying the process of learning more about Google Sheets and this video was very helpful. Thank you!

[@1lllllllll1]

After using spreadsheets on rare occasions for over20 years, I just learned that you can double click the expand square to auto copy the formula down the entire column. Wooooooooowwwww.

[@animate9612]

what do u mean? please enlighten me.

[@jieadee4977]

Thank you, THANK YOU, for this video. Pivot tables were among those I found intimidating when I first learned Sheets, but you explained it so simply.

[@hemiihemm]

Bro! You are the MAN! I feel unstoppable now!

[@tyduff7300]

Excellent explanation of PIVOT tables. Your delivery was clearly communicated!!! Thanks so much!

[@natalialee3954]

have browsed other video but did not get the clear idea of the function of pivot table. This video is very helpful. I now understand completely what pivot table is. Thank you so much!

[@crookbooks8541]

Excellent. You have taken me out of the fog regarding pivot tables.

[@Kstanimal]

This is so helpful. Knowing the value needs to be added first saved a lot of headache. Thank you so much ❤️

[@ExcelGoogleSheets]

👍

[@the_feature_selector859]

very concise and clear. Keep up the good work. I will send anyone looking for a good tute here.

[@hayat_soft_skills]

I Love your teaching style. Thanks! for your Work . Looking for more interesting Videos

[@braedenmatson-jones1071]

You sir are a gentleman and a scholar. Thank you.

[@nursyahidah2666]

Your explanation made this easy to learn. So helpful! Thank you so much!

[@schuylerwc]

f4 to repeat last action!! Did not know about this one! Rest of video good too...

[@HeltonMoraes]

Wow this is great. You have GREAT teaching abilities. Thanks a lot!

[@deathlessmile]

Excellent vid. Quick and easy to digest

[@ExcelGoogleSheets]

Glad you liked it

[@enifomeomagbemi9074]

Learnt so much on the shortcuts and it’s really explanatory. I just subscribed to your Chanel

[@ricksegalCanada]

This is, and other videos from you, are a speed course to knowledge. Super well done with my thanks and appreciation.

[@Belenbelenn]

So helpful, great explanation of what pivot tables are for, thank you ♥

[@kaifcorner6621]

It is very amazing tutorial and this is very helpful tutorial. Thanks a lot of Sir

[@sangramtayade3765]

You have really simplified the learning experience. Thank you.

[@reenaramesh109]

Informative video Well explained Thank you

[@ExcelGoogleSheets]

Glad it was helpful!

[@tatahsidone1658]

Thank you this was so helpful 😊😊😊

[@sofusaxelsen4029]

This is very helpful! Although I don't have the datasets, I'm using a fiture called randomized range and a function called RANDBETWEEN to make a similar datasets to yours! Thanks a lot, you're such a great teacher! Keep up the great work:)

[@pon00050]

@sofus Axelsen and for anyone who may come across this comment in the future, this video is a part of the playlist titled Google Sheets Intermediate Tutorials. Find the first video in the playlist. When you click show more under the video, there is a link that allows you to download the dataset used in the video.

[@pancux670]

Great! As usual. Thanks

[@OmerMan992]

Really great tutorial. thank you!

[@mr.pradhanji2699]

Thanks for the help. Its very helpful for us. That's great 👍

[@fahdiqbal1211]

Thank you this was great ! if I want to out the sales peoples name when using the filter would I add Sales_REP in the column section of the pivot table?

[@bhavinkariya]

really made my concepts clear

[@TheYossib]

Great video. Thank you.

[@ExcelGoogleSheets]

:)

[@2900Graham]

FYI, if you select the number of rows you want to add from the existing rows, when you right click it will ask if you want to add that number of rows instead of just one.

[@ExcelGoogleSheets]

True!

[@fuadmohab8281]

Excellent!. Thank you.

[@panosgolasm]

Very nice video !! Great work !!

[@eddiepersa1752]

you are a genius !!!

[@ExcelGoogleSheets]

Thank You!

[@DonCaskey]

Good video. Thank you. Qluestion: is there a way to move the Grand Total column to the left? (So that it becomes the 2nd column instead of the right-most column)

[@pramodkrishna354]

Great Tutorial !

[@homemade3976]

Hello there, Great Tutorial, I need this data set you are using for your example, can have it for my practic? Regards!

[@zunkman1]

SO this is a great video. SO you taught me a lot about pivot tables. SO I will be able to use this a lot. SO there was just one thing wrong. SO I won't get into that right now. SO please keep up the good work. SO thanks again!

[@currencyenthusiast5360]

20:06 Dates function tutorial starts

[@justfly2525]

Love this channel!

[@savaleanich]

Thank you for this video. This helped me so much.

[@ricardoheronelizondoaranda362]

Is there anyway that we can get this data for practice purpose?

[@Hantyghone]

What a great tutorial, thanks!

[@ExcelGoogleSheets]

Glad you enjoyed it!

[@dheshpadiachey2041]

Awesome video, thanks for the help!

[@shabacsain3498]

Thank You. This is so useful :)

[@jamielle5168]

If it weren’t u Idk how I’m gonna learn this tysm 😭

[@onm4ss]

is it possible to have the pivot table split up into to tables ? One Table exclusively for database and an evaluation table ?

[@artisandude6327]

Nice video

[@StephenEvermore]

The quality of the content is good, but if you're looking for the bit on pivot tables, which is what's featured in the video title, you'll want to skip the first 15 minutes, which is an explanation of SUM and SUMIF suitable for people with very little computer experience, which is great, but likely an unwise use of time for someone that could glean the same information from a 30 second skim of a support page. If you're comfortable with both Google Sheets and English, you'll likely benefit from using x2 playback on this one.

[@musicman1770]

Thank you for this. Would anyone know if there is a way to sort data with merged fields in Google Sheets? I see pivot tables as the only alternative to viewing multiple duplicates on rows and merging their data.

[@allenqueen]

I learnt more in 35 mins than I did in the last few hours

[@ExcelGoogleSheets]

👍

[@craigagaba2163]

Thank you!

[@danielfcollier]

Wow, amazing function!

[@rashmiranjan86]

Hi, Thank you for the video. Would you please assist me here. I have a situation where I wanted to subtract the respective row value from grand total in a pivot by using calculated field. Is it possible?

[@ExcelGoogleSheets]

Depends, if it's a simple table with just one grand total then you can do it by including an external calculations, You can see an example of this type of calculations here kzbin.info/www/bejne/oYPQeaR7att3otE

[@AlanBram]

Very clear and patient!

What about if I want to see "Month Name" instead of "Month" in pivot table? OK, it is easy. BUT, what about sorting the "Month Name" in pivot table, such Jan, Feb, Mar???

[@toyclyde]

Try using this formula instead: =text(A2,"MM-MMM") it will give you this format: 07-Jul

[@Xyz123Etc..]

Incredibly helpful!

[@ClaireMusic-y5n]

no sample sheet that we can also work on?

[@mangalbilakhiya8407]

can I have the copy of the above sample data. i want use for my practice .

[@RoomOne001]

Can you pivot after group and order? I have data that I've got queried up (anonymized below), it's messy, but it's working (CR are salespeople, CP product names, CT is whether those products were sold or not) I'm trying to display the Salesperson name in pivoted columns that count up the products they sold: =query(TempDataSet!CI:CY, "SELECT CR, Count(CR) WHERE (CP='Condition 1a' OR CP='Condition 1b' OR CP='Condition 1c' OR CP='Condition 1e') AND CT='2a' GROUP BY CR ORDER BY Count(CR) desc") BUT, when I add Pivot to display the counts of the conditions better; =query(TempDataSet!CI:CY, "SELECT CR, Count(CR) WHERE (CP='Condition 1a' OR CP='Condition 1b' OR CP='Condition 1c' OR CP='Condition 1e') AND CT='2a' GROUP BY CR ORDER BY Count(CR) desc pivot CP") I get a #VALUE stating Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "pivot" "pivot "" at line 1, column 257. Was expecting one of: "skipping" ... "limit" ... "offset" ... "label" ... "format" ... "options" ... "," ... any advice/help would be appreciated!

[@julietamarinacastellano7758]

HI! Great Video! Is this sheet available for practice? Where can I find it? Thanks!

[@farhanahmed8297]

Is there a function in Google Sheets similar to the one in MS Excel that changes the Report Layout of a Pivot Table to a Compact view?

[@rianskot]

can I have the data example? so I can practices

[@kyahncho7669]

Do you have a sample data so we can practice it at the same time?

[@aayushgautam5778]

Thank you buddy

[@gaaraxpo]

great tutorial. Now gsheet has a group date function. Just right click on any date cell on pivot table, then select "Create pivot date group"

[@badasstheory]

What kind of sorcery is this? Thank you!

[@VinateroNails]

Well done, thanks!

[@sarthakdhawan2061]

from where to get this data ?

[@briannamount3721]

Can you tell me your method for collecting all of your data? I am assuming you did not manually input a bunch of random dates and sales and it would be really helpful to understand how you kept track of each reps sales. I am making a similar spreadsheet to track pay period and project hours and don't know how to keep all of the data per project after the pay period ends. Thanks for any advice!

[@samyip3868]

Hi, you might find some examples from the web. An example that I am using is "Sample - Superstore Sales (Excel).xls" downloaded from community.tableau.com/docs/DOC-1236

[@johnn4314]

Great job, number you videos !

[@damogdotnet]

Simply thank you.

[@wademartinishere]

Excellent job!

[@HACHmusic]

Love you!

[@tritono666]

Thanks for such a useful tutorial. I was learning QUERY function before I knew of pivot tables. Are there major advantages in using QUERY over just pivoting tables?

[@ExcelGoogleSheets]

Whichever gets the job done. There is no advantage or disadvantage.

[@rajeshr8887]

QUERY can handle blank rows with a “SELECT and WHERE” function while PIVOT tables requires data without blank rows.

[@andersbrinchmann3356]

Hi, Is it possible to create a pivottabel within the same sheet as my datatable, as it is with excel? Br Anders

[@ExcelGoogleSheets]

I don't think so.

[@HaninosMaximus]

Thank you very much

[@leonidmedzhibzher200]

Thank you.

[@Abcdef-hq3vf]

Can you give link of data please

[@omarkhaled390]

I have an issue that query function returns wrong date in numbers

[@ExcelGoogleSheets]

Try this kzbin.info/www/bejne/oIjNgWpnrdqMh6c

[@Plenion]

Please send me that sheet for training... thanks

[@jcepri]

Why was so much time spent on Sum, SumIf? Does that have anything to do with pivot tables?

[@charlottegodbolt5138]

UPDATE _ GOOGLE HAS NOW ADDED GROUP BY MONTH etc in its DATE functionality in PIVOT TABLES - so this "Month Name" part is now THANKFULLY REDUNDANT! So question - you went through getting the month name which is great and exaclty what I wanted (can't believe Google can't include this grouping functionality! ..anyway..) however in your table you didn't use it at all, just the month numbers. I've tried using it, and unfornutaly it will only sort them by ascending or descending - which jumbles all the months! Useless. How do you get the month names in order in the pivot table, plEASe!

[@harefieldscraftcider256]

Nearly 36 mins long?? The first 1m 6s is spent explaing what I can read on the screen. Brevity is the success of good You tube tutorials.

[@animate9612]

can anyone of u guys give me a free editable budget or sales template please?

[@minalmittal687]

f4 doesnt work for windows please suggest alternative

[@ExcelGoogleSheets]

might be fn+F4 for your computer

[@minalmittal687]

Thanks:)

[@Lobotommy110]

How to get data by exact day?

[@londondelivery3991]

👍

[@cuneiformscript2665]

🙏🏻

[@usmaniqbal1836]

Hi, share file

[@bonbonpony]

Why is it called a "pivot" table?

[@ExcelGoogleSheets]

Frankly, I don't think it's a great name. But the idea is you can pivot your data around values.

[@1gopalakrishnarao]

One solution is required. I have to consolidate the data from 18 persons. please guide me how to consolidate from 18 persons, without editing by the other person's data. Please

[@LetroyAltidor57]

Nice, but it wont be easy to memorize everything on here.

[@ehogshire]

Right which why he should have let us copy his sheet then we could have worked along with him

[@TheRangeControl]

I don't even know what a pivot table is or what it is for. Ironically, It seems like to missed the most importaint detail of the tutorial.

[@ExcelGoogleSheets]

I have to admit, I'm not good with intros.

[@nickieoakwood6926]

Sterling video

[@Macmerck12]

smh, just get to the point

[@ndelpurg]

many thanks

[@gaaraxpo]

great tutorial. Now gsheet has a group date function. Just right click on any date cell on pivot table, then select "Create pivot date group"