5 Advanced Excel Formulas You Probably Didn't Know! скачать в хорошем качестве

5 Advanced Excel Formulas You Probably Didn't Know!

Learn 5 advanced Excel formulas to become an advanced Excel user. 🔥 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour... 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/64ba5d... In this tutorial we go over 5 advanced excel formulas. The first function is the TEXTSPLIT, where we use several delimiters to split columns of data. Second, we go over the SUM and OFFSET combination using a nested formula to make a dynamic sum range. Third, we learn how to use the XLOOKUP with the wildcard feature to detect inconsistent data. Fourth, we use the INDEX MATCH with the ampersand (&) to use multiple criteria to lookup values. Finally, we learn the SUM FILTER combination which is most useful to sum ranges with duplicate filters. 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​ -​ Level 1 ADVANCED TEXTSPLIT 2:28​ - Level 2 SUM OFFSET 4:19​ - Level 3 XLOOKUP WILDCARD 6:53 - Level 4 INDEX MATCH AMPERSAND 9:05​ - Level 5: SUM OFFSET