Hellow guys, Welcome to my website, and you are watching 5 Advanced Excel Formulas You Probably Didn't Know!. and this vIdeo is uploaded by Kenji Explains at 2023-08-13T07:45:04-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | 5 Advanced Excel Formulas You Probably Didn't Know! |
| Video Uploader | Video From Kenji Explains |
| Upload Date | This Video Uploaded At 13-08-2023 14:45:04 |
| Video Discription | Learn 5 advanced Excel formulas to become an advanced Excel user. 🔥 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/64ba5da925947528293900a5 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: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🔥 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 🚀 All our courses: https://www.careerprinciples.com/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 - 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 Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you. |
| Category | Education |
| Tags | advanced excel functions | advanced excel formulas | excel formulas | excel functions | advanced excel | advanced excel tutorial | xlookup | xlookup wildcard | sum offset | nested formulas | sum filter | textsplit | textsplit function | index match | index match formula | index match multiple criteria | index match ampersand | sum filter excel | sum offset excel | offset function excel | intermediate excel functions | expert excel functions | advanced excel formula | essential excel formulas |
