🚀 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

8 ай бұрын

it's very cool

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

@Interestingboy642

5 ай бұрын

Same here, and tomorrow is my interview😅

@amazingzheengly7344

4 ай бұрын

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

4 ай бұрын

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

@khemetsmom713

2 ай бұрын

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

@KarolSantanadeFrias

Ай бұрын

hahahahhahahhahhahhahahahhahhahahhahhahahahahhahaha

Kenji is the GOAT

@veevee7555

Жыл бұрын

Goat of excel

@veevee7555

Жыл бұрын

Goat .. group of attributes in total

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

Short but comprehensive video. Thanks Kenji!

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

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

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

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

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

Thanks for the insightful video Kenji!

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

6 ай бұрын

kzread.info/dash/bejne/m2t8sK5tc9GTl5s.htmlsi=7qQRHrlrLFNNoGpf

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

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

You made it way to easy! Thank you!

So nicely explained with a short time. Thank you bro

Absolutely excellent, thanks

A lot of thanks for this tutorial.

Good videos, very digestible and easy to understand

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?

Thank you!!! This is a huge help!

Kenji, you're absolutely the real MVP

Great information and presentation. Thanks!

Great Excel videos, the best I've found

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

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

So helpful. Thank you.

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

@knowledgejarurihai9429

6 ай бұрын

kzread.info/dash/bejne/m2t8sK5tc9GTl5s.htmlsi=7qQRHrlrLFNNoGpf

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

6 ай бұрын

kzread.info/dash/bejne/m2t8sK5tc9GTl5s.htmlsi=7qQRHrlrLFNNoGpf

Excellent work Kenjii

very nicely explained all points...thanks

Informative K like always need something on Power Pivot 😊

I love it. I learned new things.

Great work!!

thanks for your time given us

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

@knowledgejarurihai9429

6 ай бұрын

kzread.info/dash/bejne/m2t8sK5tc9GTl5s.htmlsi=7qQRHrlrLFNNoGpf

thank you so much for useful tips

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

@KenjiExplains

7 ай бұрын

Thank you man! Keep up the good work :)

@sheisrhett

6 ай бұрын

​@@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.

thank u for this tutorial☝

excellent sir, thank you so much

excellent video kenji, quite helpful it is.

@KenjiExplains

Жыл бұрын

Glad it was helpful!

Thank you for sharing sir 👍🙏

Thank God we have a living legend. Thank you boss

This guy is just great and brief

Thank you so much!

I am the biggest fan of Your teaching Style Kenji

Really helpful!! Thanks

@KenjiExplains

Жыл бұрын

You're welcome!

You make my day

GOAT of Corporate Excel ❤

Thanks!!! amazing

great learning experience buddy

Thank You, Thank You, Thank You !

Much thanks 😊

Very Nice and clear

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

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

@KenjiExplains

6 ай бұрын

Glad it helped!

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

6 ай бұрын

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

Thanks Kenji!!!

@KenjiExplains

Жыл бұрын

Thanks for watching!

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?

brutal mate! cheerss

@KenjiExplains

Жыл бұрын

Gracias Jaime!

Thank you so much

Great I learned more for this vedio 😍

Last tip was very useful

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

Sir, i love your channel

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

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

@KenjiExplains

Жыл бұрын

I appreciate that!

THANKS SIR:)

Good pod. Excel 🐐😊

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

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

Last trick was really new one for me

You are the Best

Got one doubt. Every time we add new data, is clicking on refresh enough or we would have to change data source too ?

Super sir very useful video clear instructions 👍🙏

@jesudasig3088

Жыл бұрын

Excellent coaching. Thanks

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

6 ай бұрын

kzread.info/dash/bejne/m2t8sK5tc9GTl5s.htmlsi=7qQRHrlrLFNNoGpf

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

8 ай бұрын

Value field is for quantities that can be summed up

Our Professor....

I Wana buy an ikenji! 💯

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.

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?

Thanks

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

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.

Thank you

Thanks and love from Pakistan ❣

@KenjiExplains

Жыл бұрын

Awesome thank you Muhammad!

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

4 ай бұрын

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.

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

@KenjiExplains

Жыл бұрын

Will keep it in mind thank you!

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

6 ай бұрын

kzread.info/dash/bejne/m2t8sK5tc9GTl5s.htmlsi=7qQRHrlrLFNNoGpf

great

How do you know how to move into the pivot table fields? Why do you move under the rows or columns

@KenjiExplains where do you get the Analyze Data option in excel I have office 365..... can't find it on my excel

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

Please what version of excel are you using ? Am using 2016 version and some of the headings are not arranged same way

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?

nice

I have no analyze tab. How to add this tab in ribbon bar? Would you please give me ? Thank you sir.

Hi, I am new to excel. I am working on a project where they wanted me to maker a pivot table, so far I have done everything correct but I am struggling to learn how to put in one of our values (Broker ID) on the side of the company name which is in the row column (so kind of like a seperate row column next to the corresponding broker name) . Ive tried putting them in values but it through the settings it does not let me just leave the numbers as is.

@knowledgejarurihai9429

6 ай бұрын

kzread.info/dash/bejne/m2t8sK5tc9GTl5s.htmlsi=7qQRHrlrLFNNoGpf

Hi I just do what you example on my file, but for some reason the Values on my PIVOT data is not calculating the sum. What should i do?

Champ!