Data Analytics
111K subscribers
204 photos
2 files
919 links
Perfect channel to learn Data Analytics

Learn SQL, Python, Alteryx, Tableau, Power BI and many more

For Promotions: @coderfun @love_data
Download Telegram
Last 25 seats | Batch closing this week!
โ€‹
โ€‹๐—”๐—œ & ๐——๐—ฎ๐˜๐—ฎ ๐—ฆ๐—ฐ๐—ถ๐—ฒ๐—ป๐—ฐ๐—ฒ ๐—ฃ๐—ฟ๐—ผ๐—ด๐—ฟ๐—ฎ๐—บ (๐—ก๐—ผ ๐—–๐—ผ๐—ฑ๐—ถ๐—ป๐—ด ๐—ก๐—ฒ๐—ฒ๐—ฑ๐—ฒ๐—ฑ)

E&ICT Academy, IIT Roorkee is closing admissions for their Data Science & AI Certification on 2nd August 2026.

โœ… No coding background needed
โœ… IIT faculty-led program
โœ… Certificate from E&ICT IIT Roorkee

๐—”๐—ฝ๐—ฝ๐—น๐˜† ๐—ฏ๐—ฒ๐—ณ๐—ผ๐—ฟ๐—ฒ ๐˜€๐—ฒ๐—ฎ๐˜๐˜€ ๐—ณ๐—ถ๐—น๐—น ๐˜‚๐—ฝ:-

https://pdlink.in/4aYWald

๐Ÿ’ซDeadline: 2nd August 2026
โค5
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee ID | Employee Name | Sales
--- | --- | ---
101 | John | 12,000
102 | Sarah | 18,000
103 | Mike | 15,000
104 | David | 20,000

How would you return "Yes" if an employee's sales are greater than or equal to 15,000, otherwise return "No"?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

=IF(C2>=15000,"Yes","No")

๐Ÿ’ก Explanation:

The IF() function checks whether a condition is true or false.

C2>=15000 checks if the sales value is at least 15,000.

If the condition is TRUE, Excel returns "Yes".

If the condition is FALSE, Excel returns "No".

๐ŸŽฏ Expected Output Example


+----------+--------+----------+
| Employee | Sales | Eligible |
+----------+--------+----------+
| John | 12,000 | No |
| Sarah | 18,000 | Yes |
| Mike | 15,000 | Yes |
| David | 20,000 | Yes |
+----------+--------+----------+


๐Ÿš€ Bonus (Using Nested IF)

=IF(C2>=20000,"Excellent", IF(C2>=15000,"Good","Needs Improvement"))

This formula categorizes employees into three performance levels:

โ€ข Excellent โ†’ Sales โ‰ฅ 20,000
โ€ข Good โ†’ Sales โ‰ฅ 15,000
โ€ข Needs Improvement โ†’ Sales < 15,000

๐Ÿš€ The IF() function is one of the most frequently asked Excel interview topics. Once you're comfortable with it, practice:

IFS()

IFERROR()

AND()

OR()

SWITCH()

These logical functions are widely used in reports, dashboards, and business decision-making.

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค21
๐๐š๐ฒ ๐€๐Ÿ๐ญ๐ž๐ซ ๐๐ฅ๐š๐œ๐ž๐ฆ๐ž๐ง๐ญ - ๐†๐ž๐ญ ๐๐ฅ๐š๐œ๐ž๐ ๐ˆ๐ง ๐“๐จ๐ฉ ๐Œ๐๐‚'๐ฌ ๐Ÿ˜

Learn Coding From Scratch - Lectures Taught By IIT Alumni

๐Ÿ’ซUpskill on the most in-demand skills in the market

๐—›๐—ถ๐—ด๐—ต๐—น๐—ถ๐—ด๐—ต๐˜๐˜€:-

๐Ÿ’ผ Avg. Package: โ‚น7.2 LPA | Highest: โ‚น41 LPA

๐ŸŒŸ Trusted by 7500+ Students
๐Ÿค 500+ Hiring Partners

Eligibility: BTech / BCA / BSc / MCA / MSc

๐‘๐ž๐ ๐ข๐ฌ๐ญ๐ž๐ซ ๐๐จ๐ฐ ๐Ÿ‘‡:-

 https://pdlink.in/42WOE5H

Hurry! Limited seats are available.๐Ÿƒโ€โ™‚๏ธ
โค1
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ:
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 count the number of unique departments?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

=COUNTA(UNIQUE(B2:B6))

๐Ÿ’ก Explanation:
The UNIQUE() function extracts distinct department names, and COUNTA() counts how many unique values are returned.

UNIQUE(B2:B6) returns: IT, HR, Finance.
COUNTA() counts these unique values.

The result is the total number of unique departments.

This challenge tests your understanding of: โœ… UNIQUE()
โœ… COUNTA()
โœ… Dynamic Arrays
โœ… Data Analysis

๐ŸŽฏ Expected Output Example

Formula | Result
=COUNTA(UNIQUE(B2:B6)) | 3

(The unique departments are IT, HR, and Finance.)

๐Ÿš€ Bonus (For Older Excel Versions)
=SUMPRODUCT((B2:B6<>"")/COUNTIF(B2:B6,B2:B6))

This formula counts unique values without using the UNIQUE() function, making it compatible with older versions of Excel.

๐Ÿš€ Tip for Excel Job Seekers:
Modern Excel functions are becoming increasingly common in interviews. Be familiar with:

UNIQUE()
FILTER()
SORT()
SEQUENCE()
TEXTSPLIT()

These dynamic array functions simplify complex formulas and are widely used in Microsoft 365.

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค13
๐Ÿ“Š ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜๐—ถ๐—ฐ๐˜€ ๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐—ป๐˜€๐—ต๐—ถ๐—ฝ ๐—ฃ๐—ฟ๐—ผ๐—ด๐—ฟ๐—ฎ๐—บ ๐Ÿš€

Company Name :- Collegedunia

โœ… Role: Data Analyst Intern
๐Ÿ“ Location: Gurugram, Haryana
๐Ÿข Work Mode: On-site
๐Ÿ‘ฉโ€๐Ÿ’ป Experience: Freshers / Students

๐Ÿ”— ๐—”๐—ฝ๐—ฝ๐—น๐˜† ๐—ก๐—ผ๐˜„ ๐Ÿ‘‡:

https://pdlink.in/3RNPbF7

โณ Apply Before the link expires!
โค3
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ: 
You have 2 minutes to solve this Excel problem.

You have the following data:
+----------+--------+
| Employee | Sales  |
+----------+--------+
| John     | 12,000 |
| Sarah    | 18,000 |
| Mike     | 15,000 |
| David    | 20,000 |
| Alice    | 10,000 |
+----------+--------+

How would you rank each employee based on their sales, with the highest sales getting Rank 1?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

=RANK(C2,C2:C6,0)

๐Ÿ’ก Explanation:

The RANK() function returns the rank of a number within a list.

โ€ข C2 is the sales value to rank.
โ€ข C2:C6 is the fixed range containing all sales values.
โ€ข 0 ranks values in descending order, so the highest sales receive Rank 1.
โ€ข Copy the formula down to rank all employees.

This challenge tests your understanding of: โœ… RANK() 
โœ… Relative & Absolute References 
โœ… Ranking Data 
โœ… Excel Formulas 

๐ŸŽฏ Expected Output Example
+----------+--------+------+
| Employee | Sales  | Rank |
+----------+--------+------+
| John     | 12,000 | 4    |
| Sarah    | 18,000 | 2    |
| Mike     | 15,000 | 3    |
| David    | 20,000 | 1    |
| Alice    | 10,000 | 5    |
+----------+--------+------+

๐Ÿš€ Bonus (Handle Duplicate Rankings)

=RANK.EQ(C2,C2:C6,0)

Or use:

=RANK.AVG(C2,C2:C6,0)

RANK.EQ() assigns the same rank to duplicate values. 
RANK.AVG() assigns the average rank to duplicate values.

๐Ÿš€ Be comfortable using:

โ€ข RANK()
โ€ข RANK.EQ()
โ€ข RANK.AVG()
โ€ข LARGE()
โ€ข SMALL()

These functions are frequently used in sales reports, leaderboards, and performance dashboards.

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค14
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ:
You have 2 minutes to solve this Excel problem.

You have the following data:


+----------+--------+
| Employee | Sales |
+----------+--------+
| John | 12,000 |
| Sarah | 18,000 |
| Mike | 15,000 |
| David | 20,000 |
| Alice | 10,000 |
+----------+--------+


How would you return "High Performer" if sales are greater than or equal to 18,000, "Average Performer" if sales are between 12,000 and 17,999, otherwise return "Low Performer"?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

=IFS(
C2>=18000,"High Performer",
C2>=12000,"Average Performer",
TRUE,"Low Performer"
)


๐Ÿ’ก Explanation:
The IFS() function checks multiple conditions in sequence and returns the result for the first condition that evaluates to TRUE.

โ€ข If sales are 18,000 or more, it returns "High Performer".
โ€ข If sales are 12,000 or more, it returns "Average Performer".
โ€ข Otherwise, it returns "Low Performer".

This challenge tests your understanding of:
โœ… IFS()
โœ… Logical Functions
โœ… Multiple Conditions
โœ… Data Categorization

๐ŸŽฏ Expected Output Example


Employee: John
Sales: 12,000
Performance: Average Performer

Employee: Sarah
Sales: 18,000
Performance: High Performer

Employee: Mike
Sales: 15,000
Performance: Average Performer

Employee: David
Sales: 20,000
Performance: High Performer

Employee: Alice
Sales: 10,000
Performance: Low Performer


๐Ÿš€ Bonus (Compatible with Older Excel Versions)

=IF(C2>=18000,
"High Performer",
IF(C2>=12000,
"Average Performer",
"Low Performer"))


Nested IF() functions provide the same result and work in Excel versions that don't support IFS().

๐Ÿš€ Tip for Excel Job Seekers:
Logical functions are heavily used in reporting and dashboards. Make sure you're comfortable with:

โ€ข IF()
โ€ข IFS()
โ€ข AND()
โ€ข OR()
โ€ข IFERROR()

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค17
๐Ÿš€ ๐— ๐—ฎ๐˜€๐˜๐—ฒ๐—ฟ ๐—œ๐—ป-๐——๐—ฒ๐—บ๐—ฎ๐—ป๐—ฑ ๐—ฆ๐—ธ๐—ถ๐—น๐—น๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜! ๐Ÿ’ป๐Ÿ”ฅ

Want to future-proof your career without spending a single rupee? These 4 beginner-friendly FREE courses will help you build practical, job-ready skills

๐Ÿ“š FREE Courses Included
๐Ÿ“Š Business Intelligence Using Excel
๐Ÿค– Generative AI for Beginners
๐Ÿ’ป C Programming for Beginners
๐Ÿ’ซ Python Interview Questions & Answers

๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—™๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜๐Ÿ‘‡:- 

https://pdlink.in/4hSgTuW

๐Ÿ”ฅ Don't waitโ€”start learning today and unlock better career opportunities!
โค2
๐Ÿฏ ๐—ง๐—ผ๐—ฝ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ | ๐—•๐—ผ๐—ผ๐—ธ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ผ๐˜‚๐—ป๐˜€๐—ฒ๐—น๐—น๐—ถ๐—ป๐—ด ๐—ฆ๐—ฒ๐˜€๐˜€๐—ถ๐—ผ๐—ป ๐—œ๐—ป ๐—–๐—ต๐—ฒ๐—ป๐—ป๐—ฎ๐—ถ๐Ÿ˜
โ€‹
Learnfrom India's Best Mentors , Get 100% Placement Assistance

๐Ÿ’ซData Analytics :- https://pdlink.in/4q59ef1
โ€‹
๐Ÿ’ซFullstack :- https://pdlink.in/4he12a2
โ€‹
๐Ÿ’ซAI :- https://pdlink.in/4he5mpO
โ€‹
In Today's competitive world, you need industry-relevant skills taught by the best.
โค1
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee: Joining Date
John: 15-Jan-2022
Sarah: 20-Mar-2021
Mike: 10-Jul-2023
David: 05-Nov-2020

How would you calculate the number of years each employee has worked in the company?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

Formula:
=DATEDIF(B2,TODAY(),"Y")

๐Ÿ’ก Explanation:
The DATEDIF() function calculates the difference between two dates.
B2 is the employee's joining date.
TODAY() returns the current date.
"Y" returns the number of completed years between the two dates.

Copy the formula down to calculate the years of service for all employees.

This challenge tests your understanding of:
โœ… DATEDIF()
โœ… TODAY()
โœ… Date Functions
โœ… Employee Tenure Calculation

๐ŸŽฏ Expected Output Example

Employee: Joining Date: Years of Service
John: 15-Jan-2022: 4
Sarah: 20-Mar-2021: 5
Mike: 10-Jul-2023: 3
David: 05-Nov-2020: 5

Results will change automatically as time passes because TODAY() is dynamic.

๐Ÿš€ Bonus: Calculate Complete Years and Months
=DATEDIF(B2,TODAY(),"Y")&" Years "&DATEDIF(B2,TODAY(),"YM")&" Months"

Example Output:
4 Years 6 Months
2 Years 3 Months

๐Ÿš€ Tip for Excel Job Seekers:
Date functions are commonly asked in Excel interviews. Make sure you're comfortable with:
TODAY(), NOW(), DATEDIF(), EDATE(), EOMONTH(), YEAR(), MONTH(), DAY()

These functions are widely used in HR, finance, payroll, and reporting.

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค17๐Ÿฅฐ3
๐Ÿš€ ๐— ๐—ฎ๐˜€๐˜๐—ฒ๐—ฟ ๐—”๐—œ ๐—™๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜ | ๐Ÿฑ ๐— ๐˜‚๐˜€๐˜-๐—ง๐—ฎ๐—ธ๐—ฒ ๐—š๐—ผ๐—ผ๐—ด๐—น๐—ฒ ๐—”๐—œ ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐Ÿ”ฅ

Artificial Intelligence is transforming every industryโ€”and now you can learn directly from Google with 100% FREE AI courses!

๐ŸŽฏ Perfect For
๐ŸŽ“ Students & Freshers
๐Ÿ‘จโ€๐Ÿ’ป Software Developers
๐Ÿ“Š Data Analysts
๐Ÿ’ซ AI & Machine Learning Aspirants
๐Ÿ’ผ Working Professionals

๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—™๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜๐Ÿ‘‡:- 

https://pdlink.in/45HWa5Q

๐Ÿ”ฅ Start your AI journey today and stay ahead in the era of Artificial Intelligence!
โค1
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ:
You have 2 minutes to solve this Excel problem.

You have the following data:
Employee | Salary
John | 75,000
Sarah | 60,000
Mike | 82,000
David | 90,000
Alice | 65,000

How would you return the second highest salary?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

=LARGE(B2:B6,2)

๐Ÿ’ก Explanation:
The LARGE() function returns the Nth largest value from a range.
B2:B6 is the range containing salary values.
2 tells Excel to return the second largest value.
In this example, the result is 82,000.

This challenge tests your understanding of:
โœ… LARGE()
โœ… Ranking Values
โœ… Statistical Functions

๐ŸŽฏ Expected Output Example
Formula: =LARGE(B2:B6,2) | Result: 82,000

๐Ÿš€ Bonus: Return the Employee Name with the Second Highest Salary
For Microsoft 365 / Excel 2021:
=XLOOKUP(LARGE(B2:B6,2),B2:B6,A2:A6)

For older versions of Excel:
=INDEX(A2:A6,MATCH(LARGE(B2:B6,2),B2:B6,0))

These formulas return Mike, who has the second highest salary.

๐Ÿš€ Tip for Excel Job Seekers:
Interviewers often ask questions involving the Nth highest or Nth lowest value. Make sure you're comfortable with:
โ€ข LARGE()
โ€ข SMALL()
โ€ข RANK()
โ€ข SORT()
โ€ข FILTER()

These functions are frequently used in dashboards, reports, and data analysis tasks.

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค11๐Ÿ”ฅ4
๐Ÿš€ ๐Ÿฐ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐—ง๐—ผ ๐—•๐—ผ๐—ผ๐˜€๐˜ ๐—ฌ๐—ผ๐˜‚๐—ฟ ๐—ฅ๐—ฒ๐˜€๐˜‚๐—บ๐—ฒ๐Ÿ”ฅ

Add these 100% FREE certification courses to your resume and gain valuable, job-ready skills that employers look for.

โœ… 100% FREE Certification Courses
โœ… Beginner-Friendly Learning
โœ… Industry-Relevant Skills
โœ… Self-Paced Online Learning
โœ… Strengthen Your Resume & LinkedIn Profile
โœ… Improve Your Job & Internship Opportunities

๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—™๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜๐Ÿ‘‡:- 

https://pdlink.in/4bwkOtA

๐Ÿ”ฅ Invest in your skills today and give your resume the competitive edge it deserves!
โค4
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ:
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 calculate the highest salary in each department?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

For Excel 365 / Excel 2021:

=MAXIFS(C2:C6,B2:B6,E2)

(Assume cell E2 contains the department name, such as IT.)

๐Ÿ’ก Explanation:

The MAXIFS() function returns the maximum value that meets one or more conditions.

C2:C6 is the salary range.

B2:B6 is the department range.

E2 contains the department to search for.

Excel returns the highest salary for the selected department.


This challenge tests your understanding of: โœ… MAXIFS()
โœ… Conditional Functions
โœ… Data Analysis

๐ŸŽฏ Expected Output Example

Department Highest Salary

IT 82,000
HR 65,000
Finance 90,000


๐Ÿš€ Bonus (For Older Excel Versions)

=MAX(IF(B2:B6=E2,C2:C6))

Note: In older Excel versions, confirm this as an array formula by pressing Ctrl + Shift + Enter instead of just Enter.

๐Ÿš€ Tip for Excel Job Seekers:

The MAXIFS() and MINIFS() functions are frequently used in business reporting. Make sure you also practice:

SUMIFS()

COUNTIFS()

AVERAGEIFS()

MAXIFS()

MINIFS()


These are among the most commonly tested Excel functions in interviews and are essential for real-world reporting and dashboard creation.

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค13
๐Ÿš€ ๐—™๐—ฅ๐—˜๐—˜ ๐—™๐—ฟ๐—ฒ๐˜€๐—ต๐—ฒ๐—ฟ ๐—›๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐——๐—ฟ๐—ถ๐˜ƒ๐—ฒ | ๐—ง๐—ฒ๐—ฐ๐—ต ๐—ฅ๐—ผ๐—น๐—ฒ๐˜€ ๐—จ๐—ฝ ๐˜๐—ผ โ‚น๐Ÿญ๐Ÿฎ ๐—Ÿ๐—ฃ๐—”!๐Ÿ”ฅ

Internship + Pre-Placement Offer

๐Ÿ’ผ Company: GoComet
๐Ÿ’ฐ Stipend: โ‚น30,000โ€“35,000/Month
๐Ÿš€ PPO: Up to โ‚น12 LPA

๐Ÿ“ Assessment Centres: Pune | Hyderabad | Noida | Chennai | Bangalore

๐Ÿ”— ๐—”๐—ฝ๐—ฝ๐—น๐˜† ๐—ก๐—ผ๐˜„ ๐Ÿ‘‡:

Full Stack Intern:- https://pdlink.in/4z3vF8o

AI First SDET Interns :- https://pdlink.in/4hS1Am2

โณ Limited Hiring Slots Available
โค3
๐Ÿš€ ๐—œ๐—•๐—  ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐ŸŽ“

Upgrade your tech skills with 100% FREE IBM certification courses and build a strong foundation in AI, Data Science, Cloud Computing, SQL, Python, and Machine Learning.

๐ŸŽฏ Perfect For
๐ŸŽ“ Students & Freshers
๐Ÿ‘จโ€๐Ÿ’ป Software Developers
๐Ÿ“Š Data Analysts
๐Ÿค– AI & Data Science Aspirants
๐Ÿ’ผ Working Professionals

๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—™๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜๐Ÿ‘‡:- 

https://pdlink.in/45KgqDR

๐Ÿ”ฅ Start learning today and prepare yourself for high-paying opportunities in the tech industry!
โค4
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ:

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

Question: How would you calculate the total salary for employees who belong to the IT department and earn more than 80,000?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

=SUMIFS(C2:C6,B2:B6,"IT",C2:C6,">80000")


๐Ÿ’ก Explanation:

The SUMIFS() function adds values based on multiple conditions.

โ€ข C2:C6 is the range to sum (Salary)

โ€ข B2:B6,"IT" includes only employees from the IT department

โ€ข C2:C6,">80000" includes only salaries greater than 80,000

Excel returns the total salary for employees meeting both conditions.

This challenge tests your understanding of:

โœ… SUMIFS()

โœ… Multiple Criteria

โœ… Conditional Aggregation

โœ… Data Analysis

๐ŸŽฏ Expected Output Example

Formula: =SUMIFS(C2:C6,B2:B6,"IT",C2:C6,">80000")

Result: 82,000

(Only Mike meets both conditions.)

๐Ÿš€ Bonus (Using Cell References for Dynamic Criteria)

=SUMIFS(C2:C6,B2:B6,E2,C2:C6,">"&F2)


If:

E2 = IT

F2 = 80000

The formula becomes dynamic and updates automatically when the criteria change.

๐Ÿš€ Tip for Excel Job Seekers:

SUMIFS() is one of the most frequently used Excel functions in reporting and dashboards. Be comfortable using it with multiple conditions such as:

Department + Salary

Region + Month

Product + Category

Employee + Performance

Mastering SUMIFS() is essential for Excel interviews and real-world business reporting.

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค5
๐Ÿš€ ๐—ง๐—ผ๐—ฝ ๐—ฃ๐—ผ๐˜„๐—ฒ๐—ฟ ๐—•๐—œ ๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„ ๐—ค๐˜‚๐—ฒ๐˜€๐˜๐—ถ๐—ผ๐—ป๐˜€ ๐—”๐˜€๐—ธ๐—ฒ๐—ฑ ๐—ฏ๐˜† ๐—Ÿ๐—ฒ๐—ฎ๐—ฑ๐—ถ๐—ป๐—ด ๐—–๐—ผ๐—บ๐—ฝ๐—ฎ๐—ป๐—ถ๐—ฒ๐˜€ ๐Ÿ“Š

๐Ÿ’ผ Companies hiring Power BI professionals include: Microsoft, Deloitte, Accenture, Capgemini, TCS, Infosys, Cognizant, EY, PwC, KPMG, IBM, Wipro, and many more.

โœ… Frequently Asked Interview Questions
โœ… Beginner to Advanced Level Coverage
โœ… Improve Your Problem-Solving Skills
โœ… Build Interview Confidence
โœ… Prepare for Top MNC Hiring Drives

๐‹๐ข๐ง๐ค๐Ÿ‘‡:-

https://pdlink.in/4xqxg6v

๐Ÿ”ฅ Master Power BI interview concepts and take one step closer to landing your dream Data Analytics job!
โค1
๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„๐—ฒ๐—ฟ:
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 employee with the highest salary in the IT department?

๐— ๐—ฒ: Challenge accepted! ๐Ÿ’ช

=XLOOKUP(
MAXIFS(C2:C6,B2:B6,"IT"),
C2:C6,
A2:A6
)


๐Ÿ’ก Explanation:
This formula combines MAXIFS() and XLOOKUP() to find the employee with the highest salary within a specific department.

MAXIFS() finds the highest salary where the department is IT.
XLOOKUP() searches for that salary in the Salary column.
It returns the corresponding employee name.

This challenge tests your understanding of:
โœ… MAXIFS()
โœ… XLOOKUP()
โœ… Multiple Criteria
โœ… Combining Excel Functions

๐ŸŽฏ Expected Output Example
Department | Highest Salary | Employee
IT | 82,000 | Mike

๐Ÿš€ Bonus (Dynamic Department)
If cell E2 contains the department name:

=XLOOKUP(
MAXIFS(C2:C6,B2:B6,E2),
C2:C6,
A2:A6
)


Now you can change E2 to HR, Finance, or another department and get the corresponding highest-paid employee.

โš ๏ธ Interview Tip:
If two employees have the same highest salary, XLOOKUP() returns the first matching employee. Be ready to explain how you would modify the formula if the interviewer wants all employees tied for the highest salary.

โค๏ธ React with โค๏ธ for more Excel interview challenges!
โค7
๐—™๐—ฅ๐—˜๐—˜ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜๐—ถ๐—ฐ๐˜€ & ๐——๐—ฎ๐˜๐—ฎ ๐—ฆ๐—ฐ๐—ถ๐—ฒ๐—ป๐—ฐ๐—ฒ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐Ÿ“Š

Start learning with FREE courses from leading companies and build in-demand skills for 2026.

๐Ÿ”น Data Analytics Essentials โ€” Cisco
๐Ÿ”น Introduction to Data Science โ€” Cisco
๐Ÿ”น Python for Data Science โ€” IBM
๐Ÿ”น Azure Data Fundamentals โ€” Microsoft
๐Ÿ”น Google Analytics โ€” Google

๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—™๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜๐Ÿ‘‡:- 

https://pdlink.in/45QpA1I

๐Ÿ”ฅ Start learning today and upgrade your resume with job-ready Data & Analytics skills!
โค2๐Ÿ‘1
๐Ÿš€ ๐— ๐—ถ๐—ฐ๐—ฟ๐—ผ๐˜€๐—ผ๐—ณ๐˜ ๐—™๐—ฅ๐—˜๐—˜ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜๐—ถ๐—ฐ๐˜€ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐Ÿ“Š๐Ÿ”ฅ

Build in-demand Data Analytics skills with Microsoft and strengthen your resume with FREE learning opportunities.

โœ… Beginner-Friendly
โœ… Learn at Your Own Pace
โœ… Build Job-Ready Data Skills
โœ… Improve Your Resume & LinkedIn Profile
โœ… Prepare for Data Analyst & BI Careers

๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—™๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜๐Ÿ‘‡:- 

https://pdlink.in/4hXL4Ru

๐Ÿ”ฅ Start learning today and take your first step toward a career in Data Analytics & Business Intelligence
โค1