
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/cour... 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/644287... 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/cour... 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour... 🧑💻 The Data Analyst Program: https://www.careerprinciples.com/care... 🚀 All our courses: https://www.careerprinciples.com/all-... SOCIALS: 🎬 My Company YouTube Channel: / @careerprinciples 📸 Instagram - https://www.instagram.com/careerprinc... 🤳 TikTok - / career_principles 🧑💻 LinkedIn - / careerprinciples ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00 - Question 1 (Easy) 1:17 - Question 2 (Intermediate) 4:15 - Question 3 (Advanced) 6:30 -Question 4 (Expert)