Absolutely mind-blowing content! The way you've highlighted the best new Excel features for 2024 is incredibly informative and helpful. It's impressive how Excel continues to evolve, and your breakdown of these latest updates is a game-changer for anyone working with data. Kudos to you for keeping us ahead of the curve!
Hi Kenji, love how you explain every topic in your videos. I have a question, when using TOROW is there an ¨UNIQUE¨ function for that formula? I've tried it and doesn't worked. Thanks in advanced.
Enjoyed your video very much. Good explainations, but I did have to find out the hard way that when using UNIQUE with TOROWS the formula has to include TRUE at the end, =UNIQUE(TOROW(B3:F12),TRUE). It is hard to keep up with new features and your videos are helpful. Hope to see you cover GROUPBY in the future.
I have been following your excellent videos to support me in a new Data Analyst role Am I able to contact you with a particularly complicated issue I am struggling with?
Hi Kenji! I was wondering if you could film a video on the intern project and any tips you may have! It would super helpful and I would love to hear your perspective 😄
Yes but you need to be on the microsoft invite list to get Python for Excel. Secondly learning Python is more of a valuable skill than VBA as many companies value Python experience now. VBA is slowly dying, even PowerBI doesn't support VBA and Microsoft hasn't released many updates to VBA in a long time.
I have a problem that’s driving me crazy! I am Getting and Transforming raw data from a text /csv, the raw data does not have a table and no formation. I’m prepping the raw data while still in text format by adding semicolons so I can delineate during import. After delineating, I’m transforming and transposing because I need to view the raw data from left to right. The only problem is I need 7 columns per row, the way I have it now the data is continuously on row 1, 450 columns across the first row! I cannot get the columns to make a new row every 7th column. Please help!
🔥 Take our Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
Absolutely mind-blowing content! The way you've highlighted the best new Excel features for 2024 is incredibly informative and helpful. It's impressive how Excel continues to evolve, and your breakdown of these latest updates is a game-changer for anyone working with data. Kudos to you for keeping us ahead of the curve!
Many new features which take Excel to another level. My favourites are Python and the Checkboxes.
Excel just keeps getting better! Thanks for the clear and concise demo! 👏📈
This is a fantastic channel!
Is this only in Excel 365 or even preview build 2024?
Great video just used ..the navigation feature ...
Hi Kenji, love how you explain every topic in your videos. I have a question, when using TOROW is there an ¨UNIQUE¨ function for that formula? I've tried it and doesn't worked. Thanks in advanced.
Good job and greetings from Kenya 🇰🇪
Awesome! Thank you for watching :)
Enjoyed your video very much. Good explainations, but I did have to find out the hard way that when using UNIQUE with TOROWS the formula has to include TRUE at the end, =UNIQUE(TOROW(B3:F12),TRUE). It is hard to keep up with new features and your videos are helpful. Hope to see you cover GROUPBY in the future.
Thank you! You've answered my question.
please make a video on how to calculate rolling returns.
I have been following your excellent videos to support me in a new Data Analyst role
Am I able to contact you with a particularly complicated issue I am struggling with?
Hi Kenji! I was wondering if you could film a video on the intern project and any tips you may have! It would super helpful and I would love to hear your perspective 😄
So surely this video will help
Can we use Python insread of vba coding?
I means can we completely replace vba coding with python in excel?
Yes but you need to be on the microsoft invite list to get Python for Excel. Secondly learning Python is more of a valuable skill than VBA as many companies value Python experience now. VBA is slowly dying, even PowerBI doesn't support VBA and Microsoft hasn't released many updates to VBA in a long time.
@@skillswithsid yes....thanku so much
Hi Kenji and community members, any good solutions for spellnumber other than VBA?
This is amazing ❤❤❤❤❤❤❤❤❤❤❤ Excel for everything 🎉🎉
haha yes!!
Thanks a lot for your tipps
brilliant... Mr Kenji, Thanks
Nice work
ooh really cool features!! thanks
Excellent!!
No I don't want a wikipedia feature, its not meant to be there
I don't really use Excel but I'm wondering what was the intended purpose of the wiki add on
In his videos he always says "Hit the top key there" when typing out a formula, can someone please tell me what key that is. Sorry I'm new to this.
I also want to ask, can I use my phone 📱 to learn data analysis???
oh! my! gaWd! 💛🧡💙
Hi Kenji, do you have course for financial statements analysis by excel?
Your Explanation is really too good
Thanks a lot 😊
In which excel version it works
I didnt't got checkbox & python, any solution for it?
Hi Kenji, i am a hospital revenue cycle manager . can you do some dashboard on revenue cycle.
I have a problem that’s driving me crazy! I am Getting and Transforming raw data from a text /csv, the raw data does not have a table and no formation. I’m prepping the raw data while still in text format by adding semicolons so I can delineate during import. After delineating, I’m transforming and transposing because I need to view the raw data from left to right.
The only problem is I need 7 columns per row, the way I have it now the data is continuously on row 1, 450 columns across the first row! I cannot get the columns to make a new row every 7th column. Please help!
Thx that was perfectb❤
Glad you liked it!
Which version of this software
thanks
You're welcome!
Chat gpt add in?
Great
thank you
i can't find the checkbox
First 🥇😅🫂
lets go!
💞🤍 💓🎄🍫☕😃
what's wrong with your hairstyle.. previous one used to suits you more.. anyways video content is amazing as always
Hahaha sorry to hear that lol I think I just haven’t cut it in a while 😆
Glad you like the content that’s most important 👍