NEW Excel Formulas You Need to Know in 2025

Опубликовано: 25 Февраль 2025
на канале: Kenji Explains

55,241

1.9k

5 New Excel Formulas You Should Know
🚀Get the FREE Data Analytics Guide from Hubspot: https://clickhubspot.com/1c5

🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.co...

In this video we go over some of the best new excel formulas Microsoft has released. These include the CHOOSECOLS formula which we can use th choose specific columns from a table. The TEXTSPLIT & TEXTJOIN to split and merge columns of text. The REGEX functions (REGEXTEST and REGEXEXTRACT) to extract text from an email and test if a certain condition is true. The GROUPBY function to group values and replace pivot tables, and the AI.FILL and AI.EXTRACT functions using an Excel add in. Finally, we have a bonus formula called DATEDIF to find the difference between 2 dates.

LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
🚀 All our courses: https://www.careerprinciples.com/all-...

SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00 - CHOOSECOLS
1:18 - Adding SORT
1:53 - Adding TAKE
2:20 - TEXTSPLIT
3:50 - TEXTJOIN
5:55 - REGEXTEST
6:59 - REGEXEXTRACT
7:50 - GROUPBY
8:56 - PERCENTOF
9:38 - AI.FILL
10:43 - AI.EXTRACT
11:20 - DATEDIF