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