اکنون در دسترس! پژوهش تلگرام ۲۰۲۵ — مهمترین بینشهای سال 
MS Excel for Data Analysis
رفتن به کانال در Telegram
✅ Learn Basic & Advaced Ms Excel concepts for data analysis ✅ Learn Tips & Tricks Used in Excel ✅ Become An Expert ✅ Use The Skills Learnt Here In Your Career For promotions: @love_data
نمایش بیشتر📈 تحلیل کانال تلگرام MS Excel for Data Analysis
کانال MS Excel for Data Analysis (@excel_analyst) در بخش زبانی انگلیسی بازیگری فعال است. در حال حاضر جامعه شامل 70 592 مشترک است و جایگاه 2 296 را در دسته آموزش و رتبه 4 834 را در منطقه الهند دارد.
📊 شاخصهای مخاطب و پویایی
از زمان ایجاد در невідомо، پروژه رشد سریعی داشته و 70 592 مشترک جذب کرده است.
بر اساس آخرین دادهها در تاریخ 04 ژوئن, 2026، کانال فعالیت پایداری دارد. در ۳۰ روز گذشته تغییر اعضا برابر 943 و در ۲۴ ساعت گذشته برابر 48 بوده و همچنان دسترسی گستردهای حفظ شده است.
- وضعیت تأیید: تأیید نشده
- نرخ تعامل (ER): میانگین تعامل مخاطب 4.40% است و در ۲۴ ساعت نخست پس از انتشار، محتوا معمولاً 1.62% واکنش نسبت به کل مشترکان کسب میکند.
- دسترسی پستها: هر پست به طور میانگین 3 102 بازدید دریافت میکند. در اولین روز معمولاً 1 146 بازدید جمعآوری میشود.
- واکنشها و تعامل: مخاطبان بهطور فعال حمایت میکنند؛ میانگین واکنش به هر پست 9 است.
- علایق موضوعی: محتوا بر موضوعات کلیدی مانند excel, cell, chart, pivot, row تمرکز دارد.
📝 توضیح و سیاست محتوایی
نویسنده این فضا را محل بیان دیدگاههای شخصی توصیف میکند:
“✅ Learn Basic & Advaced Ms Excel concepts for data analysis
✅ Learn Tips & Tricks Used in Excel
✅ Become An Expert
✅ Use The Skills Learnt Here In Your Career
For promotions: @love_data”
به لطف بهروزرسانیهای پرتکرار (آخرین داده در تاریخ 05 ژوئن, 2026)، کانال همواره بهروز و دارای دسترسی بالاست. تحلیلها نشان میدهد مخاطبان بهطور فعال با محتوا تعامل دارند و آن را به نقطه اثرگذاری مهم در دسته آموزش تبدیل کردهاند.
70 592
مشترکین
+4824 ساعت
+2447 روز
+94330 روز
در حال بارگیری داده...
کانالهای مشابه
ابر برچسبها
اشارات ورودی و خروجی
---
---
---
---
---
---
جذب مشترکین
ژوئن '26
ژوئن '26
+192
در 0 کانالها
مه '26
+1 023
در 6 کانالها
Get PRO
آوریل '26
+915
در 3 کانالها
Get PRO
مارس '26
+336
در 4 کانالها
Get PRO
فوریه '26
+992
در 9 کانالها
Get PRO
ژانویه '26
+1 598
در 3 کانالها
Get PRO
دسامبر '25
+1 557
در 1 کانالها
Get PRO
نوامبر '25
+1 414
در 6 کانالها
Get PRO
اکتبر '25
+842
در 1 کانالها
Get PRO
سپتامبر '25
+362
در 6 کانالها
Get PRO
اوت '25
+650
در 14 کانالها
Get PRO
ژوئیه '25
+685
در 10 کانالها
Get PRO
ژوئن '25
+1 241
در 21 کانالها
Get PRO
مه '25
+2 227
در 17 کانالها
Get PRO
آوریل '25
+3 493
در 12 کانالها
Get PRO
مارس '25
+848
در 16 کانالها
Get PRO
فوریه '25
+1 486
در 25 کانالها
Get PRO
ژانویه '25
+1 998
در 24 کانالها
Get PRO
دسامبر '24
+3 003
در 19 کانالها
Get PRO
نوامبر '24
+3 356
در 12 کانالها
Get PRO
اکتبر '24
+4 232
در 17 کانالها
Get PRO
سپتامبر '24
+3 493
در 15 کانالها
Get PRO
اوت '24
+3 739
در 13 کانالها
Get PRO
ژوئیه '24
+5 039
در 17 کانالها
Get PRO
ژوئن '24
+4 850
در 14 کانالها
Get PRO
مه '24
+4 515
در 8 کانالها
Get PRO
آوریل '24
+3 995
در 5 کانالها
Get PRO
مارس '24
+4 364
در 10 کانالها
Get PRO
فوریه '24
+3 278
در 2 کانالها
Get PRO
ژانویه '24
+4 746
در 3 کانالها
Get PRO
دسامبر '23
+5 078
در 4 کانالها
| تاریخ | رشد مشترکین | اشارات | کانالها | |
| 05 ژوئن | +19 | |||
| 04 ژوئن | +48 | |||
| 03 ژوئن | +43 | |||
| 02 ژوئن | +56 | |||
| 01 ژوئن | +26 |
پستهای کانال
🚀 𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 | 𝗚𝗲𝘁 𝗛𝗶𝗿𝗲𝗱 𝗶𝗻 𝗧𝗼𝗽 𝗧𝗲𝗰𝗵 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀! 💼🔥
Master the most in-demand tech skills and kickstart your career with industry-leading training.
🎯 Program Highlights:
✅ Learn Coding from Industry Experts
✅ Real-World Projects & Interview Preparation
✅ Dedicated Placement Support
✅ Avg. Package: ₹7.2 LPA
✅ Highest Package: ₹41 LPA 🚀
🎓 Perfect for Freshers, Students & Career Switchers
𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰 👇:-
https://pdlink.in/42WOE5H
Hurry! Limited seats are available.🏃♂️
| 2 | 🚀 Excel Interview Questions with Answers — Part 6
51. How do you sort data by one or multiple columns?
Sorting arranges data in ascending or descending order.
Single Column Sort:
1. Select data
2. Go to: Data → Sort A to Z
OR
Sort Z to A
📌 Example: Sort employee names alphabetically.
Multiple Column Sort:
1. Select dataset
2. Go to: Data → Sort
3. Add levels
Example:
First sort by Department
Then by Salary Highest to Lowest
📌 Useful for hierarchical analysis.
52. How do you use AutoFilter and custom filters?
AutoFilter helps display only relevant records.
Enable Filter:
Data → Filter
Shortcut: Ctrl + Shift + L
Filter Types:
• Text filters
• Number filters
• Date filters
• Color filters
Custom Filter Example:
Show sales greater than 50,000.
📌 Helps analyze specific subsets quickly.
53. How do you filter by blanks, non-blanks, or specific values?
Filter Blank Cells:
1. Open filter dropdown
2. Select: Blanks
Filter Non-Blanks:
Uncheck Blanks.
Filter Specific Values:
Select required values from checklist.
📌 Example: Show only “Completed” orders.
54. How do you remove duplicates from a list?
Steps:
1. Select data
2. Go to: Data → Remove Duplicates
3. Choose columns to check
📌 Example: Remove duplicate customer IDs.
Important:
⚠️ Always keep backup before removing duplicates because deletion is permanent.
55. How do you use conditional formatting with formulas?
Conditional formatting can use formulas for advanced highlighting.
Steps:
1. Select range
2. Go to: Conditional Formatting → New Rule → Use a Formula
Example:
Highlight values greater than average.
=A1>AVERAGE(A1:A10)
Example:
Highlight duplicate values.
=COUNTIF(A1:A10,A1)>1
📌 Useful for anomaly detection and dashboards.
56. How do you highlight top/bottom N values?
Steps:
1. Select data
2. Go to: Conditional Formatting → Top/Bottom Rules
Options:
• Top 10 Items
• Bottom 10 Items
• Top 10%
• Bottom 10%
📌 Example: Highlight top 5 sales performers.
57. How do you standardize and clean messy data e.g. “Yes / yes / Y” → “Yes”?
Data cleaning improves consistency and analysis quality.
Common Techniques:
Function : Purpose
TRIM : Remove extra spaces
UPPER/LOWER/PROPER : Standardize case
SUBSTITUTE : Replace text
CLEAN : Remove hidden characters
Example:
=PROPER(TRIM(A1))
Standardizing Values:
=IF(OR(A1="Y",A1="yes",A1="Yes"),"Yes","No")
📌 Very important in real-world reporting.
58. How do you use Text-to-Columns and Flash Fill for quick cleaning?
Text-to-Columns:
Splits data into separate columns.
Steps:
1. Select column
2. Go to: Data → Text to Columns
Delimiters:
• Comma
• Space
• Tab
• Custom symbol
📌 Example: Split "John,Doe" into two columns.
Flash Fill:
Automatically detects patterns.
Shortcut: Ctrl + E
📌 Example: Extract first names from full names automatically.
59. How do you create subtotals and grouped views?
Subtotals:
1. Sort data first
2. Go to: Data → Subtotal
Example:
Show total sales department-wise.
Excel can calculate:
• SUM
• COUNT
• AVERAGE
• MAX/MIN
Grouped Views:
Use: Data → Group
📌 Allows expanding/collapsing sections for cleaner reports.
60. How do you build a simple KPI or summary table?
A KPI table summarizes important business metrics.
Common KPIs:
• Total Sales
• Profit
• Growth %
• Customer Count
• Conversion Rate
Example Formula:
=SUM(B2:B100)
Percentage Growth:
Growth % = (Current - Previous) / Previous × 100
Excel Formula:
=(B2-A2)/A2
Best Practices for KPI Tables:
✅ Use conditional formatting
✅ Add charts/sparklines
✅ Keep layout clean
✅ Highlight important metrics | 372 |
| 3 | 🎰 Welcome Bonus 1200% — Maczo Crypto Casino
🎮 Crypto exchange · Sports · Live casino — all in one place
💳 USDT instant deposit & withdrawal
→ https://t.me/maczo_official_global | 616 |
| 4 | #ad | 616 |
| 5 |  Alt Powerful Shortcuts
1. Alt + = → AutoSum
2. Alt + H, O, I → AutoFit Column Width
3. Alt + H, O, A → AutoFit Row Height
4. Alt + H, B, A → Apply All Borders
5. Alt + H, V, V → Paste Values Only
6. Alt + ; → Select visible cells
7. Alt + A, E → Text to Columns
8. Alt + H, A, C → Centre Align
9. Alt + A, S, F → Filters on/off
10. Alt + N, V, T → Insert Pivot Table
Double Tap ❤️ For More | 1 373 |
| 6 |  🚀 𝗧𝗖𝗦 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟲 – 𝗘𝗻𝗿𝗼𝗹𝗹 𝗡𝗼𝘄!
TCS iON is offering FREE certification courses to help students, freshers & professionals build job-ready skills from home 🌍
✅ 100% Free Online Courses
✅ Free Verified Certificates
✅ Self-Paced Learning
✅ Beginner-Friendly Programs
✅ Learn from TCS Industry Experts
🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/4nTGSDh
🔥 Excellent opportunity to gain valuable certifications from one of India’s top IT companies completely FREE. | 1 509 |
| 7 | 📌 Essential Excel Functions & Features Cheatsheet 📊
Whether you're just starting out or prepping for data-related roles, mastering these Excel essentials can greatly enhance your efficiency! 💡
⬇️ Quick Excel reference:
1. SUM() – Adds values in a range.
2. AVERAGE() – Calculates average of values.
3. COUNT() – Counts numeric values.
4. COUNTA() – Counts non-empty cells.
5. COUNTIF() – Counts cells meeting a specific criterion.
6. SUMIF() – Sums values meeting a criterion.
7. AVERAGEIF() - Averages values meeting a criterion.
8. IF() – Performs logical tests; returns one value if TRUE, another if FALSE.
9. AND(), OR(), NOT() – Logical operators.
10. VLOOKUP() – Searches vertically for a value in a range.
11. HLOOKUP() – Searches horizontally for a value in a range.
12. INDEX() & MATCH() – More flexible alternative to VLOOKUP.
13. XLOOKUP() - Modern upgrade to VLOOKUP and HLOOKUP
14. TEXT() – Formats a number as text.
15. CONCATENATE() / CONCAT() – Joins multiple strings.
16. LEFT(), RIGHT(), MID() – Extracts characters from strings.
17. TRIM() – Removes extra spaces from a string.
18. UPPER(), LOWER(), PROPER() – Changes text case.
19. IFERROR() – Handles errors in formulas.
20. Pivot Tables – Summarize and analyze data dynamically.
21. Conditional Formatting - Highlights cells based on rules.
22. Data Validation - Restricts the data users can enter in a cell.
23. Charts - Visualize data using various chart types.
✅ Save this to boost your Excel productivity! 😉 | 3 158 |
| 8 |  𝗧𝗼𝗽 𝟯 𝗙𝗥𝗘𝗘 𝗣𝘆𝘁𝗵𝗼𝗻 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗜𝗻 𝟮𝟬𝟮𝟲! 🚀💻
These FREE certification courses can help you build strong programming skills and stand out from the crowd 👇
✅ Free Learning Resources
✅ Certificate Opportunities
✅ Beginner Friendly
✅ Boost Your Resume & Tech Skills
🌟 Perfect for students, freshers, aspiring developers, data analysts, and tech enthusiasts.
🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/43DnP6S
📌 Start learning today and level up your career with Python! | 3 014 |
| 9 | DATA ANALYST Interview Questions (0-3 yr) (SQL, Power BI)
👉 Power BI:
Q1: Explain step-by-step how you will create a sales dashboard from scratch.
Q2: Explain how you can optimize a slow Power BI report.
Q3: Explain Any 5 Chart Types and Their Uses in Representing Different Aspects of Data.
👉SQL:
Q1: Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() functions using example.
Q2 – Q4 use Table: employee (EmpID, ManagerID, JoinDate, Dept, Salary)
Q2: Find the nth highest salary from the Employee table.
Q3: You have an employee table with employee ID and manager ID. Find all employees under a specific manager, including their subordinates at any level.
Q4: Write a query to find the cumulative salary of employees department-wise, who have joined the company in the last 30 days.
Q5: Find the top 2 customers with the highest order amount for each product category, handling ties appropriately. Table: Customer (CustomerID, ProductCategory, OrderAmount)
👉Behavioral:
Q1: Why do you want to become a data analyst and why did you apply to this company?
Q2: Describe a time when you had to manage a difficult task with tight deadlines. How did you handle it?
I have curated best top-notch Data Analytics Resources 👇👇
https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02
Hope this helps you 😊 | 3 681 |
| 10 |  𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝘄𝗶𝘁𝗵 𝗚𝗲𝗻𝗔𝗜 𝗢𝗻𝗹𝗶𝗻𝗲 𝗪𝗲𝗯𝗶𝗻𝗮𝗿 😍
AI is replacing analysts who don't adapt.
Learn Data Analytics + GenAI with IBM & Microsoft certifications. Land your dream role with dedicated placement support.
🎓1200+ Hiring Partners. 128% avg hike. 35 LPA Highest CTC in Placements.
💫𝗕𝗼𝗼𝗸 𝘆𝗼𝘂𝗿 𝗙𝗥𝗘𝗘 𝘄𝗲𝗯𝗶𝗻𝗮𝗿 :-
https://pdlink.in/4uwBw3q
Hurry Up ♂️! Limited seats are available. | 3 032 |
| 11 | I see so many people jump into data analytics, excited by its popularity, only to feel lost or uninterested soon after. I get it, data isn’t for everyone, and that’s okay.
Data analytics requires a certain spark or say curiosity. You need that drive to dig deeper, to understand why things happen, to explore how data pieces connect to reveal a bigger picture. Without that spark, it’s easy to feel overwhelmed or even bored.
Before diving in, ask yourself, Do I really enjoy solving puzzles? Am I genuinely excited about numbers, patterns, and insights? If you’re curious and love learning, data can be incredibly rewarding. But if it’s just about following a trend, it might not be a fulfilling path for you.
Be honest with yourself. Find your passion, whether it’s in data or somewhere else and invest in something that truly excites you.
Hope this helps you 😊 | 3 382 |
| 12 |  𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀🎓
✨ Learn In-Demand Tech Skills
✨ Boost Your Resume & LinkedIn Profile
✨ Improve Career Opportunities
✨ Self-Paced Online Learning
✨ Great for Freshers & Students
🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/49p31Uh
🔥 Start learning today and prepare for high-paying tech careers with Microsoft free certification programs | 3 064 |
| 13 |  Double Tap ❤️ For More Excel Shortcut Keys | 3 266 |
| 14 |  𝗔𝗜 & 𝗠𝗟 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺 𝗯𝘆 𝗖𝗖𝗘, 𝗜𝗜𝗧 𝗠𝗮𝗻𝗱𝗶😍
Freshers get 15 LPA Average Salary with AI & ML Skills!
- Eligibility: Open to everyone
- Duration: 6 Months
- Program Mode: Online
- Taught By: IIT Mandi Professors
90% Resumes without AI + ML skills are being rejected.
𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇 :-
https://pdlink.in/4nmI024
Get Placement Assistance With 5000+ Companies | 3 194 |
| 15 | Keyboard #Shortcut Keys
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl W - Close
Ctrl+X - Cut
Ctrl+Y - Repeat
Ctrl+Z - Undo
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat last action
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F10 - Activate Menu bar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional functions in Excel’s menu
Shift+F1 - What’s This?
Shift+F2 - Edit cell comment
Shift+F3 - Paste function into formula
Shift+F4 - Find Next
Shift+F5 - Find
Shift+F6 - Previous Pane
Shift+F8 - Add to selection
Shift+F9 - Calculate active worksheet
Shift+F10 - Display shortcut menu
Shift+F11 - New worksheet
Ctrl+F3 - Define name
Ctrl+F4 - Close
Ctrl+F5 - XL, Restore window size
Ctrl+F6 - Next workbook window
Shift+Ctrl+F6 - Previous workbook window
Ctrl+F7 - Move window
Ctrl+F8 - Resize window
Ctrl+F9 - Minimize workbook
Ctrl+F10 - Maximize or restore window
Ctrl+F11 - Inset 4.0 Macro sheet
Ctrl+F1 - File Open
Alt+F1 - Insert Chart
Alt+F2 - Save As
Alt+F4 - Exit
Alt+Down arrow - Display AutoComplete list
Alt+’ - Format Style dialog box
Ctrl+Shift+~ - General format
Ctrl+Shift+! - Comma format
Ctrl+Shift+@ - Time format
Ctrl+Shift+# - Date format
Ctrl+Shift+$ - Currency format
Ctrl+Shift+% - Percent format
Ctrl+Shift+^ - Exponential format
Ctrl+Shift+& - Place outline border around selected cells
Ctrl+Shift+_ - Remove outline border
Ctrl+Shift+* - Select current region
Ctrl++ - Insert
Ctrl+- - Delete
Ctrl+1 - Format cells dialog box
Ctrl+2 - Bold
Ctrl+3 - Italic
Ctrl+4 - Underline
Ctrl+5 - Strikethrough
Ctrl+6 - Show/Hide objects
Ctrl+7 - Show/Hide Standard toolbar
Ctrl+8 - Toggle Outline symbols
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl+Shift+( - Unhide rows
Ctrl+Shift+) - Unhide columns
Alt or F10 - Activate the menu
Ctrl+Tab - In toolbar: next toolbar
Shift+Ctrl+Tab - In toolbar: previous toolbar
Ctrl+Tab - In a workbook: activate next workbook
Shift+Ctrl+Tab - In a workbook: activate previous workbook
Tab - Next tool
Shift+Tab - Previous tool
Enter - Do the command
Shift+Ctrl+F - Font Drop down List
Shift+Ctrl+F+F - Font tab of Format Cell Dialog box
Shift+Ctrl+P - Point size Drop down List
Ctrl + E - Align center
Ctrl + J - justify
Ctrl + L - align
Ctrl + R - align right
Alt + Tab - switch applications
Windows + P - Project screen
Windows + E - open file explorer
Windows + D - go to desktop
Windows + M - minimize all windows
Windows + S - search | 3 234 |
| 16 |  𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝘄𝗶𝘁𝗵 𝗔𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 | 𝟭𝟬𝟬% 𝗝𝗼𝗯 𝗔𝘀𝘀𝗶𝘀𝘁𝗮𝗻𝗰𝗲😍
Build Python, Machine Learning, and AI Skills
💫60+ Hiring Drives Every Month | Receive 1-on-1 mentorship
12.65 Lakhs Highest Salary | 500+ Partner Companies
𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗦𝗲𝘀𝘀𝗶𝗼𝗻 :- 👇:-
Online :- https://pdlink.in/4fdWxJB
🔹 Hyderabad :- https://pdlink.in/4kFhjn3
🔹 Pune:- https://pdlink.in/45p4GrC
🔹 Noida :- https://linkpd.in/DaNoida
Hurry Up 🏃♂️! Limited seats are available. | 2 925 |
| 17 | 🚀 Excel Interview Questions with Answers — Part 4
31. How do you use VLOOKUP and what are its limitations?
VLOOKUP searches for a value in the first column of a table and returns a value from another column.
Syntax:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example:
=VLOOKUP(A2,D2:F10,3,FALSE)
Meaning:
• Search value in A2
• Look in table D2:F10
• Return value from 3rd column
• FALSE = exact match
📌 Example: Find employee salary using employee ID.
Limitations of VLOOKUP:
❌ Searches only left to right
❌ Column number must be counted manually
❌ Breaks if columns are inserted/deleted
❌ Slower on very large datasets
✅ Modern alternative: XLOOKUP or INDEX + MATCH
32. How do you use HLOOKUP?
HLOOKUP searches horizontally across rows.
Syntax:
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example:
=HLOOKUP("Jan",A1:F3,2,FALSE)
📌 This searches for "Jan" in the first row and returns data from the second row.
Use Case:
Monthly reports where months are arranged horizontally.
33. How do you use INDEX + MATCH for flexible lookups?
INDEX + MATCH is more flexible and powerful than VLOOKUP.
MATCH
Finds position of a value.
=MATCH(A2,D2:D10,0)
INDEX
Returns value from a position.
=INDEX(E2:E10,3)
Combined Formula:
=INDEX(E2:E10,MATCH(A2,D2:D10,0))
📌 Example: Lookup salary using employee ID.
Advantages:
✅ Can lookup left or right
✅ More dynamic
✅ Safer when columns change
✅ Faster on large datasets
34. How do you use XLOOKUP (if available)?
XLOOKUP is the modern replacement for VLOOKUP.
Syntax:
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
Example:
=XLOOKUP(A2,D2:D10,E2:E10,"Not Found")
📌 Searches employee ID and returns salary.
Advantages:
✅ Searches both directions
✅ No column counting
✅ Built-in error handling
✅ Easier syntax
✅ More efficient
35. How do you use IF with AND / OR conditions?
AND
Returns TRUE only if all conditions are true.
Example:
=IF(AND(A1>=50,B1>=50),"Pass","Fail")
📌 Student passes only if both subjects are above 50.
OR
Returns TRUE if any condition is true.
Example:
=IF(OR(A1>=90,B1>=90),"Bonus","No Bonus")
📌 Bonus given if any score exceeds 90.
36. How do you use SUMIF, SUMIFS for conditional sums?
SUMIF
Adds values based on one condition.
Syntax:
=SUMIF(range,criteria,sum_range)
Example:
=SUMIF(A:A,"East",B:B)
📌 Sums sales only for East region.
SUMIFS
Handles multiple conditions.
Example:
=SUMIFS(C:C,A:A,"East",B:B,"Laptop")
📌 Sums laptop sales in East region.
37. How do you use COUNTIF, COUNTIFS for conditional counts?
COUNTIF
Counts cells matching one condition.
=COUNTIF(A:A,"Yes")
📌 Counts all “Yes” entries.
COUNTIFS
Counts using multiple conditions.
=COUNTIFS(A:A,"East",B:B,"Laptop")
📌 Counts laptop orders in East region.
38. How do you use AVERAGEIF, AVERAGEIFS?
AVERAGEIF
Calculates average based on one condition.
=AVERAGEIF(A:A,"East",B:B)
📌 Average sales in East region.
AVERAGEIFS
Uses multiple conditions.
=AVERAGEIFS(C:C,A:A,"East",B:B,"Laptop")
📌 Average laptop sales in East region.
39. How do you use COUNTBLANK, COUNTUNIQUE-style techniques?
COUNTBLANK
Counts empty cells.
=COUNTBLANK(A1:A20)
📌 Useful for finding missing data.
Count Unique Values (Older Excel):
=SUM(1/COUNTIF(A1:A10,A1:A10))
Modern Excel:
=COUNTA(UNIQUE(A1:A10))
📌 Counts unique customers/products/etc.
40. How do you use SUMPRODUCT for weighted calculations?
SUMPRODUCT multiplies arrays and returns the total.
Basic Example:
=SUMPRODUCT(A1:A5,B1:B5)
📌 Multiplies corresponding values and sums them.
Weighted Average Formula:
Weighted Average = SUM(xᵢ * wᵢ) / SUM(wᵢ) | 4 173 |
| 18 |  𝗔𝗜/𝗠𝗟 𝗿𝗼𝗹𝗲𝘀 𝗮𝗿𝗲 𝗳𝗮𝘀𝘁𝗲𝘀𝘁-𝗴𝗿𝗼𝘄𝗶𝗻𝗴 𝗰𝗮𝗿𝗲𝗲𝗿 𝗳𝗶𝗲𝗹𝗱 𝗶𝗻 𝟮𝟬𝟮𝟲😍
The demand is real, salaries are high, and the talent gap is wide open
Enrol for AI/ML Certification Program by CCE, IIT Mandi!
Eligibility: Open to everyone
Duration: 6 Months
Program Mode: Online
Taught By: IIT Mandi Professors
Deadline :- 23rd May
𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄👇 :-
https://pdlink.in/4nmI024
.
🎓Get Placement Assistance With 5000+ Companies | 3 340 |
| 19 | 🚀 Top 50 Data Analyst Interview Questions 📊💼
▎📊 EXCEL Questions
1. Can you show me how you'd clean this messy dataset in Excel? What functions like TRIM or Remove Duplicates would you use?
2. What's the difference between absolute ($A$1) and relative (A1) references? When do you use each?
3. Walk me through creating a PivotTable to analyze sales by region and product. What are the exact steps?
4. Write a VLOOKUP formula right now. What if you get #N/A? How do you fix it?
5. Why use INDEX-MATCH over VLOOKUP? Show me both formulas for this lookup.
6. What's COUNTIF vs SUMIF vs COUNTIFS? Write formulas for conditional sales totals.
7. How does Goal Seek work? Demo target revenue scenario on this data.
8. Apply conditional formatting to highlight top 10% sales performers. Which rule?
9. Build me a dynamic dashboard. How do slicers and timelines work together?
10. Explain SUMPRODUCT. Write formula for multi-condition sales sum.
11. What's Power Query? Show basic ETL steps for cleaning data.
12. Freeze panes vs split panes—when do you use each?
13. XLOOKUP vs VLOOKUP advantages? Write both for this example.
14. How do you find and fix circular references in formulas?
15. Create data validation dropdown + named ranges. Demo it.
▎🗄️ SQL Questions
16. Write query for 2nd highest salary from Employee table. Use subquery OR window function.
17. INNER JOIN vs LEFT JOIN vs FULL JOIN? Write examples for employees + departments.
18. Find and remove duplicate records. Use CTE + ROW_NUMBER() or GROUP BY.
19. WHERE vs HAVING with GROUP BY? Show department-wise avg salary > 50k.
20. RANK() vs DENSE_RANK() vs ROW_NUMBER()? Partition by dept, order by salary.
21. Top 5 products by total sales. Write complete query with GROUP BY + LIMIT.
22. Self-join for employee-manager hierarchy. Show employee name + manager name.
23. Handle NULL salaries. Use COALESCE, IS NULL, IFNULL examples.
24. Pivot sales data by month using CASE statements. Write query.
25. Subquery vs JOIN—which is faster for this scenario? Why?
26. Recursive CTE for company hierarchy (CEO → managers → employees).
27. Clustered vs non-clustered indexes? When does each improve performance?
▎🎨 Tableau Questions
28. {FIXED [Region]: SUM([Sales])}—what's this LOD doing? Write region total ignoring filters.
29. Create dual-axis chart comparing sales vs profit trends. Exact steps?
30. Data blending vs joining? When do you use each approach?
31. Parameters vs filters? Write calculated field using parameter.
32. Build dashboard with filter action + highlight action. Demo flow.
33. % of total calculated field? Write formula for region sales %.
34. FIXED vs INCLUDE vs EXCLUDE LOD? Give 3 examples.
35. Tableau Extracts vs Live connection? Performance + refresh differences?
▎⚡ Power BI Questions
36. CALCULATE(SUM(Sales), SAMEPERIODLASTYEAR())—explain this DAX. YoY growth?
37. Measures vs Calculated Columns? When do you use each? Write both.
38. Star schema vs Snowflake? Draw relationships for sales → products → customers.
39. Power Query: Write M code for custom column parsing dates.
40. Implement Row-Level Security (RLS). Show DAX for region manager filter.
41. DirectQuery vs Import mode? Pros/cons + when to choose each?
42. TOTALYTD(SUM(Sales))—explain time intelligence DAX.
43. Dashboard loads slow. Optimization steps? Aggregations + query folding?
▎🐍 Python/Pandas Questions
44. Group sales by region and sum: write pandas code. .reset_index()
45. pd.merge(df1, df2, on='ID', how='inner')—explain all merge types.
46. Three ways to handle NaN values: fillna(), dropna(), interpolate().
47. loc[] vs iloc[]? Filter sales > 1000 by region vs first 5 rows.
48. pivot_table() vs groupby()? Reshape sales by month/product.
49. Read 1GB CSV without crashing: chunksize=10000 example.
50. df['New'] = df['Sales'].apply(lambda x: x*1.1)—alternatives to apply?
Double Tap ♥️ For More | 3 686 |
| 20 |  🚀 𝗙𝗥𝗘𝗘 𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿 𝗧𝗲𝗰𝗵 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗨𝗽𝗴𝗿𝗮𝗱𝗲 𝗬𝗼𝘂𝗿 𝗖𝗮𝗿𝗲𝗲𝗿 🔥
Still confused where to start in tech? 🤔
These FREE beginner-friendly courses can help you build job-ready skills in 2026 🚀
✨ Learn in-demand skills like:
✔️ Programming & Tech Basics
✔️ Data & Digital Skills 📊
✔️ Career-Boosting Concepts 💡
✔️ Industry-Relevant Fundamentals
💯 Beginner Friendly + FREE Certificates 🎓
𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/4d4b1uK
💼 Perfect for Students, Freshers & Career Switchers | 3 299 |
