Pivot Tables: MUST-KNOW for Business & Finance Professionals

[@KenjiExplains]

🚀My Excel for Business & Finance course: www.careerprinciples.com/courses/excel-for-business-finance 📹Advanced Pivot Tables Video: kzbin.info/www/bejne/mF6uYp2LjpidetU

[@babababul]

@Kenji Explains would love it if you could make a video on how to add a slicer in PowerPoint or google slides. Desperately need that option.

[@sg9062]

loved this video, was simple and straight to the point. Perfect for beginners like me. thank you Kenji!

[@Dr_Amr_Abdelfattah]

Dear Kenji, Great job! I would like to acknowledge that you are one of the best KZbinrs I follow in the field of Finance. Thanks for your valuable shared information. Best Regards, Amr from Egypt

[@MLL124]

Great job! Just a suggestion, if you could show us where the functions are without using the shortcut keys, then maybe telling us what the shortcut keys are for that function , I think would be easier to retain the information. Keep up the good work!

[@matthewfeeney1303]

I agree, showing the functions would be great!

[@fightforlove4731]

Thanks for your video. The way you teach is brilliant, straightforward, and easy to understand. Great work!

[@KenjiExplains]

Thanks for watching! Really appreciate your nice comment :)

[@muhammadaqil5993]

I'm using KZbin since 2014. I hardly click on the subscribe option of any channel. After watching 2-3 videos consistently, The tutor Mr Kenji compelled me to hit the subscribe button. The best Excel tutor I've ever seen. Language, knowledge and expertise coupled with personality. A top class tutor.

[@KenjiExplains]

Thank you! Appreciate your nice message 🙏

[@michaelquach7046]

Another great video, super essential to know how to use pivot tables

[@KenjiExplains]

Glad you enjoyed it

[@timchapman5155]

Thanks Kenji! As a Product Manager, these tables will be easier for our Executives to interpret.. and easier for me to create 🤣. Cheers !

[@JJJosh949]

You should do one on PPT presentations, specifically on the standards placed by consulting firms. My “design” eye sucks and could certainly use the guidance.

[@JD-eu9ld]

Really appreciate that these data files are free to download. I can only find a limited number of the same kind on the web.

[@KenjiExplains]

Glad you finding it useful! 👍

[@ThisIsMeEmna]

oh my God! so happy to have discovered this! watched it at 1.5 speed with breakfast tea

[@Andy13april64]

Thanks, I have never done a pivot table before, but will have a go when I get a chance. Excellent tutorial.👏👏👏👏💯

[@DisciplinedTraderUK]

Awesome video Kenji, thanks for the info 👍👍

[@hasanmohammadtareq89]

Thanks from Bangladesh. That slicer thing was impressive!

[@dragonofdolittle1332]

I learned something new! This is very helpful. Thank you!

[@KenjiExplains]

Glad it was helpful!

[@VReyes]

Thank you for the video Kenji! I really love to work with shortcuts as you do in the tutorial, unfortunately for me in my current job I use mac and excel for mac is a nightmare with shortcuts :c

[@maimisa]

Great Works....

[@jamesperry3837]

This video is fantastic! The entire video is so good! *Thank you!*

[@frankiebalsamo4564]

really enjoyed this video.....very easy to follow along. Thanks

[@KenjiExplains]

Glad it was helpful!

[@rohanagnelo7074]

Amazing stuff Kenji!!....I'm addicted to your channel!!

[@KenjiExplains]

Love to hear it Rohan thanks for watching!

[@shahbazb6238]

Thanks for creating such an amazing content!!

[@cliffordmanohar9553]

Kenji, your the man,, thank you once again!!!!

[@KenjiExplains]

Thanks for the nice comment man appreciate it!

[@VandettaCEAL]

Great job, watching every video of you

[@derekpage8924]

Really good presentation Kenji, joy to follow and understanding made easy too. Thank you.

[@thayaswasdibutra3782]

9.01 is the most accurate statement ever!

[@Seftehandle]

Nice vid. I would recommend adding 'for beginners' in the title

[@vheisshu]

Thank you for crystal clear video

[@umarashraf5102]

Very helpful and understanding videos 🔦👍

[@ambientaura-musictorelaxan6913]

Brilliant video

[@kamlollol2072]

Much appreciate your vdo and explanation. Thank a lot for this.

[@pratimachoudhary2979]

Hey Kenji, can you make a video on advance pivot table. You explained it really well.

[@RPisa2416]

Awesome Kenji! Thank you so much! Love the comment about how "management probably isn't proficient in pivot tables" hahahaha

[@niravpandya5567]

Great vids man! If you want a challenge, look into pharmaceutical pricing.

[@user-ll1ox7xq6x]

Very nicely explained. Thank You

[@moveyobodytoday]

great video kenji! super helpful :)

[@mohitsingha210]

Thank You Very informative video on Pivots and straightaway useful.

[@abdulbasital-sufyani6828]

Thank you so much شكرا جزيلا

[@szymontauszynski1944]

Brilliant, thanks as always Kenji!

[@KenjiExplains]

Thanks for watching!!!

[@jacintodaveiga1668]

Great job.Thanks 🙌🤝👌👌

[@KenjiExplains]

No worries! Thanks for watching :)

[@murtuzaahmed5042]

Very informative brother ....really enjoying it.!!!!

[@ph7846]

Thank you for an informative video. How would you put the sub-category (products) in a separate column instead of under the sales method? Without putting it in the Filter area. Thank you!

[@rodgermcreynolds4549]

Perhaps the cost and average price would be best represented in Currency format...this format can also be set in the Value Field Settings dialog box under the "Show Values As" tab.

[@rexbk]

Thanks Kenji. Q: Do you have a video that can explain how to do pivot table to show petty cash in hand on any selected date?

[@gilltim5711]

Excellent, clearly explained.

[@KenjiExplains]

Glad it was helpful!

[@giovannihernandez3208]

Nice video, very clear and useful. Thanks for this!

[@KenjiExplains]

Glad you enjoyed it!

[@camlex6310]

Really helpful!!

[@KenjiExplains]

Glad you think so!

[@muhammadimtiazimtiaz3210]

Great job

[@willzinner8813]

Needed this one thank you!

[@KenjiExplains]

You're so welcome!

[@samwalden315]

Good video, like the style of it!

[@KenjiExplains]

Great to hear thanks for watching 🙌

[@gurharkrishanbureau187]

V well explained.. just amazing

[@ilocomocomediaentertainmen7425]

Hi Kenji, do you have a blueprint of how to become a data analyst? What steps I should take and which of your courses should I take to achieve this. Thanks.

[@Yjs02-tx]

Thank you Kenji

[@KenjiExplains]

Thanks for watching!

[@TheJoshtheboss]

What to do with rows which have blank values e.g. iphone and iwatch for 2020 at 10:20 I find this to cause troubles when creating charts.

[@jesuischrist]

you the man!

[@KenjiExplains]

Cheers!

[@pravinkumar54]

Love the video. one question. i want to calculate MOM/YOY using pivot can you help

[@williamchurch711]

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?

[@cheickdiallo7946]

Interesting

[@user-zp2vq8dk6r]

If I have to solve 3 questions based on pivot for which 3 separate tabs are created, how to showcase overall result in one tab out of it?

[@PremKumar-rf3mo]

Hi kenji , i'm want to learn the VBA ...it's anything from you ???

[@sumonsarkar4397]

Nice vedio

[@venkybabu8140]

Circle to circle ratios are logarithmic.

[@taasinmimmahbubanggon8362]

How are you soooooo good in Excel?! I don't think I can ever reach your level T__T

[@alanleong9847]

Super helpful video, I was just wondering where you could get the data from, for example the sales data from Apple.

[@KenjiExplains]

You can usually find this type of data in Apple's Annual Report, but for this video it isn't Apple's real data (I had a disclaimer at the beginning)

[@kdnoelopez5]

great :)

[@KenjiExplains]

Thank you!

[@reshugupta5090]

Hi Kenji Could you please share function...how to merge text with images (text on image)

[@txredkim867]

Subscribed

[@jashimuddinchowdhury1136]

Do you have power query video

[@MHDISSY950]

Hey Kenji, great video. I was wondering if you are able to make a video about how to format/maintain an excel workbook so it’s easy to perform quality control or revisit at a later day.

[@KenjiExplains]

Hi Mohammad, thank you for the comment! Will keep it noted :)

[@vicariouscato9555]

what's the mac shortcut for column width? :(

[@solomonbhandari-young4154]

the besttttt

[@KenjiExplains]

Cheers Solomon!

[@Driving4bangers]

My problem is I never know which of the 4 areas to drag the criteria

[@MrEinfachso123]

Is there a way to align the slicers like you would do it in PowerPoint?

[@KenjiExplains]

That's a great point. I haven't found a way unfortunately!

[@i123456987654]

Lol it’s all about making it look presentable to the management team

[@rndomly7584]

SQL ❤️

[@pepawutz306]

Cool

[@KenjiExplains]

Thanks!

[@Perfectsound88]

@4:42 the calculate option is greyed out for me.

[@oliverscheurich9202]

Most likely you have added the table to the data model. Solution: Create a new pivot table without adding the table to the data model.

[@hodmechanical9707]

Dashboard?

[@ssananda]

awesome sir...

[@KenjiExplains]

Thanks a ton!

[@bluceree7312]

4:36

[@KarenC-nr7tf]

kenji :)

[@roxiewatters6375]

*Don't sleep on it...this is a time to invest I recently just bought another property valued at over $10m. I wish I knew the right investment firm to invest with earlier, better late than never thought.*

[@ambitiousadventure1791]

Yeah!! ‌Due to the fall in the stock market, I don't think it's advisable holding, it would be more beneficial and yield more profit if you actually trade on cryptocurrency I've been trading since the dip, and I've made so much profit trading.

[@ambitiousadventure1791]

@Lydia Paul That's why you need the help of a professional like Mr Philip McCarthy who trade and understand the market more to earn good income, these professionals understand the market like it's there own farm and make s maximum profit for investors.

[@commerceusa]

‌I heard that his strategies are really good

[@travis4178]

@@commerceusa Yeah, My first investment with Mr Philip McCarthy he earned me profit of over $25,530 US dollars, and ever since then he has been delivering

[@cainguyen2974]

He has really made a good name for himself

[@Metalblowing]

I'd be careful with some of these pivots if you need to share data. I've had occasions where a table works fine in my 365 and desktop but once I send it to a client or friends - it doesn't. Had it on MAC/Windows. So for some of the outsource work, I try to skip pivots unless I know what version/type of Excel the client is using.

[@ajaaskelainen]

or just use PowerBI instead :)

[@ABaumstumpf]

Pivot-tables can be really handy if you want to look at some data in a more compact way. But i really gotta say: I would not trust a business or finance "professional" if they would be using Excel for data-analysis or reports..... Either the person is incompetent or the company is incompetent cause on both cases that would be the job of the accounting/erp system.

[@stefanosasiklaris4584]

You must be uncoscious of the real power of excel. Most data analysts use excel esp vlookup, pivots , index etc and along with powerbi it get really powerful for either cleansing and analysis or data visualization

[@ABaumstumpf]

@@stefanosasiklaris4584 "Most data analysts use excel" Source? Ah yes - you just made that up.

[@angizze]

Your revenue not showing as negative is making my accounting head hurt.

[@mattshaw6259]

Lots of blinking going on

[@yuzhan8676]

Great video and some nice tips! Just to those it may concern. This is a scary time for new investors but the best thing you can do is not to make decisions based on emotions. This could actually be a good time to buy more of your high conviction stocks or crypto on a discount. Wealth is created during bear markets, not bull markets. If your portfolio is really effecting your mental health then delete the app and go for a walk. Let the market do its thing and have a long time horizon. I buy and just trade long term more than ever, I have made over 16` btc from day trading with Marcus in few weeks this is one of the best medium to backup your assets incase it goes bearish..

[@kovalski6237]

Indeed there’s a lot of money to be made in crypto markts trading, How do I get to reach him!?.

[@yuzhan8676]

@@kovalski6237

[@hyunwoo_9461]

Always backup your trading with a good strategy, else the bear market will hit you so hard, and you might wake up losing your saving, that's crypto for you.

[@andrea-glanville9990]

I've sat down with 3 financial Analyst and 2 stockbrokers to discuss investment planning, funny enough none did me good like Mr Marcus via online..

[@dawnbrenda6527]

I lost £4500 carelessly trading on my own then I was referred to mr Marcus. we worked together and recover the lost. now i have accumulated over 6.5 BTC and counting.

[@paulwares]

should set formatting on the pivot table values not cell formats. DOWN!

[@terytow]

I think you really know excel but slowing down would be my recommendation. You're moving to fast.

[@Driving4bangers]

Set it to .75x speed