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.com/rj0921tdx1
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/courses/power-bi-for-business-analytics
? The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
? Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
? All our courses: https://www.careerprinciples.com/all-courses
SOCIALS:
? Instagram - https://www.instagram.com/careerprinciples/?hl=en
? TikTok - https://www.tiktok.com/@career_principles
?? LinkedIn - https://www.linkedin.com/company/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