Data Analytics

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: 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 Find the running total of sales for each employee. 𝗠𝗲: Challenge accepted! 💪 =SUM(B2:B2) Copy the formula down. 💡 Explanation: The formula calculates a cumulative total as you move down the rows. B2 keeps the starting cell fixed. B2 changes as the formula is copied down. Each row adds the current employee's sales to all previous sales. 🎯 Expected Output Example Employee Sales Running Total John 12,000 12,000 Sarah 18,000 30,000 Mike 15,000 45,000 David 20,000 65,000 Alice 10,000 75,000 🚀 Bonus — Using Excel Table References If your data is formatted as an Excel Table named SalesData: =SUM(INDEX(SalesData[Sales],1):[@Sales]) This approach automatically expands as new rows are added to the table. 🚀 Tip for Excel Job Seekers: Running-total questions are common in Excel interviews because they test whether you understand cell references and cumulative calculations. Also practice: • Running totals • Running averages • Monthly cumulative sales • YTD calculations • Cumulative percentages These are frequently used in real-world reporting and dashboards. ❤️ React with ❤️ for more Excel interview challenges!

🚀 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗥𝗲𝘀𝘂𝗺𝗲 & 𝗖𝗼𝗻𝗳𝗶𝗱𝗲𝗻𝗰𝗲 🎓🔥 Make your resume stand out and feel more confident during your job search. 🚀 Build confidence and a career-focused mindset ✅ 100% FREE ✅ Beginner Friendly ✅ Improve Your Resume ✅ Develop Career-Ready Skills ✅ Great for Students, Freshers & Professionals 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-  https://pdlink.in/4gce062 🔥 Don't just apply for jobs — build the skills and confidence to stand out!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: 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 Find the employees whose salary is above the average salary of their department. 𝗠𝗲: Challenge accepted! 💪 =C2>AVERAGEIF(B2:B6,B2,C2:C6) 💡 Explanation: The formula compares each employee's salary with the average salary of their own department. • AVERAGEIF() calculates the average salary for the employee's department. • B2 identifies the current employee's department. • C2 is the employee's salary. The formula returns TRUE when the employee earns more than their department average. 🎯 Expected Output Example Employee Department Salary Above Dept. Average? John IT 75,000 FALSE Sarah HR 60,000 FALSE Mike IT 82,000 TRUE David Finance 90,000 FALSE Alice HR 65,000 TRUE 🚀 Bonus — Return the Employee Name Only In Excel 365: =FILTER( A2:A6, C2:C6>AVERAGEIF(B2:B6,B2:B6,C2:C6) ) This returns the employees whose salaries are above their respective department averages. ❤️ React with ❤️ for more Excel interview challenges!

📊 𝗕𝘂𝗶𝗹𝗱 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗣𝗼𝗿𝘁𝗳𝗼𝗹𝗶𝗼 | 𝟱 𝗛𝗮𝗻𝗱𝘀-𝗢𝗻 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 🚀 Learning Data Analytics? Don't stop with tutorials — build real projects that you can showcase on your resume and portfolio! 💻 🔥 Practice with 5 Hands-On Projects covering: 🗄️ SQL 📊 Excel 📈 Tableau 📉 Power BI 🔗𝗟𝗶𝗻𝗸 👇:-  https://pdlink.in/45LLDH7 🎓 Perfect for Students | Freshers | Data Analyst Aspirants | Beginners

📊 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 🚀 Want to start a career in Data Analytics & Business Intelligence? Learn Power BI through Microsoft learning modules and build practical, job-relevant analytics skills. 🎯 Perfect for Students | Freshers | Data Analyst Aspirants | Working Professionals 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-  https://pdlink.in/4zhGTX6 🔥 Start learning Power BI and turn raw data into powerful business insights!

𝗔𝗜 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 😍 Build real AI products - not just prompts 🎯 Program Highlights:- 🚀 15+ AI Projects 👨‍🏫 Live Online Classes + 1-on-1 Mentorship 💼 End-to-End Placement Support 🤝 500+ Partner Companies 🎓 2000+ Students Placed 💰 Average Salary: ₹7.4 LPA 🏆 Highest Salary: ₹41 LPA 🔗 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼 𝗖𝗹𝗮𝘀𝘀:- https://pdlink.in/4fWJVID 🔥 Learn AI → Build Real Projects → Create Your Portfolio → Become Job Ready

🇮🇳 𝗙𝗥𝗘𝗘 𝗚𝗼𝘃𝗲𝗿𝗻𝗺𝗲𝗻𝘁-𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗢𝗻𝗹𝗶𝗻𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 🎓 Upgrade your skills with *SWAYAM*, an initiative by the Government of India! ✅ Learn from leading institutes and expert educators ✅ Courses in AI, Programming, Data Science, Business & more ✅ Suitable for students, freshers and professionals ✅ Learn online at your own pace ✅ Strengthen your résumé with valuable certifications 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-  https://pdlink.in/4gc1MKx 📢 Share this opportunity with your friends and classmates!

30+ companies are hiring through AccioJob right now 🚀 From Software Development to Data & Analytics — AccioJob learners get access to hiring opportunities across multiple roles. And the outcomes speak for themselves: ✅ 2,100+ Students Placed ✅ ₹7.4 LPA Avg | ₹41 LPA Highest ✅ Real-world Projects ✅ Mock Interviews + 100% Placement Support Learn job-ready skills with Data Analytics and prepare for opportunities that actually exist. 👉 Register now: https://go.acciojob.com/55G3bH

🚀 DATA ANALYTICS + AI: YOUR NEXT CAREER MOVE! Data is everywhere. The right skills can put you ahead. Join the PW Skills Data Analytics With AI Course and learn Excel, SQL, Python, Power BI & AI tools through live sessions and real-world projects. ✨ What you get: ✅ Industry-relevant Data Analytics skills ✅ AI-powered learning ✅ Microsoft collaboration ✅ Hands-on projects ✅ Job assistance* ✅ Live classes in Hinglish 📅 Starts: 14th August 2026 ⏳ Duration: 5 Months 🔥 Ready to become a future-ready Data Analyst? 👉 Enroll Now & Start Your Upskilling Journey! https://lp.pwskills.com/data-analytics-with-gen-ai-online-course?utm_source=telegram&utm_medium=influencer&utm_campaign=deepakDAonline

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄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!

🚀 𝗚𝗼𝗼𝗴𝗹𝗲 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟲 🎓 Want to upgrade your resume with Google skills and certifications Explore FREE learning opportunities and build in-demand skills for today's job market. 👉Artificial Intelligence & Generative AI 📊 Data Analytics ☁️ Cloud Computing 📢 Digital Marketing 🔐 Cybersecurity 💻 Tech & Career Skills 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-  https://pdlink.in/4z9pdgf 🔥 Don't just collect certificates — build skills that can help you stand out in 2026!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗿: 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 average salary of employees who earn more than 70,000? 𝗠𝗲: Challenge accepted! 💪 =AVERAGEIF(C2:C6,">70000",C2:C6) 💡 Explanation: AVERAGEIF() calculates the average of values that meet a specific condition. C2:C6 is the salary range. ">70000" filters salaries greater than 70,000. The result is the average of the qualifying salaries. This challenge tests your understanding of: ✅ AVERAGEIF() ✅ Conditional Calculations ✅ Criteria-Based Analysis 🎯 Expected Output Example Employee Salary John 75,000 Mike 82,000 David 90,000 Average salary: 82,333.33 🚀 Bonus (Multiple Conditions) Find the average salary of employees in the IT department who earn more than 70,000: =AVERAGEIFS(C2:C6,B2:B6,"IT",C2:C6,">70000") This combines multiple criteria using AVERAGEIFS(). ❤️ React with ❤️ for more Excel interview challenges!

🚀 𝗙𝗥𝗘𝗘 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗯𝘆 𝗧𝗼𝗽 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀🔥 Get FREE access to company-specific interview kits, previous questions, preparation strategies, and important resources! 👇 Google :- https://pdlink.in/4xtUyIG Amazon :- https://pdlink.in/45Q0YWR Microsoft :- https://pdlink.in/3Up1bha Wipro :- https://pdlink.in/4fMo1rA Infosys :- https://pdlink.in/3TRn8p0 📌 share it with friends preparing for placements

15 Advanced Excel Shortcut Keys • Navigation 1. Move to last used cell → Ctrl + End 2. Move to first cell → Ctrl + Home 3. Select to last used cell → Ctrl + Shift + End 4. Select to first cell → Ctrl + Shift + Home • Rows  Columns 5. Insert entire row → Ctrl + Shift + + 6. Delete entire row → Ctrl + - 7. Hide selected rows → Ctrl + 9 8. Unhide rows → Ctrl + Shift + 9 9. Hide selected columns → Ctrl + 0 10. Unhide columns → Ctrl + Shift + 0 • Formatting 11. Open Format Cells → Ctrl + 1 12. Apply General format → Ctrl + Shift + ~ 13. Apply Number format → Ctrl + Shift + ! 14. Apply Percentage format → Ctrl + Shift + % 15. Apply Currency format → Ctrl + Shift + $ Double Tap ♥️ For More

🚀 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 📊🔥 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

𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 📊 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!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: 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!

🚀 𝗧𝗼𝗽 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗔𝘀𝗸𝗲𝗱 𝗯𝘆 𝗟𝗲𝗮𝗱𝗶𝗻𝗴 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀 📊 💼 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!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: 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!

🚀 𝗜𝗕𝗠 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 🎓 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!