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.
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.
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.
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 😄
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?
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
Thanks for this. but why you have removed the formulas from Excel Sheet?
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.
Many new features which take Excel to another level. My favourites are Python and the Checkboxes.
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
Is this only in Excel 365 or even preview build 2024?
Excel just keeps getting better! Thanks for the clear and concise demo! 👏📈
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.
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 😄
Hi Kenji and community members, any good solutions for spellnumber other than VBA?
Good job and greetings from Kenya 🇰🇪
Awesome! Thank you for watching :)
Great video just used ..the navigation feature ...
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?
Helpful topics, I must say thank you
This is a fantastic channel!
Hi Kenji, do you have course for financial statements analysis by excel?
brilliant... Mr Kenji, Thanks
Thanks a lot for your tipps
Great 👍
Excellent!!
In which excel version it works
This is amazing ❤❤❤❤❤❤❤❤❤❤❤ Excel for everything 🎉🎉
haha yes!!
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!
Very nice
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.
Nice work
I didnt't got checkbox & python, any solution for it?
ooh really cool features!! thanks
Which version of this software
oh! my! gaWd! 💛🧡💙
Your Explanation is really too good
Thanks a lot 😊
Hi Kenji, i am a hospital revenue cycle manager . can you do some dashboard on revenue cycle.
Thx that was perfectb❤
Glad you liked it!
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
Chat gpt add in?
thanks
You're welcome!
i can't find the checkbox
Great
thank you
First 🥇😅🫂
lets go!
I don’t like the new excel look. I miss the rounded edges
💞🤍 💓🎄🍫☕😃
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 👍