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

𝚂𝚄𝙼():

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

𝙴𝚡𝚊𝚖𝚙𝚕𝚎: =𝚂𝚄𝙼(𝐴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

✅ 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!

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

Excel Shortcut Keys 👆

𝗧𝗵𝗶𝘀 𝗜𝗜𝗧 𝗣𝗿𝗼𝗴𝗿𝗮𝗺 𝗖𝗮𝗻 𝗖𝗵𝗮𝗻𝗴𝗲 𝗬𝗼𝘂𝗿 2026!🎓

Spend your summer inside 𝗜𝗜𝗧 𝗠𝗮𝗻𝗱𝗶 🌄
Not just learning… but actually living the IIT life!

💡 2-Month Residential Program
💻 AI, Data Science, Software Dev & more
🏫 Learn from IIT Faculty + Industry Experts
🛠 Build Real-World Projects
📜 Get IIT Certification

This is NOT an online course.
You stay on campus, learn hands-on & level up your career 🚀

🔥 Perfect for Students, Freshers & Aspiring Tech Professionals

Test Date :- 26th April 

𝗕𝗼𝗼𝗸 𝗬𝗼𝘂𝗿 𝗧𝗲𝘀𝘁 𝗦𝗹𝗼𝘁 𝗡𝗼𝘄 :-👇 :- 
 
https://pdlink.in/41Qze2r

💰 Limited Seats | Applications Open Now

Important Excel, Tableau, Statistics, SQL related Questions with answers

1. What are the common problems that data analysts encounter during analysis?

The common problems steps involved in any analytics project are:

Handling duplicate data
Collecting the meaningful right data at the right time
Handling data purging and storage problems
Making data secure and dealing with compliance issues

2. Explain the Type I and Type II errors in Statistics?

In Hypothesis testing, a Type I error occurs when the null hypothesis is rejected even if it is true. It is also known as a false positive.

A Type II error occurs when the null hypothesis is not rejected, even if it is false. It is also known as a false negative.

3. How do you make a dropdown list in MS Excel?

First, click on the Data tab that is present in the ribbon.
Under the Data Tools group, select Data Validation.
Then navigate to Settings > Allow > List.
Select the source you want to provide as a list array.

4. How do you subset or filter data in SQL?

To subset or filter data in SQL, we use WHERE and HAVING clauses which give us an option of including only the data matching certain conditions.

5. What is a Gantt Chart in Tableau?

A Gantt chart in Tableau depicts the progress of value over the period, i.e., it shows the duration of events. It consists of bars along with the time axis. The Gantt chart is mostly used as a project management tool where each bar is a measure of a task in the project