Excel Interview Test. Can you pass?
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/z47l05buuz
In this Excel interview test, you'll be tested in your excel proficiency through a 5-question Excel interview test from easy to hard. The first question is on conditional formatting, the second on using the IF statement and relative referencing. Thirdly, you'll have a data cleaning question using the textsplit formula of the text to columns feature. Fourth, you'll have a data analytics question using pivot tables, and finally you'll hvae a lookup question where you'll learn to use the XLOOKUP and the INDEX MATCH. At the very end, we'll also have a bonus question using the find & replace tool in Excel.
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 - Intro
0:22 - Q1 (Easy)
1:58 - Q2 (Comfortable)
4:00 - Q3 (Intermediate)
6:28 - Q4 (Hard)
8:13 - Q5 (Very Hard)
10:22 - Bonus Question (Expert)