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

[@TeddsterSa]

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

[@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 🙏

[@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!

[@ThisIsMeEmna]

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

[@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! 👍

[@timchapman5155]

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

[@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 :)

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

[@hasanmohammadtareq89]

Thanks from Bangladesh. That slicer thing was impressive!

[@michaelquach7046]

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

[@KenjiExplains]

Glad you enjoyed it

[@Andy13april64]

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

[@Seftehandle]

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

[@thayaswasdibutra3782]

9.01 is the most accurate statement ever!

[@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

[@dragonofdolittle1332]

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

[@KenjiExplains]

Glad it was helpful!

[@VandettaCEAL]

Great job, watching every video of you

[@rohanagnelo7074]

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

[@KenjiExplains]

Love to hear it Rohan thanks for watching!

[@frankiebalsamo4564]

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

[@KenjiExplains]

Glad it was helpful!

[@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?

[@maimisa]

Great Works....

[@jamesperry3837]

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

[@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!

[@umarashraf5102]

Very helpful and understanding videos 🔦👍

[@DisciplinedTraderUK]

Awesome video Kenji, thanks for the info 👍👍

[@derekpage8924]

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

[@vheisshu]

Thank you for crystal clear video

[@kamlollol2072]

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

[@abdulbasital-sufyani6828]

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

[@mohitsingha210]

Thank You Very informative video on Pivots and straightaway useful.

[@RPisa2416]

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

[@pratimachoudhary2979]

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

[@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!

[@ambientaura-musictorelaxan6913]

Brilliant video

[@jacintodaveiga1668]

Great job.Thanks 🙌🤝👌👌

[@KenjiExplains]

No worries! Thanks for watching :)

[@user-ll1ox7xq6x]

Very nicely explained. 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.

[@niravpandya5567]

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

[@murtuzaahmed5042]

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

[@szymontauszynski1944]

Brilliant, thanks as always Kenji!

[@KenjiExplains]

Thanks for watching!!!

[@giovannihernandez3208]

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

[@KenjiExplains]

Glad you enjoyed it!

[@moveyobodytoday]

great video kenji! super helpful :)

[@gilltim5711]

Excellent, clearly explained.

[@KenjiExplains]

Glad it was helpful!

[@pravinkumar54]

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

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

[@anggon176]

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

[@Yjs02-tx]

Thank you Kenji

[@KenjiExplains]

Thanks for watching!

[@gurharkrishanbureau187]

V well explained.. just amazing

[@camlex6310]

Really helpful!!

[@KenjiExplains]

Glad you think so!

[@muhammadimtiazimtiaz3210]

Great job

[@samwalden315]

Good video, like the style of it!

[@KenjiExplains]

Great to hear thanks for watching 🙌

[@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)

[@willzinner8813]

Needed this one thank you!

[@KenjiExplains]

You're so welcome!

[@jesuischrist]

you the man!

[@KenjiExplains]

Cheers!

[@reshugupta5090]

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

[@PremKumar-rf3mo]

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

[@sumonsarkar4397]

Nice vedio

[@Nikita-n9o7o]

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?

[@cheickdiallo7946]

Interesting

[@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 :)

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

[@venkybabu8140]

Circle to circle ratios are logarithmic.

[@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?

[@txredkim867]

Subscribed

[@kdnoelopez5]

great :)

[@KenjiExplains]

Thank you!

[@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!

[@jashimuddinchowdhury1136]

Do you have power query video

[@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

[@solomonbhandari-young4154]

the besttttt

[@KenjiExplains]

Cheers Solomon!

[@i123456987654]

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

[@vicariouscato9555]

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

[@Driving4bangers]

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

[@Imagantastic]

SQL ❤️

[@ssananda]

awesome sir...

[@KenjiExplains]

Thanks a ton!

[@pepawutz306]

Cool

[@KenjiExplains]

Thanks!

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

[@hodmechanical9707]

Dashboard?

[@KarenC-nr7tf]

kenji :)

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

[@bluceree7312]

4:36

[@ajaaskelainen]

or just use PowerBI instead :)

[@Audiovisual00]

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

[@angizze]

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

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

[@mattshaw6259]

Lots of blinking going on

[@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

[@paulwares]

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