🚀My Excel for Business & Finance course: www.careerprinciples.com/courses/excel-for-business-finance 📹Advanced Pivot Tables Video: kzbin.info/www/bejne/mF6uYp2LjpidetU
@babababul2 жыл бұрын
@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.
@sg90622 жыл бұрын
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
@MLL1242 жыл бұрын
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!
@matthewfeeney13032 жыл бұрын
I agree, showing the functions would be great!
@fightforlove47312 жыл бұрын
Thanks for your video. The way you teach is brilliant, straightforward, and easy to understand. Great work!
@KenjiExplains2 жыл бұрын
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 🙏
@michaelquach70462 жыл бұрын
Another great video, super essential to know how to use pivot tables
@KenjiExplains2 жыл бұрын
Glad you enjoyed it
@timchapman51552 жыл бұрын
Thanks Kenji! As a Product Manager, these tables will be easier for our Executives to interpret.. and easier for me to create 🤣. Cheers !
@JJJosh9492 жыл бұрын
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-eu9ld2 жыл бұрын
Really appreciate that these data files are free to download. I can only find a limited number of the same kind on the web.
@KenjiExplains2 жыл бұрын
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.👏👏👏👏💯
@DisciplinedTraderUK2 жыл бұрын
Awesome video Kenji, thanks for the info 👍👍
@hasanmohammadtareq892 жыл бұрын
Thanks from Bangladesh. That slicer thing was impressive!
@dragonofdolittle13322 жыл бұрын
I learned something new! This is very helpful. Thank you!
@KenjiExplains2 жыл бұрын
Glad it was helpful!
@VReyes2 жыл бұрын
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
@maimisa2 жыл бұрын
Great Works....
@jamesperry38372 жыл бұрын
This video is fantastic! The entire video is so good! *Thank you!*
@frankiebalsamo45642 жыл бұрын
really enjoyed this video.....very easy to follow along. Thanks
@KenjiExplains2 жыл бұрын
Glad it was helpful!
@rohanagnelo70742 жыл бұрын
Amazing stuff Kenji!!....I'm addicted to your channel!!
@KenjiExplains2 жыл бұрын
Love to hear it Rohan thanks for watching!
@shahbazb62386 ай бұрын
Thanks for creating such an amazing content!!
@cliffordmanohar95532 жыл бұрын
Kenji, your the man,, thank you once again!!!!
@KenjiExplains2 жыл бұрын
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.
@thayaswasdibutra37822 жыл бұрын
9.01 is the most accurate statement ever!
@Seftehandle2 жыл бұрын
Nice vid. I would recommend adding 'for beginners' in the title
@vheisshu2 жыл бұрын
Thank you for crystal clear video
@umarashraf5102Ай бұрын
Very helpful and understanding videos 🔦👍
@ambientaura-musictorelaxan69132 жыл бұрын
Brilliant video
@kamlollol20722 жыл бұрын
Much appreciate your vdo and explanation. Thank a lot for this.
@pratimachoudhary29792 жыл бұрын
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
@niravpandya55672 жыл бұрын
Great vids man! If you want a challenge, look into pharmaceutical pricing.
@user-ll1ox7xq6x2 жыл бұрын
Very nicely explained. Thank You
@moveyobodytoday2 жыл бұрын
great video kenji! super helpful :)
@mohitsingha2102 жыл бұрын
Thank You Very informative video on Pivots and straightaway useful.
@abdulbasital-sufyani68282 жыл бұрын
Thank you so much شكرا جزيلا
@szymontauszynski19442 жыл бұрын
Brilliant, thanks as always Kenji!
@KenjiExplains2 жыл бұрын
Thanks for watching!!!
@jacintodaveiga16682 жыл бұрын
Great job.Thanks 🙌🤝👌👌
@KenjiExplains2 жыл бұрын
No worries! Thanks for watching :)
@murtuzaahmed50422 жыл бұрын
Very informative brother ....really enjoying it.!!!!
@ph784611 ай бұрын
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!
@rodgermcreynolds45492 жыл бұрын
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.
@rexbk3 ай бұрын
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?
@gilltim57112 жыл бұрын
Excellent, clearly explained.
@KenjiExplains2 жыл бұрын
Glad it was helpful!
@giovannihernandez32082 жыл бұрын
Nice video, very clear and useful. Thanks for this!
@KenjiExplains2 жыл бұрын
Glad you enjoyed it!
@camlex63102 жыл бұрын
Really helpful!!
@KenjiExplains2 жыл бұрын
Glad you think so!
@muhammadimtiazimtiaz32102 жыл бұрын
Great job
@willzinner88132 жыл бұрын
Needed this one thank you!
@KenjiExplains2 жыл бұрын
You're so welcome!
@samwalden3152 жыл бұрын
Good video, like the style of it!
@KenjiExplains2 жыл бұрын
Great to hear thanks for watching 🙌
@gurharkrishanbureau1872 жыл бұрын
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-tx2 жыл бұрын
Thank you Kenji
@KenjiExplains2 жыл бұрын
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.
@jesuischrist2 жыл бұрын
you the man!
@KenjiExplains2 жыл бұрын
Cheers!
@pravinkumar542 жыл бұрын
Love the video. one question. i want to calculate MOM/YOY using pivot can you help
@williamchurch7115 ай бұрын
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?
@cheickdiallo79467 ай бұрын
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-rf3mo2 жыл бұрын
Hi kenji , i'm want to learn the VBA ...it's anything from you ???
@sumonsarkar43972 жыл бұрын
Nice vedio
@venkybabu81402 жыл бұрын
Circle to circle ratios are logarithmic.
@taasinmimmahbubanggon836211 ай бұрын
How are you soooooo good in Excel?! I don't think I can ever reach your level T__T
@alanleong98472 жыл бұрын
Super helpful video, I was just wondering where you could get the data from, for example the sales data from Apple.
@KenjiExplains2 жыл бұрын
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)
@kdnoelopez52 жыл бұрын
great :)
@KenjiExplains2 жыл бұрын
Thank you!
@reshugupta5090 Жыл бұрын
Hi Kenji Could you please share function...how to merge text with images (text on image)
@txredkim8672 жыл бұрын
Subscribed
@jashimuddinchowdhury11362 жыл бұрын
Do you have power query video
@MHDISSY9502 жыл бұрын
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.
@KenjiExplains2 жыл бұрын
Hi Mohammad, thank you for the comment! Will keep it noted :)
@vicariouscato95552 жыл бұрын
what's the mac shortcut for column width? :(
@solomonbhandari-young41542 жыл бұрын
the besttttt
@KenjiExplains2 жыл бұрын
Cheers Solomon!
@Driving4bangers2 жыл бұрын
My problem is I never know which of the 4 areas to drag the criteria
@MrEinfachso1232 жыл бұрын
Is there a way to align the slicers like you would do it in PowerPoint?
@KenjiExplains2 жыл бұрын
That's a great point. I haven't found a way unfortunately!
@i1234569876542 жыл бұрын
Lol it’s all about making it look presentable to the management team
@rndomly75842 жыл бұрын
SQL ❤️
@pepawutz3062 жыл бұрын
Cool
@KenjiExplains2 жыл бұрын
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.
@hodmechanical97072 жыл бұрын
Dashboard?
@ssananda2 жыл бұрын
awesome sir...
@KenjiExplains2 жыл бұрын
Thanks a ton!
@bluceree73122 жыл бұрын
4:36
@KarenC-nr7tf Жыл бұрын
kenji :)
@roxiewatters63752 жыл бұрын
*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.*
@ambitiousadventure17912 жыл бұрын
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.
@ambitiousadventure17912 жыл бұрын
@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.
@commerceusa2 жыл бұрын
I heard that his strategies are really good
@travis41782 жыл бұрын
@@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
@cainguyen29742 жыл бұрын
He has really made a good name for himself
@Metalblowing2 жыл бұрын
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.
@ajaaskelainen2 жыл бұрын
or just use PowerBI instead :)
@ABaumstumpf2 жыл бұрын
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.
@stefanosasiklaris45842 жыл бұрын
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
@ABaumstumpf2 жыл бұрын
@@stefanosasiklaris4584 "Most data analysts use excel" Source? Ah yes - you just made that up.
@angizze2 жыл бұрын
Your revenue not showing as negative is making my accounting head hurt.
@mattshaw62592 жыл бұрын
Lots of blinking going on
@yuzhan86762 жыл бұрын
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..
@kovalski62372 жыл бұрын
Indeed there’s a lot of money to be made in crypto markts trading, How do I get to reach him!?.
@yuzhan86762 жыл бұрын
@@kovalski6237
@hyunwoo_94612 жыл бұрын
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-glanville99902 жыл бұрын
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..
@dawnbrenda65272 жыл бұрын
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.
@paulwares2 жыл бұрын
should set formatting on the pivot table values not cell formats. DOWN!
@terytow2 жыл бұрын
I think you really know excel but slowing down would be my recommendation. You're moving to fast.