Make Excel Formulas Flexible with the "&" Sign

How to use the Ampersand & in Excel to make flexible formulas.
📈 Take our Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course

🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/sziocdr7u3

Most people think the ampersand in excel is just used to link text. While that is a use case, it's just scratching the surface as to what Excel can do. So let me show you 5 practical use cases of the & ampersand in Excel. First it can be used to replace the CONCAT and TEXTJOIN functions. Second, it can be used to create dynamic titles in an Excel file and Excel charts. Third, we can make formulas flexible. For example, with an XLOOKUP, instead of just having one lookup value, we're able to add multiple lookup values with the ampersand. Fourth, we're able to create approximate matches with the wildcard feature. Finally, we can create control panels to calculate things like the total sum revenue in each worksheet.

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
🚀 All our courses: https://www.careerprinciples.com/all-courses

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ 1. Replacing Formulas
2:17​ - 2. Dynamic Titles
5:25​ - 3. Flexible Formulas
7:49​ - 4. Approximate Formulas
10:00​ - 5. Control Panel

Видео Make Excel Formulas Flexible with the "&" Sign канала Kenji Explains