Тёмный

Master Pivot Tables in 10 Minutes (Using Real Examples) 

Kenji Explains
Подписаться 522 тыс.
Просмотров 396 тыс.
50% 1

Learn all things Pivot Tables for Excel in just 10 minutes!
🚀 Download FREE Excel Graph Templates from Hubspot: clickhubspot.com/kb5
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/63d3a4...
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
In this Excel tutorial you'll learn everything you need to know to master pivot tables in just 10 minutes.
First, we'll learn to analyse data using pivot tables.
Second, we'll learn to add visuals to our pivot tables. These will include slicers, timelines, pivot charts and more.
Lastly, we'll cover advanced pivot table features such as grouping, calculated fields, and more.
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Data Analysis with Pivot Tables
3:50​ - Pivot Table Visuals
7:30​ - Advanced Pivot Table Features
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Опубликовано:

 

14 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 171   
@KenjiExplains
@KenjiExplains Год назад
🚀 Download FREE Excel Graph Templates from Hubspot: clickhubspot.com/kb5
@solomonbhandari-young4154
@solomonbhandari-young4154 Год назад
incredible
@mathewchacko6290
@mathewchacko6290 Год назад
Hi Kenji I downloaded the file but it does not contain the excel spreadsheet on pivot tables
@mr_monroe_8818
@mr_monroe_8818 Год назад
Hey I like you're teaching style do you teach excel basis that I can purchase ?
@one471
@one471 Год назад
You really helped me. All the best wishes for you. From Pakistan..
@ajikennedy6223
@ajikennedy6223 9 месяцев назад
it's very cool
@vincecloudchaser2486
@vincecloudchaser2486 8 месяцев назад
I lied on my resume that I'm a master of it hahaha now I'm here.
@Interestingboy642
@Interestingboy642 5 месяцев назад
Same here, and tomorrow is my interview😅
@amazingzheengly7344
@amazingzheengly7344 5 месяцев назад
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. 😂😅😅
@user-pm5px1de7q
@user-pm5px1de7q 4 месяца назад
Bro I am a power BI developer and I am here 😂 I skipped so many steps !
@khemetsmom713
@khemetsmom713 2 месяца назад
I'm about to do the same thing...wish me luck!
@KarolSantanadeFrias
@KarolSantanadeFrias 2 месяца назад
hahahahhahahhahhahhahahahhahhahahhahhahahahahhahaha
@Eppzhitz
@Eppzhitz Год назад
I learned more in 10 mins than i have in 10 days on my own! Thanks bro!
@Sam-uk4mb
@Sam-uk4mb Год назад
Kenji is the GOAT
@veevee7555
@veevee7555 Год назад
Goat of excel
@veevee7555
@veevee7555 Год назад
Goat .. group of attributes in total
@youthandinvestmentburmese5997
Short but comprehensive video. Thanks Kenji!
@jillfoster7373
@jillfoster7373 Год назад
I'm just learning about Pivot tables and this video is so helpful! Thanks!
@Dahaas2003
@Dahaas2003 3 месяца назад
Fantastic. So much information clearly delivered in just 10 minutes. Thank you!
@imambolaji2769
@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
@knowledgejarurihai9429 7 месяцев назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i7HNL4Cn-g8.htmlsi=7qQRHrlrLFNNoGpf
@ismailowino2866
@ismailowino2866 10 месяцев назад
Great work!Never knew I could learn so fast data analysis!
@kiranyeluru7392
@kiranyeluru7392 Год назад
Awesome Like anything ...Unbelievable stuff from excel, Kenji Kudos for all your great efforts teaching advanced excel aspirants
@aaliyahonye-morris5581
@aaliyahonye-morris5581 Год назад
Downloading the excel practice and doing while watching the video very helpful!Thank you!🙏
@stevenwilson7817
@stevenwilson7817 Год назад
your video are easy to follow. i haven't use in years and you made it easy to follow up Thanks
@ChinmayGaikwad12
@ChinmayGaikwad12 Год назад
Thanks for the insightful video Kenji!
@MrPpadhy
@MrPpadhy 8 месяцев назад
So nicely explained with a short time. Thank you bro
@elaineanderson4891
@elaineanderson4891 3 месяца назад
I truly appreciate this video and having a template provided for watchers to follow along and practice. 🙂
@chassis6854
@chassis6854 Год назад
Kenji, you're absolutely the real MVP
@ducmotb4468
@ducmotb4468 Год назад
You made it way to easy! Thank you!
@fizzy3949
@fizzy3949 Год назад
Good videos, very digestible and easy to understand
@jisanhasnat6770
@jisanhasnat6770 Год назад
A lot of thanks for this tutorial.
@arabianseagull
@arabianseagull Год назад
Absolutely excellent, thanks
@keifer7813
@keifer7813 8 месяцев назад
Great Excel videos, the best I've found
@meira574
@meira574 Год назад
Thank you!!! This is a huge help!
@tkerr7790
@tkerr7790 9 месяцев назад
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
@knowledgejarurihai9429 7 месяцев назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i7HNL4Cn-g8.htmlsi=7qQRHrlrLFNNoGpf
@kimbereleybrown9449
@kimbereleybrown9449 Год назад
Great information and presentation. Thanks!
@jims_ON
@jims_ON Год назад
You're excellent, sir. Thank you for sharing your knowledge on this. 👏👏👏
@knowledgejarurihai9429
@knowledgejarurihai9429 7 месяцев назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i7HNL4Cn-g8.htmlsi=7qQRHrlrLFNNoGpf
@personaltraining6228
@personaltraining6228 Год назад
I am the biggest fan of Your teaching Style Kenji
@user-mx5qs9rs9s
@user-mx5qs9rs9s Год назад
So helpful. Thank you.
@jamesfawundu321
@jamesfawundu321 Год назад
Thank God we have a living legend. Thank you boss
@abirbadawi01
@abirbadawi01 3 месяца назад
Excellent work Kenjii
@user-vc5bk8pv4p
@user-vc5bk8pv4p 9 месяцев назад
thanks for your time given us
@yinks.s9946
@yinks.s9946 Год назад
That last tip for analysing data through AI was a life saver!! 🙌🏾
@oliviera7808
@oliviera7808 11 месяцев назад
Hi Professor, thanks sooo much to haveade easy to understand. Simple, concise and clear. Thanks
@knowledgejarurihai9429
@knowledgejarurihai9429 7 месяцев назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i7HNL4Cn-g8.htmlsi=7qQRHrlrLFNNoGpf
@virginiakeagle3346
@virginiakeagle3346 6 месяцев назад
Kenji rules, learning all of this and some cool functionality, can't wait to try it out.
@arunrajur6214
@arunrajur6214 Год назад
excellent sir, thank you so much
@abiel237
@abiel237 5 месяцев назад
This guy is just great and brief
@adiwakar2951
@adiwakar2951 4 месяца назад
very nicely explained all points...thanks
@solomonbhandari-young4154
@solomonbhandari-young4154 Год назад
You make my day
@TutorialsAndTricks
@TutorialsAndTricks Год назад
Thank you for sharing sir 👍🙏
@KDC4L08
@KDC4L08 Год назад
Thank You, Thank You, Thank You !
@vikramadityarathore97
@vikramadityarathore97 Год назад
excellent video kenji, quite helpful it is.
@KenjiExplains
@KenjiExplains Год назад
Glad it was helpful!
@mhg9154
@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?
@MrDhunpagla
@MrDhunpagla Год назад
Informative K like always need something on Power Pivot 😊
@liamlafleur67
@liamlafleur67 10 месяцев назад
Thank you so much!
@shreyshah7133
@shreyshah7133 10 месяцев назад
GOAT of Corporate Excel ❤
@chamodthalayarathna4326
@chamodthalayarathna4326 Год назад
thank u for this tutorial☝
@KarolSantanadeFrias
@KarolSantanadeFrias 2 месяца назад
I love it. I learned new things.
@mehulmandirwala2318
@mehulmandirwala2318 Год назад
Last trick was really new one for me
@myklopez9843
@myklopez9843 Год назад
new subscriber here from the Philippines.............
@tracyh3861
@tracyh3861 Месяц назад
thank you so much for useful tips
@bunty7858
@bunty7858 Год назад
Last tip was very useful
@camlex6310
@camlex6310 Год назад
Really helpful!! Thanks
@KenjiExplains
@KenjiExplains Год назад
You're welcome!
@waynez8136
@waynez8136 Год назад
great learning experience buddy
@herewego..
@herewego.. 5 месяцев назад
Great work!!
@ojayherbert
@ojayherbert 10 месяцев назад
Much thanks 😊
@frederikwoite3916
@frederikwoite3916 Год назад
Thanks Kenji!!!
@KenjiExplains
@KenjiExplains Год назад
Thanks for watching!
@NAtthananTangjeen
@NAtthananTangjeen 6 месяцев назад
Thank you so much
@abuhassan987
@abuhassan987 Год назад
Very Nice and clear
@iftikharbpshah8208
@iftikharbpshah8208 Год назад
Sir, i love your channel
@fabiolasilva6623
@fabiolasilva6623 9 месяцев назад
Thanks!!! amazing
@faisaltv5464
@faisaltv5464 11 месяцев назад
Great I learned more for this vedio 😍
@casley5Bangs
@casley5Bangs 10 месяцев назад
Thank you
@TechTe23
@TechTe23 Год назад
You know what? You are amazing bro. Thanks for sharing.
@KenjiExplains
@KenjiExplains Год назад
I appreciate that!
@mugheesahmed588
@mugheesahmed588 6 месяцев назад
I have a demo in three days wish me best of luck man and thanks a lot mate jazakallah...
@blessingschisale5969
@blessingschisale5969 Год назад
You are the Best
@user-vc3ib8ty8m
@user-vc3ib8ty8m Год назад
THANKS SIR:)
@camauhel-joe7539
@camauhel-joe7539 Год назад
Good pod. Excel 🐐😊
@sweetievang9204
@sweetievang9204 8 месяцев назад
I have become a genius after this video!!! 🎤💃🏻
@fireworxz
@fireworxz Год назад
Thanks
@veevee7555
@veevee7555 Год назад
Super sir very useful video clear instructions 👍🙏
@jesudasig3088
@jesudasig3088 Год назад
Excellent coaching. Thanks
@jaimemoran5428
@jaimemoran5428 Год назад
brutal mate! cheerss
@KenjiExplains
@KenjiExplains Год назад
Gracias Jaime!
@arulmurugan2902
@arulmurugan2902 6 месяцев назад
i learned more in 10 mins than i have in 10 days on my own! Thanks bro! FORM INDIA
@KenjiExplains
@KenjiExplains 6 месяцев назад
Glad it helped!
@rachelweller44
@rachelweller44 Месяц назад
hey! What would be the google sheet equivalent to Pivot Table Analyze function? Super helpful- thanks!
@shwetakalshetty8768
@shwetakalshetty8768 Год назад
Amazing kenjii. 😍thanks.
@KenjiExplains
@KenjiExplains Год назад
Thank you!!
@shwetakalshetty8768
@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?
@husseiniomar7631
@husseiniomar7631 8 месяцев назад
this guy is helping a lot of African young boys including me as an upcoming Financial Analyst (FA). thanks
@KenjiExplains
@KenjiExplains 8 месяцев назад
Thank you man! Keep up the good work :)
@sheisrhett
@sheisrhett 7 месяцев назад
​@@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.
@MillicentAsumah-gx8rb
@MillicentAsumah-gx8rb Год назад
Awesome Kenji, buy please can the work sheet be zoomed out or enlarged a little..
@BenDieselBasicAutomotive
@BenDieselBasicAutomotive Год назад
Our Professor....
@che7001
@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
@sheisrhett 7 месяцев назад
The case is the same in mine but I use Windows and Excel 2019.
@The-Razza.
@The-Razza. Год назад
Thanks and love from Pakistan ❣
@KenjiExplains
@KenjiExplains Год назад
Awesome thank you Muhammad!
@spongebobby188
@spongebobby188 Месяц назад
I Wana buy an ikenji! 💯
@calezitayga8006
@calezitayga8006 Год назад
Hello Kenji, recently I've been watching all your videos about excel and it's so helpful 😁 anyways, are you still single? 😅
@mollydadzie7489
@mollydadzie7489 8 месяцев назад
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?
@SumanSharma-zf2lz
@SumanSharma-zf2lz 9 месяцев назад
Hi, Thank you this helps a lot. however, i have one question, In pivot chart I am not able to add, edit or remove from select data. May i know why and how it can be changed as i am stuck in there any guidance will be really helpful.
@CarolSeymour
@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.
@shadowfox2938
@shadowfox2938 Год назад
Got one doubt. Every time we add new data, is clicking on refresh enough or we would have to change data source too ?
@Jkipsa
@Jkipsa 3 месяца назад
great
@10degcelsius
@10degcelsius 7 месяцев назад
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
@knowledgejarurihai9429 7 месяцев назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i7HNL4Cn-g8.htmlsi=7qQRHrlrLFNNoGpf
@shabchique7149
@shabchique7149 11 месяцев назад
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.
@israrhussain6356
@israrhussain6356 8 месяцев назад
Value field is for quantities that can be summed up
@jubedahmed1750
@jubedahmed1750 Год назад
Kenji one video idea selecting best chart type based on data or scenarios
@KenjiExplains
@KenjiExplains Год назад
Will keep it in mind thank you!
@shreyapalodhi5786
@shreyapalodhi5786 6 месяцев назад
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
@danielefavale3583 5 месяцев назад
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.
@user-vp3rt9xt2r
@user-vp3rt9xt2r 11 месяцев назад
@KenjiExplains where do you get the Analyze Data option in excel I have office 365..... can't find it on my excel
@BAROS_Z
@BAROS_Z 10 месяцев назад
nice
@YoungKidT
@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
@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.
@lovefreeman847
@lovefreeman847 9 месяцев назад
How do you know how to move into the pivot table fields? Why do you move under the rows or columns
@abdellahmezgar7150
@abdellahmezgar7150 Год назад
HEY BRO THANKS FOR YOUR VEDIOS; but thers an essue with downlaoding those templates , cause they ask for a website URL and a company name ; and i dont have one. so is there an other way to download those, thanks mate
@Wieben100
@Wieben100 Год назад
Champ!
@udochukwujake6275
@udochukwujake6275 9 месяцев назад
Please what version of excel are you using ? Am using 2016 version and some of the headings are not arranged same way
@shuvorafi5385
@shuvorafi5385 Год назад
I have no analyze tab. How to add this tab in ribbon bar? Would you please give me ? Thank you sir.
@janalgos
@janalgos Год назад
is there a way to use the same field as a row/column and as a filter/value. basically I'm wondering if there's a way to use it in more than one because when I add it to one it removes it from the other
@knowledgejarurihai9429
@knowledgejarurihai9429 7 месяцев назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i7HNL4Cn-g8.htmlsi=7qQRHrlrLFNNoGpf
@williamchurch711
@williamchurch711 2 месяца назад
I have a rather unique duplication problem with an Excel spreadsheet. Working with a spreadsheet that links several distinct customers to various values. Therefore each individual has its own row within the spreadsheet causing it to look messy. Outside of creating a pivot table to visualize this data, are there any other suggestions on how to clean the data set up without removing the duplicates?
@tanvirahmedsohag4086
@tanvirahmedsohag4086 6 месяцев назад
I need to work 2 excel worksheet side by side in windows 11 without collapsing (Reducing to mini version) of ribbon. What can I do. My monitor is 27'' 1080p .
Далее
Advanced Pivot Table Tricks ONLY Experts Know
9:39
Просмотров 464 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
Master Data Analysis on Excel in Just 10 Minutes
11:32
Data Analysis Project in Excel (3-Step Framework)
13:53
Best Pivot Table Design Tips to Impress Anyone
12:18
Просмотров 172 тыс.
Master Power BI Essentials in Just 15 minutes
14:16
Просмотров 510 тыс.
Excel PivotTables for Beginners (2024)
9:59
Просмотров 27 тыс.
Can You Pass This Excel Interview Test?
11:20
Просмотров 798 тыс.
10 Awesome Time Saving Hacks in Excel
13:35
Просмотров 33 тыс.
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Просмотров 664 тыс.