Can You Pass This Excel Interview Test?

Can You Pass This Excel Interview Test?

1.114.802 Lượt nghe
Can You Pass This Excel Interview Test?
Try this Excel Interview test to see your level! 👉 Take our Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/644287dcb3a5b097c0a5e7df This Excel Interview Test has a total of 4 questions going from easy to hard. First we use conditional formatting to find the bottom 10 values. Second, we use a combination of an IF and an AND statement to accept or reject a project based on two criteria. Third, we use the goal seek tool on Excel under what if analysis to reach 5000 in profit. Finally, we use 2 different formulas to find the revenue in France for each month. For this we first use a SUMIFS with relative references. Second we use the XLOOKUP combined with the ampersand (&) so we can filter using multiple criteria. LEARN: 📈 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 🧑‍💻 The Data Analyst Program: https://www.careerprinciples.com/career-track/the-data-analyst-program 🚀 All our courses: https://www.careerprinciples.com/all-courses SOCIALS: 🎬 My Company YouTube Channel: https://www.youtube.com/@careerprinciples 📸 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​ -​ Question 1 (Easy) 1:17​ - Question 2 (Intermediate) 4:15 - Question 3 (Advanced) 6:30 -Question 4 (Expert)