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:
?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 - 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
