Best New Excel Features for 2024

Рет қаралды 62,166

Күн бұрын

Best New Excel features and formulas for 2024.
📈 Take our Complete Finance & Valuation Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this tutorial, we cover Microsoft Excel's latest features. Excel has been releasing hundreds of new features over the years, yet 90% of Excel users don't even know they exist. So let's go over 8 of their best new features. First up we have the navigation pane (also known as a table of contents). Second is the image feature, then the TOCOL formula, followed by the Search feature. In 5th, we have the checkboxes in Excel. Sixth is the python integration. Seventh is the textsplit formula and finally we have the Excel add-ins.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Navigation (TOC)
1:12 - Image Import
2:22 - TOCOL Formula
3:23 - Search Feature
4:10 - Checkboxes
5:07 - Python Integration
7:43 - TEXTSPLIT Formula
8:46 - Add-Ins

Пікірлер: 52

@KenjiExplains 6 ай бұрын

🔥 Take our Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course

@excelautomationtool 6 ай бұрын

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!

@sasavienne 6 ай бұрын

Many new features which take Excel to another level. My favourites are Python and the Checkboxes.

@aspectoflife 5 ай бұрын

brilliant... Mr Kenji, Thanks

@Amazzinguy 5 ай бұрын

Great video just used ..the navigation feature ...

@power-reconcile 2 ай бұрын

Excel just keeps getting better! Thanks for the clear and concise demo! 👏📈

@candideapple8764 6 ай бұрын

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 😄

@kirstinhartmann 4 ай бұрын

Thanks a lot for your tipps

@amoghdeshpande504 6 ай бұрын

please make a video on how to calculate rolling returns.

@camlex6310 6 ай бұрын

ooh really cool features!! thanks

@bill6387 4 ай бұрын

Excellent!!

@user-xr8dv2sr3q 6 ай бұрын

So surely this video will help

@user-gb6st7sk4g 5 ай бұрын

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.

@baotrannguyen7872 6 ай бұрын

Hi Kenji, do you have course for financial statements analysis by excel?

@godwillowiti7964 18 күн бұрын

Nice work

@GodWillIncreaseNitzborn 6 ай бұрын

Hi Kenji and community members, any good solutions for spellnumber other than VBA?

@Michael_Alaska 6 ай бұрын

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.

@yiminko6850 6 ай бұрын

Thank you! You've answered my question.

@brianndege5331 6 ай бұрын

Good job and greetings from Kenya 🇰🇪

@KenjiExplains 6 ай бұрын

Awesome! Thank you for watching :)

@mendeldarwin4223 3 ай бұрын

Is this only in Excel 365 or even preview build 2024?

@guisch6297 6 ай бұрын

Thx that was perfectb❤

@KenjiExplains 6 ай бұрын

Glad you liked it!

@user-ni4gc8lp9b 5 ай бұрын

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?

@nazarkamal8831 6 ай бұрын

This is amazing ❤❤❤❤❤❤❤❤❤❤❤ Excel for everything 🎉🎉

@KenjiExplains 6 ай бұрын

haha yes!!

@Technovation07 6 ай бұрын

Your Explanation is really too good

@KenjiExplains 6 ай бұрын

Thanks a lot 😊

@jbferreira231 6 ай бұрын

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.

@user-xr8dv2sr3q 6 ай бұрын

I also want to ask, can I use my phone 📱 to learn data analysis???

@ImranKhan-il9me 6 ай бұрын

In which excel version it works

@al-khwarizmiacademy9506 6 ай бұрын

Can we use Python insread of vba coding? I means can we completely replace vba coding with python in excel?

@skillswithsid 5 ай бұрын

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.

@al-khwarizmiacademy9506 5 ай бұрын

@@skillswithsid yes....thanku so much

@Dexter101x 6 ай бұрын

No I don't want a wikipedia feature, its not meant to be there

@Rctdcttecededtef 5 ай бұрын

I don't really use Excel but I'm wondering what was the intended purpose of the wiki add on

@Tryall200 6 ай бұрын

Hi Kenji, i am a hospital revenue cycle manager . can you do some dashboard on revenue cycle.

@romany4all 6 ай бұрын

Great

@KenjiExplains 6 ай бұрын

thank you

@WaheedMSI 28 күн бұрын

I didnt't got checkbox & python, any solution for it?

@Engin33r_XYZ 4 ай бұрын

Which version of this software

@user-kl3nn9db3n 5 ай бұрын

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!