Master Pivot Tables in 10 Minutes (Using Real Examples)

[@KenjiExplains]

🚀 Download FREE Excel Graph Templates from Hubspot: clickhubspot.com/kb5

[@solomonbhandari-young4154]

incredible

[@mathewchacko6290]

Hi Kenji I downloaded the file but it does not contain the excel spreadsheet on pivot tables

[@mr_monroe_8818]

Hey I like you're teaching style do you teach excel basis that I can purchase ?

[@one471]

You really helped me. All the best wishes for you. From Pakistan..

[@ajikennedy6223]

it's very cool

[@vincecloudchaser2486]

I lied on my resume that I'm a master of it hahaha now I'm here.

[@Interestingboy642]

Same here, and tomorrow is my interview😅

[@amazingzheengly7344]

I completed an excel course, but never got the chance to utilize this tool in my job so I forgot how some functions and formulas work. 😂😅😅

[@RUTURAJDEORUKHKAR]

Bro I am a power BI developer and I am here 😂 I skipped so many steps !

[@khemetsmom713]

I'm about to do the same thing...wish me luck!

[@KarolSantanadeFrias]

hahahahhahahhahhahhahahahhahhahahhahhahahahahhahaha

[@MusicaMania-b7j]

I learned more in 10 mins than i have in 10 days on my own! Thanks bro!

[@Sam-uk4mb]

Kenji is the GOAT

[@veevee7555]

Goat of excel

[@veevee7555]

Goat .. group of attributes in total

[@imambolaji2769]

I don't know what to say but to tell you thank you. You've been able to make it easy for some of us who even learn slowly. Knowing that we can get it done in certain minutes actually make it possible. Thanks Kenji

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf

[@Dahaas2003]

Fantastic. So much information clearly delivered in just 10 minutes. Thank you!

[@youthandinvestmentburmese5997]

Short but comprehensive video. Thanks Kenji!

[@jillfoster7373]

I'm just learning about Pivot tables and this video is so helpful! Thanks!

[@jamesfawundu321]

Thank God we have a living legend. Thank you boss

[@tkerr7790]

Thank you so much for this video. I don't know why - maybe you just teach at the wavelength I learn at - but this is the first Pivot Table 101 that hasn't left me confused. Thank you VERY much.

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf

[@chassis6854]

Kenji, you're absolutely the real MVP

[@MrPpadhy]

So nicely explained with a short time. Thank you bro

[@abirbadawi01]

Excellent work Kenjii

[@elaineanderson4891]

I truly appreciate this video and having a template provided for watchers to follow along and practice. 🙂

[@kiranyeluru7392]

Awesome Like anything ...Unbelievable stuff from excel, Kenji Kudos for all your great efforts teaching advanced excel aspirants

[@stevenwilson7817]

your video are easy to follow. i haven't use in years and you made it easy to follow up Thanks

[@arulmurugan2902]

i learned more in 10 mins than i have in 10 days on my own! Thanks bro! FORM INDIA

[@KenjiExplains]

Glad it helped!

[@ismailowino2866]

Great work!Never knew I could learn so fast data analysis!

[@dommanedounia4917]

THIS IS SO AMAZING THANK YOUUUU !!!

[@norecave8425]

Thank you kenji. You're a life saver. i will pray to all gods in the world to give you additional life bar.

[@yinks.s9946]

That last tip for analysing data through AI was a life saver!! 🙌🏾

[@arneshguru4263]

Beautifully explained!

[@kristinochkaaaaaa]

A whole semester in a business school and i have understood nothing. 10 minutes with Kenji and i have mastered pivot tables. Thank you for your work!

[@KenjiExplains]

hahah thank you for your kind comment :)

[@keifer7813]

Great Excel videos, the best I've found

[@shreyshah7133]

GOAT of Corporate Excel ❤

[@personaltraining6228]

I am the biggest fan of Your teaching Style Kenji

[@jisanhasnat6770]

A lot of thanks for this tutorial.

[@MohdImran-z1y]

Absolutely new experience for pivot table learning

[@o_-picklerick1605]

Awesome man. Great videos and thank you so much for the practice sheets.

[@virginiakeagle3346]

Kenji rules, learning all of this and some cool functionality, can't wait to try it out.

[@myklopez9843]

new subscriber here from the Philippines.............

[@MasterSpreadsheets]

Awesome video!

[@husseiniomar7631]

this guy is helping a lot of African young boys including me as an upcoming Financial Analyst (FA). thanks

[@KenjiExplains]

Thank you man! Keep up the good work :)

[@sheisrhett]

​@@KenjiExplains PLEASE kindly share the Excel version you used here. I don't have the AI Data Analysis Function. There are other two people here who asked you the same question. Your support would be much appreciated! Thanks in advance.

[@abiel237]

This guy is just great and brief

[@ducmotb4468]

You made it way to easy! Thank you!

[@Ahbashir-e2l]

thanks for your time given us

[@sweetievang9204]

I have become a genius after this video!!! 🎤💃🏻

[@adiwakar2951]

very nicely explained all points...thanks

[@fizzy3949]

Good videos, very digestible and easy to understand

[@bunty7858]

Last tip was very useful

[@chamodthalayarathna4326]

thank u for this tutorial☝

[@ChinmayGaikwad12]

Thanks for the insightful video Kenji!

[@jims_ON]

You're excellent, sir. Thank you for sharing your knowledge on this. 👏👏👏

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf

[@akintolaruth9466]

I learnt how to refresh, sort datas by quarters and group.. Also to add in new field just like the case of profit ☺️

[@kimbereleybrown9449]

Great information and presentation. Thanks!

[@KarolSantanadeFrias]

I love it. I learned new things.

[@mugheesahmed588]

I have a demo in three days wish me best of luck man and thanks a lot mate jazakallah...

[@herewego..]

Great work!!

[@isaacamoah-o2h]

good one there. thanks very much

[@aaliyahonye-morris5581]

Downloading the excel practice and doing while watching the video very helpful!Thank you!🙏

[@shwetakalshetty8768]

Amazing kenjii. 😍thanks.

[@KenjiExplains]

Thank you!!

[@shwetakalshetty8768]

@@KenjiExplains welcome🎉 kenji. I have a question. How can we apply for a job at investment banks like Goldman Sachs or any other farm,from India. And what preparations one should do to get a job and make their career at London office?

[@frederikwoite3916]

Thanks Kenji!!!

[@KenjiExplains]

Thanks for watching!

[@camauhel-joe7539]

Good pod. Excel 🐐😊

[@The-Razza.]

Thanks and love from Pakistan ❣

[@KenjiExplains]

Awesome thank you Muhammad!

[@MrDhunpagla]

Informative K like always need something on Power Pivot 😊

[@NishanthiFernando-m6j]

So helpful. Thank you.

[@KDC4L08]

Thank You, Thank You, Thank You !

[@tracyh3861]

thank you so much for useful tips

[@iftikharbpshah8208]

Sir, i love your channel

[@ojayherbert]

Much thanks 😊

[@vikramadityarathore97]

excellent video kenji, quite helpful it is.

[@KenjiExplains]

Glad it was helpful!

[@solomonbhandari-young4154]

You make my day

[@faisaltv5464]

Great I learned more for this vedio 😍

[@liamlafleur67]

Thank you so much!

[@meira574]

Thank you!!! This is a huge help!

[@arabianseagull]

Absolutely excellent, thanks

[@waynez8136]

great learning experience buddy

[@victorianamubiru359]

Well put tutorial

[@TutorialsAndTricks]

Thank you for sharing sir 👍🙏

[@mehulmandirwala2318]

Last trick was really new one for me

[@rahatlatcvehuzurverici946]

How to install it?

[@veevee7555]

Super sir very useful video clear instructions 👍🙏

[@jesudasig3088]

Excellent coaching. Thanks

[@oliviera7808]

Hi Professor, thanks sooo much to haveade easy to understand. Simple, concise and clear. Thanks

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf

[@TechTe23]

You know what? You are amazing bro. Thanks for sharing.

[@KenjiExplains]

I appreciate that!

[@mhg9154]

Thank you, Kenji. Great Explanation as always. Question - I am unable to find both "Analayze Data & Geography Data Type" I have Office 365. I tried everything I can from the add in. Any suggestions?

[@NAtthananTangjeen]

Thank you so much

[@calezitayga8006]

Hello Kenji, recently I've been watching all your videos about excel and it's so helpful 😁 anyways, are you still single? 😅

[@fabiolasilva6623]

Thanks!!! amazing

[@spongebobby188]

I Wana buy an ikenji! 💯

[@abuhassan987]

Very Nice and clear

[@camlex6310]

Really helpful!! Thanks

[@KenjiExplains]

You're welcome!

[@jaimemoran5428]

brutal mate! cheerss

[@KenjiExplains]

Gracias Jaime!

[@rachelweller44]

hey! What would be the google sheet equivalent to Pivot Table Analyze function? Super helpful- thanks!

[@YoungKidT]

I'm gobsmacked.... The most valuable video I've watched yet on Excel and that last tip at the end of the video sealed it for me

[@tinny2761]

That analysis data option in excel is giving a lot of option like sampling, regression etc. However, in this video it didn't show any options.

[@farhanaulhoque2789]

I did not find the last option "Data analyze" in dataset which you have shown on the last minute on your video. how do i get that.

[@casley5Bangs]

Thank you

[@RizkiMaulana-kl8gi]

insert Timeline, calculated field, and grouping is really genius how i never recognize this before?

[@che7001]

I really enjoy your videos! I learn so much. I was wondering if you'll do Excel pivot tables on a MacBook because I was unable to locate the Analyze data on the Mac Excel 2021 Home and Office. There is a learning curve using a MacBook. I love my MacBook it is better than any computer I've ever owned. You and your videos are greatly appreciated. Thank you 🙂

[@sheisrhett]

The case is the same in mine but I use Windows and Excel 2019.

[@MillicentAsumah-gx8rb]

Awesome Kenji, buy please can the work sheet be zoomed out or enlarged a little..

[@blessingschisale5969]

You are the Best

[@shreyapalodhi5786]

Your video is very useful. Thank you for sharing such kind of videos. One query: I can't find the 'Analyze Table' option in 'Home' tab. How to find it?

[@danielefavale3583]

File->Options->Add-ins-> click the "Go" button----> now select "Analysis ToolPak"->Ok --------- now go in the "Data" tab (not in the Home tab), and you should be see Analysis options on the right side.

[@soham4470]

Best ❤

[@CarolSeymour]

HI...I watched your video and could not find the design tab. Nor the AI tab. I have the app 365 online version. Is it available in the app or do I need to have the desktop version? I really want to use the pivot table to sort data for my business and need to know which product to use. App or desktop version 365. Thank you in advance for this information.

[@PonderP378]

salamat sir

[@PANDITKIRANASTORE-h3c]

THANKS SIR:)

[@mollydadzie7489]

Hi Kenji, In the case of advanced pivot tables where new data is added, after hitting refresh it still does not update for me to include the new data. Could you please assist?

[@shabchique7149]

Hi Kenji thanks for the great video! Is it possible to show date in the pivot table value field? I looked all over the internet but have not found the info. Thank you.

[@nadeemsarwar266]

Thanks

[@KenjiExplains]

Thanks for watching!

[@BenDieselBasicAutomotive]

Our Professor....

[@jubedahmed1750]

Kenji one video idea selecting best chart type based on data or scenarios

[@KenjiExplains]

Will keep it in mind thank you!

[@10degcelsius]

Great video(s). Thank you so very much. Question, when I create pivot charts (middle of the video) with the Product/Region/Revenue, I'm not getting the drop downs to view by Region or by Product. Any help on that would be great.

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf