NEW Excel Formulas You Need to Know

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/courses

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