Learn Ai in 2026 —Absolutely FREE!🚀

💸 Cost: ~₹10,000~ ₹0 (FREE!)

What you’ll learn:
✅ 25+ Powerful AI Tools 
✅ Crack Interviews with Ai 
✅ Build Websites in seconds 
✅ Make Videos  PPT 

Enroll Now (free): https://tinyurl.com/Free-Ai-Course-a

⚠️ Register  Get Ai Certificate for resume

𝚃𝚘𝚙 𝙴𝚡𝚌𝚎𝚕 𝙵𝚘𝚛𝚖𝚞𝚕𝚊𝚜 𝙴𝚟𝚎𝚛𝚢 𝙳𝚊𝚝𝚊 𝙰𝚗𝚊𝚕𝚢𝚜𝚝 𝚂𝚑𝚘𝚞𝚕𝚍 𝙺𝚗𝚘𝚠

𝚂𝚄𝙼():

𝙿𝚞𝚛𝚙𝚘𝚜𝚎: 𝙰𝚍𝚍𝚜 𝚞𝚙 𝚊 𝚛𝚊𝚗𝚐𝚎 𝚘𝚏 𝚗𝚞𝚖𝚋𝚎𝚛𝚜.

𝙴𝚡𝚊𝚖𝚙𝚕𝚎: =𝚂𝚄𝙼(𝐴1:𝐴10)


𝙰𝚅𝙴𝚁𝙰𝙶𝙴():

𝙿𝚞𝚛𝚙𝚘𝚜𝚎: 𝙲𝚊𝚕𝚌𝚞𝚕𝚊𝚝𝚎𝚜 𝚝𝚑𝚎 𝚊𝚌𝐯𝐞𝐫𝐢𝐧𝐠 𝗼𝗳 𝗮 𝗿𝗮𝗻𝗴𝗲 𝗼𝗳 𝗻𝗨𝗺𝗯𝗲𝗿𝗦.

💡 Example: =𝐴𝐵𝐸𝐑𝐴𝐺𝐸(𝐵1:𝐵10)


𝙲𝙾𝙐𝙽𝚃():

💡 Purpose: Counts the number of cells containing numbers.

💡 Example: =𝐶𝐷𝐵(𝐶1:𝐶10)


𝐼𝐹():

💡 Purpose: Returns one value if a condition is true, and another if false.

💡 Example: =𝐼𝐹(𝐴1 > 10, "Yes", "No")


𝐕𝐋𝐎𝐎𝐊𝐔𝐏():

💡 Purpose: Searches for a value in the first column and returns a value in the same row from another column.

💡 Example: =𝐕𝐋𝐎𝐎𝐊𝐔𝐏(𝐷1, 𝐴1:𝐵10, 2, FALSE)


𝐇𝐋𝐎𝐎𝐊𝐔𝐏():

💡 Purpose: Searches for a value in the first row and returns a value in the same column from another row.

💡 Example: =𝐇𝐋𝐎𝐎𝐊𝐔𝐏("Sales", A1:F5, 3, FALSE)


𝐼𝐍𝐃𝐄𝐗():

💡 Purpose: Returns the value of a cell based on row and column numbers.

💡 Example: =𝐼𝐍𝐃𝐄𝐗(𝐴1:𝐶10, 2, 3)


𝐌𝐀𝐓𝐂𝐇():

💡 Purpose: Searches for a value and returns its position in a range.

💡 Example: =𝐌𝐀𝐓𝐂𝐇("Product B", A1:A10, 0)


𝐂𝐎𝐍𝐂𝐀𝐓𝐄𝐍𝐀𝐓𝐄() or 𝐂𝐎𝐍𝐂𝐀𝐓():

💡 Purpose: Joins multiple text strings into one.

💡 Example: =𝐂𝐎𝐍𝐂𝐀𝐓𝐄𝐍𝐀𝐓𝐄(𝐴1, " ", 𝐵1)


𝗧𝗘𝗫𝗧():

💡 Purpose: Formats numbers or dates as text.

💡 Example: =𝗧𝗘𝗫𝗧(𝗔1, "dd/mm/yyyy")

React ❤️ for more

𝗧𝗼𝗽 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗟𝗮𝗻𝗱 𝗮 𝗛𝗶𝗴𝗵-𝗣𝗮𝘆𝗶𝗻𝗴 𝗝𝗼𝗯 𝗶𝗻 𝟮𝟬𝟮𝟲🔥

Learn from scratch → Build real projects → Get placed

✅ 2000+ Students Already Placed
🤝 500+ Hiring Partners
💼 Avg Salary: ₹7.4 LPA
🚀 Highest Package: ₹41 LPA

Fullstack :- https://pdlink.in/4hO7rWY

Data Analytics :- https://pdlink.in/4fdWxJB

📈 Don’t just scroll… Start today & secure your 2026 job NOW

✅ 8-Week Beginner Roadmap to Master Excel 📊

🗓️ Week 1: Excel Basics
Goal: Get comfortable with the interface and basic operations
Topics: Workbook, worksheets, cells, data entry, basic formulas
Mini Project: Create a personal budget sheet

🗓️ Week 2: Formulas & Functions
Goal: Learn essential calculations
Topics: SUM, AVERAGE, COUNT, MIN, MAX
Mini Project: Calculate expenses and incomes with formulas

🗓️ Week 3: Data Formatting & Cleaning
Goal: Make data readable and clean
Topics: Cell formatting, conditional formatting, removing duplicates, data validation
Mini Project: Format and clean a messy dataset

🗓️ Week 4: Logical Functions & Text Functions
Goal: Use logic and manipulate text
Topics: IF, AND, OR, CONCATENATE, LEFT, RIGHT, LEN
Mini Project: Categorize data and extract information from text

🗓️ Week 5: Data Analysis with PivotTables
Goal: Summarize and analyze data quickly
Topics: Creating PivotTables, slicers, filters
Mini Project: Analyze sales data with PivotTables

🗓️ Week 6: Charts & Visualization
Goal: Create impactful visuals
Topics: Bar, line, pie charts, sparklines
Mini Project: Visualize sales or survey data

🗓️ Week 7: Advanced Functions & Lookup
Goal: Work with complex data retrieval
Topics: VLOOKUP, HLOOKUP, INDEX & MATCH
Mini Project: Combine data from multiple tables

🗓️ Week 8: Automation & Reporting
Goal: Automate tasks and prepare reports
Topics: Macros basics, creating dashboards, printing setups
Mini Project: Build an interactive dashboard reporting key metrics

💡 Tips:
- Practice regularly with real datasets
- Explore Excel templates and online tutorials
- Join Excel forums and challenges

💬 Double Tap ♥️ For More

𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀, 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝘄𝗶𝘁𝗵 𝗔𝗜 𝗮𝗿𝗲 𝗵𝗶𝗴𝗵𝗹𝘆 𝗱𝗲𝗺𝗮𝗻𝗱𝗶𝗻𝗴 𝗶𝗻 𝟮𝟬𝟮𝟲😍

Learn Data Science and AI Taught by Top Tech professionals

60+ Hiring Drives Every Month

𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝗲𝘀:- 
- 12.65 Lakhs Highest Salary
- 500+ Partner Companies
- 100% Job Assistance
- 5.7 LPA Average Salary

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄👇:-

 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.

Ctrl Key Shortcuts in Excel

Useful WhatsApp channels based on your interests 👇👇

Free Courses with Certificate: https://whatsapp.com/channel/0029Vamhzk5JENy1Zg9KmO2g

Data Analysts: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02

MS Excel: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i

Jobs & Internship Opportunities:
https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

Web Development: https://whatsapp.com/channel/0029VaiSdWu4NVis9yNEE72z

Python Free Books & Projects: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L

Java Resources: https://whatsapp.com/channel/0029VamdH5mHAdNMHMSBwg1s

Coding Interviews: https://whatsapp.com/channel/0029VammZijATRSlLxywEC3X

SQL: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v

Power BI: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c

Programming Free Resources: https://whatsapp.com/channel/0029VahiFZQ4o7qN54LTzB17

Data Science Projects: https://whatsapp.com/channel/0029Va4QUHa6rsQjhITHK82y

Learn Data Science & Machine Learning: https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D

Improve your communication skills: https://whatsapp.com/channel/0029VaiaucV4NVik7Fx6HN2n

Don’t worry Guys your contact number will stay hidden!

ENJOY LEARNING 👍👍

𝗔𝗜/𝗠𝗟 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺 𝗕𝘆  𝗩𝗶𝘀𝗵𝗹𝗲𝘀𝗮𝗻 𝗶-𝗛𝘂𝗯, 𝗜𝗜𝗧 𝗣𝗮𝘁𝗻𝗮 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻😍

Freshers are getting paid 10 - 15 Lakhs by learning AI & ML skill

Upgrade your career with a beginner-friendly AI/ML certification.

👉Open for all. No Coding Background Required
💻 Learn AI/ML from Scratch
🎓 Build real world Projects for job ready portfolio 

🔥Deadline :- 19th April

    𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇 :- 

https://pdlink.in/41ZttiU
.
Get Placement Assistance With 5000+ Companies

✅ Most Asked Excel Interview Questions for Data Analysts 📊🔥

🔍 Q1. What is the difference between VLOOKUP and XLOOKUP?
Answer: VLOOKUP → works only left to right, needs column index
XLOOKUP → works in any direction, more flexible, handles errors better

🔍 Q2. Write a formula to find a value using INDEX and MATCH.
Answer: =INDEX(B2:B10, MATCH(E1, A2:A10, 0))
Returns value from column B where A matches E1

🔍 Q3. What is a Pivot Table and when do you use it?
Answer: Used to summarize large datasets (sum, count, average) and analyze patterns quickly without formulas.

🔍 Q4. How do you handle duplicates in Excel?
Answer: Data → Remove Duplicates, Conditional Formatting → Highlight duplicates, or use formula: =COUNTIF(A:A, A2) > 1

🔍 Q5. What is the difference between COUNT, COUNTA, and COUNTIFS?
Answer: COUNT → counts numeric values, COUNTA → counts non-empty cells, COUNTIFS → counts based on multiple conditions

🔍 Q6. How do you create a dynamic dashboard in Excel?
Answer: Use Pivot Tables + Pivot Charts, add slicers for filters, use named ranges or tables, keep layout clean and interactive

🔍 Q7. What is conditional formatting? Give a use case.
Answer: Used to highlight data based on conditions
Example: Highlight sales > target in green

🔍 Q8. How do you handle missing values in Excel?
Answer: Filter blanks, replace using mean/median, use IF or IFERROR, remove rows if needed

🔍 Q9. What is the difference between absolute and relative cell references?
Answer: Relative → changes when dragged (A1), Absolute → fixed ($A$1)

🔍 Q10. How do you find top 5 sales values?
Answer: =LARGE(A2:A100, 1) Change 1 → 5 for top 5, or use Pivot Table + Top N filter

🔍 Q11. What is IFERROR and why is it used?
Answer: Handles errors in formulas, Example: =IFERROR(A1/B1, "Error")

🔍 Q12. What is data validation?
Answer: Restricts user input (dropdowns, limits) to maintain data quality

Double Tap ❤️ For More

𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗪𝗶𝘁𝗵 𝗚𝗲𝗻𝗔𝗜😍

Curriculum designed and taught by alumni from IITs & leading tech companies, with practical GenAI applications.

* 2000+ Students Placed
* 41LPA Highest Salary
* 500+ Partner Companies
- 7.4 LPA Avg Salary

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄👇:-

🔹 Online :- https://pdlink.in/4hO7rWY

🔹 Hyderabad :- https://pdlink.in/4cJUWtx

🔹 Pune :-  https://pdlink.in/3YA32zi

🔹 Noida :-  https://linkpd.in/NoidaFSD

Hurry Up 🏃‍♂️! Limited seats are available.

📊 Learn Microsoft Excel in 14 Days:

🟢 Day 1 – Excel Interface & Basics
Understand Excel layout, ribbons, cells, rows, columns, and basic navigation.

📝 Day 2 – Data Entry & Formatting
Learn to enter/edit data, use formatting tools (bold, color, borders, alignment).

➕ Day 3 – Basic Formulas
Use SUM(), AVERAGE(), MIN(), MAX(), and simple arithmetic formulas.

🔍 Day 4 – Cell Referencing
Understand relative, absolute, and mixed references using $.

📋 Day 5 – Sorting & Filtering
Sort data (A-Z, Z-A) and apply filters to analyze specific data quickly.

📐 Day 6 – Conditional Formatting
Highlight data using rules (greater than, color scales, data bars).

📊 Day 7 – Charts & Graphs
Create and customize pie, bar, line charts for data visualization.

🔁 Day 8 – Logical Functions
Learn IF(), AND(), OR(), IFERROR() for decision-making in formulas.

📈 Day 9 – Lookup Functions
Use VLOOKUP(), HLOOKUP(), and XLOOKUP() to fetch data from tables.

🧩 Day 10 – Text Functions
Learn CONCAT(), TEXT(), LEFT(), RIGHT(), LEN(), TRIM().

📆 Day 11 – Date & Time Functions
Work with TODAY(), NOW(), DATEDIF(), TEXT() for date/time formatting.

🔐 Day 12 – Data Validation
Restrict data input using drop-downs, number/text rules, and error messages.

📎 Day 13 – Pivot Tables
Summarize large datasets using Pivot Tables for quick insights.

🚀 Day 14 – Final Dashboard Project
Build a simple Excel dashboard using charts, pivot tables & conditional formatting.

❤️ React for more!

𝗜𝗜𝗧 & 𝗜𝗜𝗠 𝗢𝗳𝗳𝗲𝗿𝗶𝗻𝗴 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝘀😍

👉Open for all. No Coding Background Required

AI/ML By IIT Patna  :- https://pdlink.in/41ZttiU

Business Analytics With AI :- https://pdlink.in/41h8gRt

Digital Marketing With AI :-https://pdlink.in/47BxVYG

AI/ML By IIT Mandi :- https://pdlink.in/4cvXBaz

🔥Get Placement Assistance With 5000+ Companies🎓

🔹 DATA ANALYST – INTERVIEW REVISION SHEET

1️⃣ Role Clarity
> “A data analyst collects, cleans, analyzes data, and converts it into insights that help businesses make decisions.”

2️⃣ SQL (Most Important)
Must-know clauses:
• SELECT, WHERE, ORDER BY, LIMIT
• GROUP BY, HAVING
• JOINS (INNER, LEFT)
• Subqueries, CTEs
• Window functions (ROW_NUMBER, RANK)
Golden rules:
• WHERE → before aggregation
• HAVING → after aggregation
• LEFT JOIN → keeps all left table rows
• NULLs break calculations → use COALESCE
Classic questions:
• Top N per group
• Find duplicates
• Running totals

3️⃣ Excel Essentials
Formulas:
• IF, XLOOKUP
• COUNTIFS, SUMIFS
• TRIM, LEFT, RIGHT
Core features:
• Pivot tables
• Conditional formatting
• Data validation (dropdowns)
Avoid:
• Merged cells
• Hard-coded values

4️⃣ Power BI / Tableau
Concepts:
• Data model (star schema)
• Relationships (one-to-many)
• Measures > calculated columns
Must-know DAX:
• Total Sales = SUM(Sales[Amount])
• YTD Sales = TOTALYTD(SUM(Sales[Amount]), Sales[Date])
Design rules:
• KPIs on top
• One story per dashboard
• Minimal visuals

5️⃣ Statistics (Only What Matters)
• Mean vs Median
• Standard deviation
• Correlation ≠ causation
• Outliers distort averages
• Use median for Salaries, House prices

6️⃣ Data Cleaning (Interview Gold)
Steps you should say:
1. Remove duplicates
2. Handle missing values
3. Fix data types
4. Standardize text

7️⃣ Business Metrics
• Revenue
• Growth rate
• Conversion rate
• Churn
• Retention
• Average order value
Always connect metrics to business impact.

8️⃣ Case Question Framework (Very Important)
Always answer like this:
1. What happened
2. Why it happened
3. What should be done
Example:
> “Sales dropped due to lower traffic in one region, so I’d recommend increasing marketing spend there.”

9️⃣ Project Explanation Template
> “The goal was . I used to clean data, to analyze, and to visualize. The key insight was . The business impact was .”
Memorize this.

🔟 HR Power Answers
Why data analyst?
> “I enjoy finding patterns in data and turning them into actionable insights.”
Strength:
“I combine technical skills with business understanding.”
Weakness:
“I used to over-analyze, but now I focus on impact.”

🧠 Last-Day Interview Tips
• Think out loud
• Ask clarifying questions
• Don’t jump to tools immediately
• Focus on impact, not syntax

💬 Tap ❤️ for more!

Every day you login... Work.. and logout.

Days become months.
Months become years.

But nothing changes.

Same role. Same work. Same pay.

Meanwhile, others are moving into Cloud & Data Engineering…
building real systems and earning better.

If you are looking to get into Azure Data Engineering then..

𝗝𝗼𝗶𝗻 𝘁𝗵𝗲 3 months 𝗟𝗶𝘃𝗲 𝗣𝗿𝗼𝗴𝗿𝗮𝗺

📌 Start Date: 20th April 2026

⏰ Time: 9 PM – 10 PM IST | Monday

👉 𝐌𝐞𝐬𝐬𝐚𝐠𝐞 𝐮𝐬 𝐨𝐧 𝐖𝐡𝐚𝐭𝐬𝐀𝐩𝐩:

https://wa.me/917032678595?text=Interested_to_join_Azure_Data_Engineering_live_sessions

🔹 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗵𝗲𝗿𝗲:

https://forms.gle/DRXEhvyG9ENDsNYR9

🎟️ 𝗝𝗼𝗶𝗻 𝗪𝗵𝗮𝘁𝘀𝗔𝗽𝗽 𝗚𝗿𝗼𝘂𝗽:

https://chat.whatsapp.com/GCG3Si7vhrJD1evV9NAbhL

🏀 𝗖𝗼𝘂𝗿𝘀𝗲 𝗖𝗼𝗻𝘁𝗲𝗻𝘁:

https://drive.google.com/file/d/1QKqhRMHx2SDNDTmPAf3_54fA6LljKHm6/view

Excel Border Formatting Shortcuts 👆

𝐏𝐚𝐲 𝐀𝐟𝐭𝐞𝐫 𝐏𝐥𝐚𝐜𝐞𝐦𝐞𝐧𝐭 - 𝐆𝐞𝐭 𝐏𝐥𝐚𝐜𝐞𝐝 𝐈𝐧 𝐓𝐨𝐩 𝐌𝐍𝐂'𝐬 😍

Learn Coding From Scratch - Lectures Taught By IIT Alumni

60+ Hiring Drives Every Month

𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬:- 

🌟 Trusted by 7500+ Students
🤝 500+ Hiring Partners
💼 Avg. Rs. 7.4 LPA
🚀 41 LPA Highest Package

Eligibility: BTech / BCA / BSc / MCA / MSc

𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰👇 :- 

https://pdlink.in/4hO7rWY

Hurry, limited seats available!🏃‍♀️

✅ Data Analyst Resume Tips 🧾📊

Your resume should showcase skills + results + tools. Here’s what to focus on:

1️⃣ Clear Career Summary 
• 2–3 lines about who you are 
• Mention tools (Excel, SQL, Power BI, Python) 
• Example: “Data analyst with 2 years’ experience in Excel, SQL, and Power BI. Specializes in sales insights and automation.”

2️⃣ Skills Section 
• Technical: SQL, Excel, Power BI, Python, Tableau 
• Data: Cleaning, visualization, dashboards, insights 
• Soft: Problem-solving, communication, attention to detail

3️⃣ Projects or Experience 
• Real or personal projects 
• Use the STAR format: Situation → Task → Action → Result 
• Show impact: “Created dashboard that reduced reporting time by 40%.”

4️⃣ Tools and Certifications 
• Mention Udemy/Google/Coursera certificates  (optional)
• Highlight tools used in each project

5️⃣ Education 
• Degree (if relevant) 
• Online courses with completion date

🧠 Tips: 
• Keep it 1 page if you’re a fresher 
• Use action verbs: Analyzed, Automated, Built, Designed 
• Use numbers to show results: +%, time saved, etc.

📌 Practice Task: 
Write one resume bullet like: 
“Analyzed customer data using SQL and Power BI to find trends that increased sales by 12%.”

Double Tap ♥️ For More

𝗔𝗿𝘁𝗶𝗳𝗶𝗰𝗶𝗮𝗹 𝗜𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲 𝗮𝗻𝗱 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗣𝗿𝗼𝗴𝗿𝗮𝗺 𝗯𝘆 𝗖𝗖𝗘, 𝗜𝗜𝗧 𝗠𝗮𝗻𝗱𝗶😍

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.

🔥Deadline :- 26th April

  𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇 :- 

https://pdlink.in/3QSxhjC
.
Get Placement Assistance With 5000+ Companies