NEW Excel Formulas You Need to Know in 2025 скачать в хорошем качестве

NEW Excel Formulas You Need to Know in 2025

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