uz
Feedback
MS Excel for Data Analysis

MS Excel for Data Analysis

Kanalga Telegramโ€™da oโ€˜tish

โœ… 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

Ko'proq ko'rsatish

๐Ÿ“ˆ Telegram kanali MS Excel for Data Analysis analitikasi

MS Excel for Data Analysis (@excel_analyst) Ingliz til segmentidagi kanali faol ishtirokchi. Hozirda hamjamiyat 70 592 obunachidan iborat bo'lib, Taสผlim toifasida 2 296-o'rinni va Hindiston mintaqasida 4 834-o'rinni egallagan.

๐Ÿ“Š Auditoriya koโ€˜rsatkichlari va dinamika

ะฝะตะฒั–ะดะพะผะพ sanasidan buyon loyiha tez oโ€˜sib, 70 592 obunachiga ega boโ€˜ldi.

04 Iyun, 2026 dagi oxirgi maโ€™lumotlarga koโ€˜ra kanal barqaror faollikka ega. Oxirgi 30 kunda obunachilar soni 943 ga, soโ€˜nggi 24 soatda esa 48 ga oโ€˜zgardi va umumiy qamrov yuqori darajada qolmoqda.

  • Tasdiqlash holati: Tasdiqlanmagan
  • Jalb etish (ER): Auditoriya oโ€˜rtacha 4.40% darajada jalb etiladi. Nashrdan keyingi dastlabki 24 soatda kontent odatda umumiy obunachilar sonining 1.62% ini tashkil etuvchi reaksiyalarni toโ€˜playdi.
  • Post qamrovi: Har bir post oโ€˜rtacha 3 102 marta koโ€˜riladi; birinchi sutkada odatda 1 146 ta koโ€˜rish yigโ€˜iladi.
  • Reaksiyalar va oโ€˜zaro taโ€™sir: Auditoriya faol: har bir postga oโ€˜rtacha 9 ta reaksiya keladi.
  • Tematik yoโ€˜nalishlar: Kontent excel, cell, chart, pivot, row kabi asosiy mavzularga jamlangan.

๐Ÿ“ Tavsif va kontent siyosati

Muallif resursni shaxsiy fikrni ifoda etish maydoni sifatida taโ€™riflaydi:
โ€œโœ… 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โ€

Yuqori yangilanish chastotasi (oxirgi maโ€™lumot 05 Iyun, 2026 da olingan) sababli kanal doimo dolzarb va katta qamrovli boโ€˜lib qoladi. Analitika auditoriya kontent bilan faol hamkorlik qilishini, uni Taสผlim toifasidagi muhim taโ€™sir nuqtasiga aylantirishini koโ€˜rsatadi.

70 592
Obunachilar
+4824 soatlar
+2447 kunlar
+94330 kunlar
Postlar arxiv
๐Ÿš€ 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

๐ŸŽฐ Welcome Bonus 1200% โ€” Maczo Crypto Casino ๐ŸŽฎ Crypto exchange ยท Sports ยท Live casino โ€” all in one place ๐Ÿ’ณ USDT instant dep
๐ŸŽฐ 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

#ad

Alt Powerful Shortcuts 1. Alt + = โ†’ AutoSum 2. Alt + H, O, I โ†’ AutoFit Column Width 3. Alt + H, O, A โ†’ AutoFit Row Height 4.
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

๐Ÿš€ ๐—ง๐—–๐—ฆ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ โ€“ ๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—ก๐—ผ๐˜„! TCS iON is offering FREE certifi
๐Ÿš€ ๐—ง๐—–๐—ฆ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ โ€“ ๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—ก๐—ผ๐˜„! 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.

๐Ÿ“Œ 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! ๐Ÿ˜‰

๐—ง๐—ผ๐—ฝ ๐Ÿฏ ๐—™๐—ฅ๐—˜๐—˜ ๐—ฃ๐˜†๐˜๐—ต๐—ผ๐—ป ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐—œ๐—ป ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ! ๐Ÿš€๐Ÿ’ป These FREE certification course
๐—ง๐—ผ๐—ฝ ๐Ÿฏ ๐—™๐—ฅ๐—˜๐—˜ ๐—ฃ๐˜†๐˜๐—ต๐—ผ๐—ป ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐—œ๐—ป ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ! ๐Ÿš€๐Ÿ’ป 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!

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 ๐Ÿ˜Š

๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜๐—ถ๐—ฐ๐˜€ ๐˜„๐—ถ๐˜๐—ต ๐—š๐—ฒ๐—ป๐—”๐—œ ๐—ข๐—ป๐—น๐—ถ๐—ป๐—ฒ ๐—ช๐—ฒ๐—ฏ๐—ถ๐—ป๐—ฎ๐—ฟ ๐Ÿ˜ AI is replacing analysts who don't adapt. Lear
๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜๐—ถ๐—ฐ๐˜€ ๐˜„๐—ถ๐˜๐—ต ๐—š๐—ฒ๐—ป๐—”๐—œ ๐—ข๐—ป๐—น๐—ถ๐—ป๐—ฒ ๐—ช๐—ฒ๐—ฏ๐—ถ๐—ป๐—ฎ๐—ฟ ๐Ÿ˜ 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.

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 ๐Ÿ˜Š

๐— ๐—ถ๐—ฐ๐—ฟ๐—ผ๐˜€๐—ผ๐—ณ๐˜ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€๐ŸŽ“ โœจ Learn In-Demand Tech Skills โœจ Boost Your Resume & L
๐— ๐—ถ๐—ฐ๐—ฟ๐—ผ๐˜€๐—ผ๐—ณ๐˜ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€๐ŸŽ“ โœจ 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

Double Tap โค๏ธ For More Excel Shortcut Keys
Double Tap โค๏ธ For More Excel Shortcut Keys

๐—”๐—œ & ๐— ๐—Ÿ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—ฃ๐—ฟ๐—ผ๐—ด๐—ฟ๐—ฎ๐—บ ๐—ฏ๐˜† ๐—–๐—–๐—˜, ๐—œ๐—œ๐—ง ๐— ๐—ฎ๐—ป๐—ฑ๐—ถ๐Ÿ˜ Freshers get 15 LPA Average Salary wit
๐—”๐—œ & ๐— ๐—Ÿ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—ฃ๐—ฟ๐—ผ๐—ด๐—ฟ๐—ฎ๐—บ ๐—ฏ๐˜† ๐—–๐—–๐—˜, ๐—œ๐—œ๐—ง ๐— ๐—ฎ๐—ป๐—ฑ๐—ถ๐Ÿ˜ 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

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

๐——๐—ฎ๐˜๐—ฎ ๐—ฆ๐—ฐ๐—ถ๐—ฒ๐—ป๐—ฐ๐—ฒ ๐˜„๐—ถ๐˜๐—ต ๐—”๐—œ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ | ๐Ÿญ๐Ÿฌ๐Ÿฌ% ๐—๐—ผ๐—ฏ ๐—”๐˜€๐˜€๐—ถ๐˜€๐˜๐—ฎ๐—ป๐—ฐ๐—ฒ๐Ÿ˜ Build P
๐——๐—ฎ๐˜๐—ฎ ๐—ฆ๐—ฐ๐—ถ๐—ฒ๐—ป๐—ฐ๐—ฒ ๐˜„๐—ถ๐˜๐—ต ๐—”๐—œ ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ | ๐Ÿญ๐Ÿฌ๐Ÿฌ% ๐—๐—ผ๐—ฏ ๐—”๐˜€๐˜€๐—ถ๐˜€๐˜๐—ฎ๐—ป๐—ฐ๐—ฒ๐Ÿ˜ 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.

๐Ÿš€ 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แตข)

๐—”๐—œ/๐— ๐—Ÿ ๐—ฟ๐—ผ๐—น๐—ฒ๐˜€ ๐—ฎ๐—ฟ๐—ฒ ๐—ณ๐—ฎ๐˜€๐˜๐—ฒ๐˜€๐˜-๐—ด๐—ฟ๐—ผ๐˜„๐—ถ๐—ป๐—ด ๐—ฐ๐—ฎ๐—ฟ๐—ฒ๐—ฒ๐—ฟ ๐—ณ๐—ถ๐—ฒ๐—น๐—ฑ ๐—ถ๐—ป ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ๐Ÿ˜ The demand is real, salarie
๐—”๐—œ/๐— ๐—Ÿ ๐—ฟ๐—ผ๐—น๐—ฒ๐˜€ ๐—ฎ๐—ฟ๐—ฒ ๐—ณ๐—ฎ๐˜€๐˜๐—ฒ๐˜€๐˜-๐—ด๐—ฟ๐—ผ๐˜„๐—ถ๐—ป๐—ด ๐—ฐ๐—ฎ๐—ฟ๐—ฒ๐—ฒ๐—ฟ ๐—ณ๐—ถ๐—ฒ๐—น๐—ฑ ๐—ถ๐—ป ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ๐Ÿ˜ 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

๐Ÿš€ 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

๐Ÿš€ ๐—™๐—ฅ๐—˜๐—˜ ๐—•๐—ฒ๐—ด๐—ถ๐—ป๐—ป๐—ฒ๐—ฟ ๐—ง๐—ฒ๐—ฐ๐—ต ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐—ง๐—ผ ๐—จ๐—ฝ๐—ด๐—ฟ๐—ฎ๐—ฑ๐—ฒ ๐—ฌ๐—ผ๐˜‚๐—ฟ ๐—–๐—ฎ๐—ฟ๐—ฒ๐—ฒ๐—ฟ ๐Ÿ”ฅ Still confused where to sta
๐Ÿš€ ๐—™๐—ฅ๐—˜๐—˜ ๐—•๐—ฒ๐—ด๐—ถ๐—ป๐—ป๐—ฒ๐—ฟ ๐—ง๐—ฒ๐—ฐ๐—ต ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐—ง๐—ผ ๐—จ๐—ฝ๐—ด๐—ฟ๐—ฎ๐—ฑ๐—ฒ ๐—ฌ๐—ผ๐˜‚๐—ฟ ๐—–๐—ฎ๐—ฟ๐—ฒ๐—ฒ๐—ฟ ๐Ÿ”ฅ 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

Power BI Interview Questions Asked Bajaj Auto Ltd 1. Self Introduction 2. What are your roles and responsibilities of your project? 3. Difference between Import Mode and Direct Mode? 4. What kind of projects have you worked on Domain? 5. How do you handle complex data transformations in Power Query? Can you provide an example of a challenging transformation you implemented? 6. What challenges you faced while doing a projects? 7. Types of Refreshes in Power BI? 8. What is DAX in Power BI? 9. How do you perform data cleansing and transformation in Power BI? 10. How do you connect to data sources in Power BI? 11. What are the components in Power BI? 12. What is Power Pivot will do in Power BI? 13. Write a query to fetch top 5 employees having highest salary? 14. Write a query to find 2nd highest salary from employee table? 15. Difference between Rank function & Dense Rank function in SQL? 16. Difference between Power BI Desktop & Power BI Service? 17. How will you optimize Power BI reports? 18. What are the difficulties you have faced when doing a projects? 19. How can you optimize a SQL query? 20. What is Indexes? 21. How ETL process happen in Power BI? 22. What is difference between Star schema & Snowflake schema and how will know when to use which schemas respectively? 23. How will you perform filtering & it's types? 24. What is Bookmarks? 25. Difference between Drilldown and Drill through in Power BI? 26. Difference between Calculated column and measure? 27. Difference between Slicer and Filter? 28. What is a use Pandas, Matplotlib, seaborn Libraries? 29. Difference between Sum and SumX? 30. Do you have any questions?