Скачать с ютуб 5 MUST-KNOW Excel Interview Questions в хорошем качестве

5 MUST-KNOW Excel Interview Questions

Most common Excel Interview Test Questions you need to know. 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour... 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/62ffa6... In this video we go over 5 of the most common excel interview test questions for business & finance roles such as a business analyst or a financial analyst. The questions are: Q1: Use two different formulas to look for a value within a table. You can use vlookup, xlookup, or index match for this Q2: Find the quantity sold to reach 10k in profit. You can use goal seek under what if analysis for this Q3: Clean this raw set of data. For this you can use the text to columns feature, alongside the conditional formatting to identify the relevant values Q4: Visualize the data. For this you can use a combo chart with two different axis Q5: Show by quarter, the quantity sold, the total sales, and the average sale price. This can be found using a pivot table Note: there is more than one way to do these questions. If you have any other methods, comment them below! LEARN: 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour... 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour... 🏦 The Investment Banking Program: https://www.careerprinciples.com/care... 🚀 All our courses: https://www.careerprinciples.com/all-... ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Q1 2:25​ - Q2 4:03​ - Q3 7:03​ - Q4 9:08​ - Q5 Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.