I'm using TH-cam 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 TH-camrs 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
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!
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.
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
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
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.
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: th-cam.com/video/b-K1jUY3jDs/w-d-xo.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.
loved this video, was simple and straight to the point. Perfect for beginners like me. thank you Kenji!
I'm using TH-cam 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 🙏
Dear Kenji,
Great job!
I would like to acknowledge that you are one of the best TH-camrs 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 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! 👍
Thanks Kenji! As a Product Manager, these tables will be easier for our Executives to interpret.. and easier for me to create 🤣. Cheers !
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
oh my God! so happy to have discovered this! watched it at 1.5 speed with breakfast tea
Thanks from Bangladesh. That slicer thing was impressive!
Amazing stuff Kenji!!....I'm addicted to your channel!!
Love to hear it Rohan thanks for watching!
Thanks, I have never done a pivot table before, but will have a go when I get a chance. Excellent tutorial.👏👏👏👏💯
Thanks for creating such an amazing content!!
Great job, watching every video of you
Awesome video Kenji, thanks for the info 👍👍
I learned something new! This is very helpful. Thank you!
Glad it was helpful!
Kenji, your the man,, thank you once again!!!!
Thanks for the nice comment man appreciate it!
really enjoyed this video.....very easy to follow along. Thanks
Glad it was helpful!
This video is fantastic! The entire video is so good! *Thank you!*
Nice vid. I would recommend adding 'for beginners' in the title
Great Works....
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
9.01 is the most accurate statement ever!
Much appreciate your vdo and explanation. Thank a lot for this.
Thank you for crystal clear video
Really good presentation Kenji, joy to follow and understanding made easy too. Thank you.
Very helpful and understanding videos 🔦👍
Hey Kenji, can you make a video on advance pivot table. You explained it really well.
great video kenji! super helpful :)
Thank You Very informative video on Pivots and straightaway useful.
Great vids man! If you want a challenge, look into pharmaceutical pricing.
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?
Brilliant video
Very nicely explained. Thank You
Brilliant, thanks as always Kenji!
Thanks for watching!!!
Very informative brother ....really enjoying it.!!!!
Great job.Thanks 🙌🤝👌👌
No worries! 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!
Thank you so much شكرا جزيلا
Nice video, very clear and useful. Thanks for this!
Glad you enjoyed it!
Excellent, clearly explained.
Glad it was helpful!
Good video, like the style of it!
Great to hear thanks for watching 🙌
Needed this one thank you!
You're so welcome!
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.
Really helpful!!
Glad you think so!
Awesome Kenji! Thank you so much! Love the comment about how "management probably isn't proficient in pivot tables" hahahaha
V well explained.. just amazing
Great job
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.
Thank you Kenji
Thanks for watching!
Love the video.
one question. i want to calculate MOM/YOY using pivot
can you help
How are you soooooo good in Excel?! I don't think I can ever reach your level T__T
you the man!
Cheers!
Hi kenji , i'm want to learn the VBA ...it's anything from you ???
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.
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)
Hi Kenji
Could you please share function...how to merge text with images (text on image)
Do you have power query video
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?
Lol it’s all about making it look presentable to the management team
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?
Interesting
Circle to circle ratios are logarithmic.
what's the mac shortcut for column width? :(
Nice vedio
great :)
Thank you!
Subscribed
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 :)
My problem is I never know which of the 4 areas to drag the criteria
*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
SQL ❤️
the besttttt
Cheers Solomon!
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!
Your revenue not showing as negative is making my accounting head hurt.
Dashboard?
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.
or just use PowerBI instead :)
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:36
@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 :)
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!