𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄e𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee Department Salary

John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000


How would you find the second highest salary in the IT department?

𝗠𝗲: Challenge accepted! 💪

=LARGE(FILTER(C2:C6,B2:B6="IT"),2)

💡 Explanation:

This formula combines FILTER() and LARGE() to find the second highest salary within a specific department.

- FILTER(C2:C6,B2:B6="IT") returns only salaries from the IT department.
- LARGE(...,2) returns the second largest value from those salaries.

The result is 75,000.


This challenge tests your understanding of: ✅ FILTER()
✅ LARGE()
✅ Conditional Filtering
✅ Combining Excel Functions


🚀 Bonus (Without FILTER)

For older Excel versions, you can use:

=AGGREGATE(14,6,C2:C6/(B2:B6="IT"),2)

Here:

14 represents LARGE.

6 ignores errors.

B2:B6="IT" filters the calculation to the IT department.

2 returns the second largest value.


❤️ React with ❤️ for more Excel interview challenges!

Notion is hiring Software Engineer (Developer Expereince)

For 2015, 2016, 2017 grads
Location: Hyderabad

https://jobs.ashbyhq.com/notion/49bdf081-6e20-4323-8c73-6d6b19544ff5

Arcadis is hiring Graduate Engineer

For 2022, 2023, 2024, 2025 grads
Location: Bangalore

https://jobs.arcadis.com/careers/job/563671532643966?domain=arcadis.com

𝗻𝟴𝗻. $𝟮.𝟯 𝗯𝗶𝗹𝗹𝗶𝗼𝗻 𝘃𝗮𝗹𝘂𝗮𝘁𝗶𝗼𝗻. 𝟴𝟱,𝟬𝟬𝟬+ 𝗚𝗶𝘁𝗛𝘂𝗯 𝘀𝘁𝗮𝗿𝘀.
Still not on your learning list?

High demand. Low competition.
That's the window right now.
And it's closing faster than most people realize.

𝗪𝗵𝗮𝘁 𝗶𝘀 𝗻𝟴𝗻?

https://www.linkedin.com/feed/update/urn:li:share:7495692689452007424/

A recruiter sees SQL, Power BI, Python on your resume.
Still rejects you.

Because tools are not the job.
Analytical thinking is.

And most freshers never learn the difference.

https://www.linkedin.com/feed/update/urn:li:ugcPost:7498584894227410944/

A fresher DM'd me this week.
"6 months in. Still no clarity."

He had tried Python. Tableau. R. SQL.
All at once.
No depth anywhere.

I gave him one answer:

The order matters more than the tools.

Here's what to actually prioritize first:

https://www.linkedin.com/feed/update/urn:li:share:7499353779415302144/

I was reviewing a fresher's portfolio last week.
Beautiful dashboard. Zero question.

That's the mistake I keep seeing.
And it quietly kills your chances in every interview.

Here's what the pattern looks like:
https://www.linkedin.com/feed/update/urn:li:share:7500057785079001088/

Access Claude AI Opus 5 FREE + DeepSeek & Pro AI Models | $500 Credits, API Key, No Card (2026)

🔗 USEFUL LINKS:
https://seekai.cc/sign-up?aff=gkC1
https://api.justwoker.icu/register?aff=6VFp
https://tabitoken.com/sign-up?aff=YiKI

Access Claude AI Opus 5 FREE + DeepSeek & Pro AI Models | $500 Credits, API Key, No Card (2026)

🔗 USEFUL LINKS:
https://seekai.cc/sign-up?aff=gkC1
https://api.justwoker.icu/register?aff=6VFp
https://tabitoken.com/sign-up?aff=YiKI

Hey 👋

Just posted something on LinkedIn that I think will hit close to home for anyone learning Data Analytics.

It's about that gap nobody talks about — between finishing a course and surviving your first real project.

🔗 Read it here and drop a comment if it resonates:
https://www.linkedin.com/feed/update/urn:li:activity:7501494799334744064/

Would mean a lot if you liked, commented, or shared it. Takes 10 seconds. 🙏

🎯 DATA ANALYST INTERVIEW PREP

If you're a fresher, these are the questions you should prepare before applying for Data Analyst roles.

📊 EXCEL

• What is VLOOKUP vs XLOOKUP?
• What is a Pivot Table?
• How do you remove duplicates?
• How do you use IF, SUMIF and COUNTIF?

🗄️ SQL

• Difference between WHERE and HAVING?
• INNER JOIN vs LEFT JOIN?
• What is GROUP BY?
• Difference between ROW_NUMBER and RANK?
• How do you find duplicate records?

📈 POWER BI

• What is the difference between Power Query and DAX?
• What is a Measure?
• What is a Calculated Column?
• What is Data Modeling?
• What is a Star Schema?

💼 BUSINESS QUESTIONS

• How would you analyse declining sales?
• What KPIs would you track?
• How do you find insights from a dataset?
• How would you explain your dashboard to a non-technical manager?

📌 Don't try to memorise answers.

Practice explaining each answer with a real project from your portfolio.

🎯 Best preparation strategy:

Learn → Practice → Build Projects → Explain Your Work

💼 Data Analyst Jobs
📚 Free Learning Resources
🎯 Interview Preparation

🎬🔥 10 AI VIDEO TOOLS YOU SHOULD KNOW!

Still using expensive editing software for everything? 👀 These AI tools can save you hours.

1️⃣ Luma Dream Machine – Generate cinematic videos from text or images.
2️⃣ HeyGen – Create AI avatar videos from your script.
3️⃣ InVideo AI – Turn a simple prompt into a complete video.
4️⃣ VEED AI – Generate and edit videos with AI.
5️⃣ Descript – Edit videos by editing the transcript.
6️⃣ Klap – Turn long videos into Shorts/Reels automatically.
7️⃣ Vidnoz AI – Create AI presenter and explainer videos.
8️⃣ Adobe Express – Quickly create social videos with templates and AI tools.
9️⃣ Hailuo AI – Generate creative AI video clips from prompts.
🔟 Kling AI – Create realistic text-to-video and image-to-video clips.

📌 Save this post for your next video project.

📤 Share this with a creator who needs these tools! 🚀