NEW Excel Formulas You Need to Know

[@KenjiExplains]

🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/1c5

[@arnonomdo1341]

I still think the function should be called "DATE-DIF," not "DATED-IF"

[@kangjian]

I assume Kenji is dating someone. 😂

[@mahbubhossain1852]

Agreed! I do call it DATE-DIF 😊

[@dakshbhatnagar]

I am with you, there is no condition attached to the function, why would someone say dated if 😂

[@adityav4939]

'Dated if' has been there for so long in circulation, but you read the developers mind who created this - he/she called it 'Date-Dif' 👍👍 As that is what this built-in function is for 😁

[@antoniobacic5674]

Beautiful, thank you Kenji. The TAKE + SORT + CHOOSECOLS is very helpful.

[@nmarks]

The AI add-in was fantastic.

[@kayespedal10]

You are bright and easy to follow. I'm already applying these functions in production. Plus, I already DWNLD the Analytics guide today. Will see all your vids. Thank you

[@JHatLpool]

Nice demonstrations of some amazing new features. The capability of Excel is now unbelievable.

[@im.nurhadi_]

These combination of Take, Sort and Choosecol can be use as alternative of GSheet Query on Excel, A real game changer on Excel formulas, Thanks!

[@KenjiExplains]

Thanks for watching! :)

[@xaviergrewal]

Kenji, your videos are brilliant! Crisp and absolutely easy to follow👌🏽🙏🏽

[@christianwinter20]

Good to know, that the TEXTSPLIT function can take a list of delimiters as an argument and not only one. That was new for me👍

[@islammohsen3520]

To extract the Emails, you can use Ai.Extract formula better as you explained it in previous video. I would like to thank you, i learn from you a lot ❤❤

[@garybaotutorial]

Thank you for this. I am wondering which tools you are using for making this wonderful videos.

[@radiali482]

Really your taking us to super levels, than and many thanks

[@sallyho146]

Thanks. Can you do a video in comparing 1st and 2nd and what is the easiest:best way to extract difference?

[@camlex6310]

Really great tricks!! Thanks!!

[@rajsingh2363]

It seems we are not even using 10% of excel functions. Thanks for the info

[@JoseAntonioMorato]

Dear Kenji, Spilled formula and with a header it is better: =REDUCE({"First Name","Last Name","Age","Outcome"},B3:B14,LAMBDA(a,b,VSTACK(a,TEXTSPLIT(b,{" ",", "},,1)))) And TEXTJOIN with the right delimiters is better too: =TEXTJOIN({" ";", ";", "},,C3#) 🤗

[@radiali482]

correction : "Really you are taking us to super levels, thanks and many thanks"

[@sivabvbs2865]

Is regex under beta version? Coz as an employe with subscription to ms365 I am no getting the =regex while using. Can anyone help how to enable

[@jezzzNL]

will all this work in MS Office Home or only for MS 365?

[@KenjiExplains]

Hey I'm not too familiar with MS Office Home tbh so I can't comment. I'm currently on MS365

[@michaelt312]

From my understanding the new functions and features they roll out are generally for Office 365. That is one of the advantages of the subscription service.

[@willzinner8813]

do you know if the AI one will become a part of Excel (not an addin) at some point?

[@KenjiExplains]

I don't know tbh!

[@UKJ28]

Just wow..

[@wallywechs4694]

Hello Kenji, please share Excel version you are using with those updated formula. I need that .exe file to be on same page with you

[@KenjiExplains]

Hey I'm using microsoft365 (but I also get early access to some formulas before they're released to the general public). Many of these (except regex i think) should be available in microsoft365 already

[@imanuelachawngthu7451]

Handsome kenji

[@KenjiExplains]

thank you lol hopefully the video was useful XD

[@Dawoodkhan-ry1ss]

Sir from where should I download free updated MS Office for long time

[@calilthomas]

I Still don´t have these functions and my account is an insider one. What can I do to have them? Already updated excel several times.

[@tejasd1980]

I too don't have the choose cols formula

[@jimmyPOUFAJones]

My download and your video file did not match, I had country and units sold columns

[@kishanagrawal4243]

My excel not showing new formulas pls help me to get results

[@joblesstess]

create a regex to help me identify if there are numbers in a list of

[@roxipoxi3005]

Datedif was canceled as official formula because, in verry specific conditions, it may give an incorrect result

[@eto5609]

What version of Excel are you using? 2021 2024 Microsoft 365 or Office 365?

[@obi4830]

Hit the Tab key thereee.

[@polyvg]

DATEDIF is ancient history! Excel > Formulas and functions > More functions > DATEDIF function Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.

[@koobzor]

Alex Megos 👀

[@KenjiExplains]

Hahha glad you noticed XD

[@VVeiQuek]

Datedif is not new, it is just like Excel’s illegitimate child that came to light, It is so neglected that there is no helper text/explanation for the arguments, they don’t even bother to standardize the same keyword in VBA (Datediff), and the arguments also in the wrong order. It is a formula/command that would be useful for a newbie, yet only be told much later on when it is no longer in need.

[@ajitkainchi349]

Column A Chemistry Biotech, Chemistry Physics Column B Q1 Q3 Q1 I want pivot table result as below Chemistry Q1 (count 1) Q3 (count 1) Biotech Q3 (count 1) Physics Q1(count 1)

[@sergheyzaporojanu6872]

Guys! Today I noticed something supper odd. And now I wander was it always like this? Here's the issue/bug: in both Excel and GSheets the COUNT(range) and COUNTIF(range, "") formulas are counting the cells even if they have formula that outputs "" Blank results! WHATA HACK IS EVEN THAT?!

[@c.l4219]

Yeah, including chatgpt into excel with valuable company data.... Not going to happen.... 😂

[@Agressive324]

4:24 =C3& " " & D3 & "," & E3 & "," & F3 Result will be - Kylee Townsen,56,Pass