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