I'm using RUclips 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.
Dear Kenji, Great job! I would like to acknowledge that you are one of the best RUclipsrs I follow in the field of Finance. Thanks for your valuable shared information. Best Regards, Amr from Egypt
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!
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.
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
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.
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!
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.
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?
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.
*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.*
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.
@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 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
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.
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.
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
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..
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.
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.
🚀My Excel for Business & Finance course: www.careerprinciples.com/courses/excel-for-business-finance
📹Advanced Pivot Tables Video: ruclips.net/video/b-K1jUY3jDs/видео.html
@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.
I'm using RUclips 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.
Thank you! Appreciate your nice message 🙏
loved this video, was simple and straight to the point. Perfect for beginners like me. thank you Kenji!
Dear Kenji,
Great job!
I would like to acknowledge that you are one of the best RUclipsrs I follow in the field of Finance. Thanks for your valuable shared information.
Best Regards,
Amr from Egypt
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!
I agree, showing the functions would be great!
Thanks Kenji! As a Product Manager, these tables will be easier for our Executives to interpret.. and easier for me to create 🤣. Cheers !
Thanks for your video. The way you teach is brilliant, straightforward, and easy to understand. Great work!
Thanks for watching! Really appreciate your nice comment :)
Really appreciate that these data files are free to download. I can only find a limited number of the same kind on the web.
Glad you finding it useful! 👍
oh my God! so happy to have discovered this! watched it at 1.5 speed with breakfast tea
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.
Another great video, super essential to know how to use pivot tables
Glad you enjoyed it
Thanks from Bangladesh. That slicer thing was impressive!
Thanks, I have never done a pivot table before, but will have a go when I get a chance. Excellent tutorial.👏👏👏👏💯
Amazing stuff Kenji!!....I'm addicted to your channel!!
Love to hear it Rohan thanks for watching!
Awesome video Kenji, thanks for the info 👍👍
9.01 is the most accurate statement ever!
I learned something new! This is very helpful. Thank you!
Glad it was helpful!
Very helpful and understanding videos 🔦👍
Great Works....
Really good presentation Kenji, joy to follow and understanding made easy too. Thank you.
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
This video is fantastic! The entire video is so good! *Thank you!*
Thanks for creating such an amazing content!!
Great job, watching every video of you
really enjoyed this video.....very easy to follow along. Thanks
Glad it was helpful!
Kenji, your the man,, thank you once again!!!!
Thanks for the nice comment man appreciate it!
Brilliant video
Nice vid. I would recommend adding 'for beginners' in the title
Awesome Kenji! Thank you so much! Love the comment about how "management probably isn't proficient in pivot tables" hahahaha
Thank you for crystal clear video
Brilliant, thanks as always Kenji!
Thanks for watching!!!
Great job.Thanks 🙌🤝👌👌
No worries! Thanks for watching :)
great video kenji! super helpful :)
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.
Very nicely explained. Thank You
Much appreciate your vdo and explanation. Thank a lot for this.
Thank You Very informative video on Pivots and straightaway useful.
Very informative brother ....really enjoying it.!!!!
Nice video, very clear and useful. Thanks for this!
Glad you enjoyed it!
Hey Kenji, can you make a video on advance pivot table. You explained it really well.
Needed this one thank you!
You're so welcome!
Great vids man! If you want a challenge, look into pharmaceutical pricing.
Thank you so much شكرا جزيلا
Really helpful!!
Glad you think so!
Excellent, clearly explained.
Glad it was helpful!
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?
V well explained.. just amazing
Thank you Kenji
Thanks for watching!
Good video, like the style of it!
Great to hear thanks for watching 🙌
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!
Great job
you the man!
Cheers!
How are you soooooo good in Excel?! I don't think I can ever reach your level T__T
Circle to circle ratios are logarithmic.
Interesting
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.
Love the video.
one question. i want to calculate MOM/YOY using pivot
can you help
Super helpful video, I was just wondering where you could get the data from, for example the sales data from Apple.
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)
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?
great :)
Thank you!
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?
Nice vedio
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.
Hi Mohammad, thank you for the comment! Will keep it noted :)
Subscribed
Lol it’s all about making it look presentable to the management team
Hi Kenji
Could you please share function...how to merge text with images (text on image)
*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.*
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.
@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.
I heard that his strategies are really good
@@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
He has really made a good name for himself
the besttttt
Cheers Solomon!
4:36
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.
SQL ❤️
Do you have power query video
Hi kenji , i'm want to learn the VBA ...it's anything from you ???
what's the mac shortcut for column width? :(
Is there a way to align the slicers like you would do it in PowerPoint?
That's a great point. I haven't found a way unfortunately!
Cool
Thanks!
awesome sir...
Thanks a ton!
My problem is I never know which of the 4 areas to drag the criteria
Dashboard?
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.
@4:42 the calculate option is greyed out for me.
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.
kenji :)
or just use PowerBI instead :)
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.
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
@@stefanosasiklaris4584 "Most data analysts use excel"
Source? Ah yes - you just made that up.
Your revenue not showing as negative is making my accounting head hurt.
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..
Indeed there’s a lot of money to be made in crypto markts trading,
How do I get to reach him!?.
@@kovalski6237
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.
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..
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.
Lots of blinking going on
I think you really know excel but slowing down would be my recommendation. You're moving to fast.
Set it to .75x speed
should set formatting on the pivot table values not cell formats. DOWN!