Learn 5 advanced Excel formulas to become an advanced Excel user.
🔥 The Complete Finance & Valuation Course: careerprinciples.com/courses/finance-valuation-course

🆓 DOWNLOAD Free Excel file for this video: 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: careerprinciples.com/courses/excel-for-business-finance
🔥 Power BI for Business Analytics: careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: careerprinciples.com/courses/finance-valuation-course
🚀 All our courses: careerprinciples.com/courses

SOCIALS:
📸 Instagram - instagram.com/careerprinciples/?hl=en
🤳 TikTok - tiktok.com/@career_principles
🧑‍💻 LinkedIn - 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.

• 5 Advanced Excel Formulas You Probably Didn't Know! ( Download)
• 5 ADVANCED Excel Formulas to make you a PRO User ( Download)
• 19 Advanced Excel Shortcuts You Might Not Know ( Download)
• Top 10 Excel Tricks You Probably Didn't Know ( Download)
• 5 Impressive Visuals You Didn't Know Excel Could Do ( Download)
• 8 Awesome New Excel Formulas for 2024 | Do you know them ( Download)
• Top 10 Essential Excel Formulas for Analysts in 2024 ( Download)
• 5 Tricks to Become an Excel Wizard ( Download)
• 10 Excel Formulas That Will Set You Apart (+Cheat Sheet) ( Download)
• 10 Hidden Features in Microsoft Excel (You’ll Wish You Knew Sooner) ( Download)
• 5 Awesome Excel Shortcuts to Save You Hours of Time! ( Download)
• 20 Excel Shortcuts to Save You HOURS of Work ( Download)
• Advanced Excel Formulas (IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE) ( Download)
• Excel Tips - Don't Use Formulas! Use Ctrl + E Instead ( Download)
• Top 10 Most Important Excel Formulas - Made Easy! ( Download)