𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 - 𝗚𝗲𝘁 𝗦𝗮𝗹𝗮𝗿𝘆 𝗣𝗮𝗰𝗸𝗮𝗴𝗲 𝗨𝗽𝘁𝗼 𝟰𝟭𝗟𝗣𝗔 😍

Upskill on the most in-demand skills in the market

Learn Coding & Get Placed In Top Tech Companies

𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:-

💼 Avg. Package: ₹7.2 LPA | Highest: ₹41 LPA

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

 https://pdlink.in/42WOE5H

Hurry! Limited seats are available.🏃‍♂️

Excel Basics for Data Analytics

Excel sits at the start of most analysis work.

What you use Excel for
• Cleaning raw data
• Exploring patterns
• Quick summaries for teams

Core concepts you must know
• Data setup
– Freeze header row. View → Freeze Top Row.
– Convert range to table. Ctrl + T.
– Use proper headers. No merged cells. One value per cell.

• Data cleaning
– Remove duplicates. Data → Remove Duplicates.
– Trim extra spaces. =TRIM(A2)
– Convert text to numbers. =VALUE(A2)
– Fix date format. Format Cells → Date.
– Handle blanks. Filter blanks, fill or delete.
– Find and replace. Ctrl + H.

• Essential formulas
– Math and counts
▪ SUM. =SUM(A2:A100)
▪ AVERAGE. =AVERAGE(A2:A100)
▪ MIN. =MIN(A2:A100)
▪ MAX. =MAX(A2:A100)
▪ COUNT. Counts numbers.
▪ COUNTA. Counts non blanks.
▪ COUNTBLANK. Counts blanks.
– Conditional formulas
▪ IF. =IF(A2>5000,"High","Low")
▪ IFS. Multiple conditions.
▪ AND. =AND(A2>5000,B2="West")
▪ OR. =OR(A2>5000,A2<1000)
– Lookup formulas
▪ XLOOKUP. =XLOOKUP(A2,Sheet2!A:A,Sheet2!B:B)
▪ VLOOKUP. Old but common.
▪ INDEX + MATCH. Powerful alternative.
– Text formulas
▪ LEFT. =LEFT(A2,4)
▪ RIGHT. =RIGHT(A2,2)
▪ MID. =MID(A2,2,3)
▪ LEN. =LEN(A2)
▪ CONCAT or TEXTJOIN.
▪ LOWER, UPPER, PROPER.
– Date formulas
▪ TODAY. Current date.
▪ NOW. Date and time.
▪ YEAR, MONTH, DAY.
▪ DATEDIF. Date difference.
▪ EOMONTH. Month end.

• Sorting and filtering
– Sort by multiple columns.
– Filter by value, color, condition.
– Top 10 filter for quick insights.

• Conditional formatting
– Highlight duplicates.
– Color scales for trends.
– Rules for thresholds. Example. Sales > 10000 in green.

• Pivot tables
– Insert → PivotTable.
– Rows. Category or Product.
– Values. Sum, Count, Average.
– Filters. Date, Region.
– Refresh after data update.

• Charts you must know
– Column. Comparison.
– Bar. Ranking.
– Line. Trends over time.
– Pie. Share or percentage.
– Combo. Actual vs target.

• Data validation
– Dropdown list. Data → Data Validation → List.
– Prevent wrong entries.

• Useful shortcuts
– Ctrl + Arrow. Jump data.
– Ctrl + Shift + Arrow. Select range.
– Ctrl + 1. Format cells.
– Ctrl + L. Apply filter.
– Alt + =. Auto sum.
– Ctrl + Z / Y. Undo redo.

• Common analyst mistakes to avoid
– Merged cells.
– Hard coded totals.
– Mixed data types in one column.
– No backup before cleaning.

• Daily practice task
– Download any sales CSV.
– Clean it.
– Build one pivot table.
– Create one chart.

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

Data Analytics Roadmap: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02/1354

Double Tap ♥️ For More

📊 𝗧𝗼𝗽 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗟𝗲𝗮𝗿𝗻 𝗗𝗮𝘁𝗮 𝗶𝗻 𝟮𝟬𝟮𝟲 🚀

Want to become a Data Analyst or Data Scientist? 👀
These FREE certifications can help you build job-ready skills & strengthen your resume 🔥

✨ Learn:
✔ SQL & Data Analytics
✔ Power BI Dashboards 📊
✔ Data Cleaning & Visualization
✔ AI & Machine Learning Basics 🤖

💯 FREE + Beginner Friendly

𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:-

https://pdlink.in/4dsdTCV

🎓 Perfect for Students, Freshers & Career Switchers

9 tips to get started with Data Analysis:

Learn Excel, SQL, and a programming language (Python or R)

Understand basic statistics and probability

Practice with real-world datasets (Kaggle, Data.gov)

Clean and preprocess data effectively

Visualize data using charts and graphs

Ask the right questions before diving into data

Use libraries like Pandas, NumPy, and Matplotlib

Focus on storytelling with data insights

Build small projects to apply what you learn

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

ENJOY LEARNING 👍👍

Want to start your career in 𝗔𝗜 & 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲😍?

Learn from IIIT Bangalore & upGrad

💫 Beginner Friendly
💫 Industry Recognized Certificate
💫High Demand Career Skills

𝗕𝗼𝗼𝗸 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗻𝘀𝗲𝗹𝗹𝗶𝗻𝗴👇Now & explore your career roadmap

https://pdlink.in/4twH9xg

🎓Top roles you can target:
* Data Analyst , AI Engineer ,Machine Learning Engineer & Data Scientist

WhatsApp is no longer a platform just for chat.

It's an educational goldmine.

If you do, you’re sleeping on a goldmine of knowledge and community. WhatsApp channels are a great way to practice data science, make your own community, and find accountability partners.

I have curated the list of best WhatsApp channels to learn coding & data science for FREE

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

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 Free Resources
👇👇
https://whatsapp.com/channel/0029VamdH5mHAdNMHMSBwg1s

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

SQL For Data Analysis
👇👇
https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v

Power BI Resources
👇👇
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

Coding Projects
👇👇
https://whatsapp.com/channel/0029VamhFMt7j6fx4bYsX908

Excel for Data Analyst
👇👇
https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i

ENJOY LEARNING 👍👍

🗄️ 𝗧𝗼𝗽 𝟱 𝗙𝗥𝗘𝗘 𝗦𝗤𝗟 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 🚀

SQL is one of the most important skills for Data Analyst & Tech jobs in 2026 🔥
These FREE certification courses can help you learn SQL from scratch & boost your resume 💼

✨ Learn:
✔ SQL Queries & Databases 🗄️
✔ Data Analysis Basics 📊
✔ Real-world Projects
✔ Beginner to Advanced Concepts

𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 
 
https://pdlink.in/4dCHiKI
 
💯 Beginner Friendly + FREE Certificates 🎓
💼 Perfect for Students, Freshers & Career Switchers

✅ Data Analyst Interview Questions for Freshers 📊

1) What is the role of a data analyst?
Answer: A data analyst collects, processes, and performs statistical analyses on data to provide actionable insights that support business decision-making.

2) What are the key skills required for a data analyst?
Answer: Strong skills in SQL, Excel, data visualization tools (like Tableau or Power BI), statistical analysis, and problem-solving abilities are essential.

3) What is data cleaning?
Answer: Data cleaning involves identifying and correcting inaccuracies, inconsistencies, or missing values in datasets to improve data quality.

4) What is the difference between structured and unstructured data?
Answer: Structured data is organized in rows and columns (e.g., spreadsheets), while unstructured data includes formats like text, images, and videos that lack a predefined structure.

5) What is a KPI?
Answer: KPI stands for Key Performance Indicator, which is a measurable value that demonstrates how effectively a company is achieving its business goals.

6) What tools do you use for data analysis?
Answer: Common tools include Excel, SQL, Python (with libraries like Pandas), R, Tableau, and Power BI.

7) Why is data visualization important?
Answer: Data visualization helps translate complex data into understandable charts and graphs, making it easier for stakeholders to grasp insights and trends.

8) What is a pivot table?
Answer: A pivot table is a feature in Excel that allows you to summarize, analyze, and explore data by reorganizing and grouping it dynamically.

9) What is correlation?
Answer: Correlation measures the statistical relationship between two variables, indicating whether they move together and how strongly.

10) What is a data warehouse?
Answer: A data warehouse is a centralized repository that consolidates data from multiple sources, optimized for querying and analysis.

11) Explain the difference between INNER JOIN and OUTER JOIN in SQL.
Answer: INNER JOIN returns only the matching rows between two tables, while OUTER JOIN returns all matching rows plus unmatched rows from one or both tables, depending on whether it’s LEFT, RIGHT, or FULL OUTER JOIN.

12) What is hypothesis testing?
Answer: Hypothesis testing is a statistical method used to determine if there is enough evidence in a sample to infer that a certain condition holds true for the entire population.

13) What is the difference between mean, median, and mode?
Answer:
⦁ Mean: The average of all numbers.
⦁ Median: The middle value when data is sorted.
⦁ Mode: The most frequently occurring value in a dataset.

14) What is data normalization?
Answer: Normalization is the process of organizing data to reduce redundancy and improve integrity, often by dividing data into related tables.

15) How do you handle missing data?
Answer: Missing data can be handled by removing rows, imputing values (mean, median, mode), or using algorithms that support missing data.

💬 React ❤️ for more!

𝗔𝗜 𝗮𝗻𝗱 𝗠𝗟 𝗣𝗿𝗼𝗴𝗿𝗮𝗺 𝗯𝘆 𝗖𝗖𝗘, 𝗜𝗜𝗧 𝗠𝗮𝗻𝗱𝗶😍

Freshers get 15 LPA Average Salary with AI & ML Skills!

💻 100% Online
⏳ 6 Months Duration
👨‍🏫 Learn from IIT Professors
📌 Open for Students ,Freshers & Working Professionals

💼 Placement Assistance with 5000+ Companies
📈 High Demand Skills for Future Tech Jobs

Top companies are hiring for candidates with 𝗔𝗜, 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 skills in 2026

🔥Deadline :- 17th May

  𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇 :- 

https://pdlink.in/4nmI024
.
Get Placement Assistance With 5000+ Companies

🚀 Excel Interview Questions with Answers — Part 1

1. What is Microsoft Excel and what is it mainly used for?
Microsoft Excel is a spreadsheet application used to store, organize, analyze, and visualize data. It is part of Microsoft 365.

Main Uses of Excel:
- Data entry and management
- Calculations using formulas and functions
- Data analysis and reporting
- Creating charts and dashboards
- Budgeting and financial analysis
- Automation using macros and VBA

📌 Example:
A data analyst may use Excel to analyze sales data and create monthly KPI dashboards.

2. What is the difference between a workbook and a worksheet?

Workbook | Worksheet
A workbook is the entire Excel file | A worksheet is a single sheet/tab inside the workbook
It can contain multiple worksheets | It contains rows and columns of data
Saved as .xlsx, .xls, etc. | Appears as tabs at the bottom

📌 Example:
Sales_Report.xlsx = Workbook
January Sales = Worksheet inside the workbook

3. What is a cell, row, and column?
Cell: Intersection of a row and column
Example: B5

Row: Horizontal arrangement of data
Rows are numbered: 1, 2, 3...

Column: Vertical arrangement of data
Columns are labeled: A, B, C...

📌 Example:
If “Sales” is written in cell C2, then:
- C = Column
- 2 = Row
- C2 = Cell

4. How do you rename, insert, or delete a worksheet?

Rename a Worksheet:
- Double-click the sheet tab
OR
- Right-click → Rename

Insert a Worksheet:
- Click the + icon beside sheet tabs
OR
- Press Shift + F11

Delete a Worksheet:
- Right-click sheet tab → Delete

⚠️ Important:
Deleting a worksheet permanently removes its data unless recovered immediately.

5. How do you select a range, entire row, or entire column?

Select a Range:
Click and drag across cells
Example: A1:D10

Select Entire Row:
- Click the row number
OR
- Shortcut: Shift + Space

Select Entire Column:
- Click the column letter
OR
- Shortcut: Ctrl + Space

📌 Useful for formatting, filtering, or applying formulas quickly.

6. How do you copy, paste, and cut data?

Action | Shortcut
Copy | Ctrl + C
Paste | Ctrl + V
Cut | Ctrl + X

Paste Special:
Used when you want to paste:
- Values only
- Formulas only
- Formatting only

Shortcut: Ctrl + Alt + V

📌 Example:
Copy formulas without changing formatting using “Paste Special → Formulas”.

7. How do you use Zoom, Freeze Panes, and Split Window?

Zoom:
Used to increase or decrease worksheet view size.
- Bottom-right zoom slider
OR
- View → Zoom

Freeze Panes:
Keeps headers visible while scrolling.
Path: View → Freeze Panes
Common options:
- Freeze Top Row
- Freeze First Column

📌 Example:
Freeze headers in large sales reports.

Split Window:
Splits worksheet into multiple scrollable sections.
Path: View → Split
Useful when comparing distant parts of the same sheet.

8. How do you hide/unhide rows and columns?

Hide:
- Select row/column
- Right-click → Hide

Unhide:
- Select surrounding rows/columns
- Right-click → Unhide

📌 Example:
Hide helper columns containing intermediate calculations.

9. How do you insert/delete rows and columns without breaking formulas?

Best Practice:
Use Excel insert/delete options instead of manual copy-paste.

Insert:
Right-click row/column → Insert

Delete:
Right-click row/column → Delete

Why?
Excel automatically adjusts formulas and references.

📌 Example:
If formula is: =SUM(A1:A5)
After inserting a new row inside the range, Excel updates automatically: =SUM(A1:A6)

⚠️ Avoid deleting cells individually unless necessary because it may shift references incorrectly.

10. How do you save, open, and share an Excel file (including via OneDrive / Microsoft SharePoint)?

Save a File:
- Ctrl + S
- File → Save As

Open a File:
- File → Open
OR
- Double-click the Excel file

Share via OneDrive: 
1. Save file to OneDrive 
2. Click Share 
3. Generate link or invite users 

Share via Microsoft SharePoint: 
- Upload workbook to SharePoint 
- Collaborate with multiple users in real time 

Double Tap ❤️ For Part-2

If I need to teach someone data analytics from the basics, here is my strategy:

1. I will first remove the fear of tools from that person

2. i will start with the excel because it looks familiar and easy to use

3. I put more emphasis on projects like at least 5 to 6 with the excel. because in industry you learn by doing things

4. I will release the person from the tutorial hell and move into a more action oriented person

5. Then I move to the sql because every job wants it , even with the ai tools you need strong understanding for it if you are going to use it daily

6. After strong understanding, I will push the person to solve 100 to 150 Sql problems from basic to advance

7. It helps the person to develop the analytical thinking

8. Then I push the person to solve 3 case studies as it helps how we pull the data in the real life

9. Then I move the person to power bi to do again 5 projects by using either sql or excel files

10. Now the fear is removed.

11. Now I push the person to solve unguided challenges and present them by video recording as it increases the problem solving, communication and data story telling skills

12. Further it helps you to clear case study round given by most of the companies

13. Now i help the person how to present them in resume and also how these tools are used in real world.

14. You know the interesting fact, all of above is present free in youtube and I also mentor the people through existing youtube videos.

15. But people stuck in the tutorial hell, loose motivation , stay confused that they are either in the right direction or not.

16. As a personal mentor , I help them to get of the tutorial hell, set them in the right direction and they stay motivated when they start to see the difference before amd after mentorship

I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://topmate.io/analyst/861634

Hope this helps you 😊

🚀 Excel Interview Questions with Answers — Part 2

11. How do you format numbers as currency, percentage, or date?
Excel provides different number formats to display data properly.

Steps:
1. Select the cells
2. Go to Home → Number Group
3. Choose the required format

Common Formats:
Currency → ₹25,000
Percentage → 85%
Date → 15-May-2026

Shortcuts:
Currency → Ctrl + Shift + $
Percentage → Ctrl + Shift + %
Date → Ctrl + Shift + #

📌 Example:
0.25 displayed as Percentage becomes 25%.

12. How do you wrap text and merge cells?

Wrap Text:
Used when text is too long for a cell.

Path: Home → Wrap Text

📌 It displays content in multiple lines inside the same cell.

Merge Cells:
Combines multiple cells into one larger cell.
Path: Home → Merge & Center

Common Merge Options:
- Merge & Center
- Merge Across
- Merge Cells

⚠️ Avoid excessive merging in data tables because it can create problems while sorting/filtering.

13. How do you resize columns and rows to fit content?

Manual Resize:
- Drag the column boundary
- Drag the row boundary

Auto Resize:
Double-click the boundary between columns or rows.

📌 Example:
If employee names are cut off, AutoFit adjusts width automatically.

14. How do you apply bold, italic, borders, and background colors?
These options improve readability and presentation.

Formatting Shortcuts:
Bold → Ctrl + B
Italic → Ctrl + I
Underline → Ctrl + U

Borders:
Home → Borders

Background Color:
Home → Fill Color

📌 Example:
Highlight KPI values using bold text and colored backgrounds.

15. How do you AutoFit column width and row height?

AutoFit Column Width:
1. Select columns
2. Go to: Home → Format → AutoFit Column Width

OR
Double-click the column edge.

AutoFit Row Height:
Home → Format → AutoFit Row Height

📌 Useful for reports containing long text or wrapped content.

16. How do you print and set page layout (margins, gridlines, headers/footers)?

Print:
Shortcut: Ctrl + P

Page Layout Settings:
Path: Page Layout
You can configure:
- Margins
- Orientation (Portrait/Landscape)
- Size
- Print Area

Gridlines:
Page Layout → Gridlines → Print

Headers & Footers:
Insert → Header & Footer

📌 Example:
Add page numbers and company name in reports.

17. How do you protect a sheet or workbook with a password?

Protect Worksheet:
1. Go to: Review → Protect Sheet
2. Enter password
3. Choose allowed actions

Protect Workbook:
Review → Protect Workbook

📌 Protection prevents:
- Editing formulas
- Deleting sheets
- Structural changes

⚠️ Always keep backup passwords securely stored.

18. How do you use “Format as Table” and why is it useful?

Steps:
1. Select data
2. Go to: Home → Format as Table

Benefits:
- Automatic filters
- Better formatting
- Dynamic ranges
- Structured references
- Easier PivotTables & charts

📌 Example:
Instead of:
=SUM(A2:A100)

You can use:
=SUM(Sales[Revenue])

This is easier to read and maintain.

19. How do you use conditional formatting (highlight cells, data bars, color scales, icons)?
Conditional formatting changes cell appearance based on conditions.

Path:
Home → Conditional Formatting

Common Options:
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets

📌 Example:
- Highlight sales below target in red
- Use green/yellow/red color scales for performance metrics

Formula-Based Formatting Example:
=A1>100
Highlights cells greater than 100.

20. How do you apply custom number formats?
Custom formats control how data appears without changing actual values.

Path:
Format Cells → Number → Custom

Examples:
× 0 × → 25
0.00 → 25.00
₹#,##0 → ₹12,500
0% → 75%

Display Thousands as K:
0,"K"
Result: 25000 → 25K

📌 Useful in dashboards and executive reports for cleaner visuals.

Double Tap ❤️ For Part-3

🚀 Excel Interview Questions with Answers — Part 3

21. How do you write a basic arithmetic formula starting with =?

In Excel, every formula starts with the = sign.

Basic Arithmetic Operators:
Operator - Meaning
+ - Addition
• - Subtraction
** - Multiplication
/ - Division
^ - Power

Examples:
=A1+B1
=A1-B1
=A1*B1
=A1/B1

📌 Example:
If A1 = 10 and B1 = 5

Then:
=A1+B1
returns 15.

22. What are relative, absolute, and mixed references (A1, A1, A$1)?

Cell references control how formulas behave when copied.

Type - Example - Behavior

Relative - A1 - Changes row and column
Absolute - A1 - Fixed row and column
Mixed - A$1 or $A1 - Fixes either row or column

Relative Reference Example:
=A1+B1
When copied down one row:
=A2+B2

Absolute Reference Example:
=A1*D1
D1 remains fixed while copying.

📌 Common Use Case: Tax rate, commission %, constants.

23. How do you use SUM, AVERAGE, MIN, MAX, COUNT, COUNTA?

These are the most commonly used Excel functions.

SUM
Adds numbers.
=SUM(A1:A10)

AVERAGE
Calculates mean.
=AVERAGE(A1:A10)

MIN
Returns smallest value.
=MIN(A1:A10)

MAX
Returns largest value.
=MAX(A1:A10)

COUNT
Counts numeric cells only.
=COUNT(A1:A10)

COUNTA
Counts non-empty cells.
=COUNTA(A1:A10)

📌 Example:
Useful in sales reports, attendance sheets, and KPI calculations.

24. How do you calculate percentage and percentage change?

Percentage Formula:
Percentage = Part/Total*100

Excel Formula:
=A1/B1
Format the result as %.

Percentage Change Formula:
Percentage Change = (New - Old)/(Old)* 100

Excel Formula:
=(B1-A1)/A1

📌 Example: Old Sales = 1000
New Sales = 1200

Result = 20% increase

25. How do you use ROUND, ROUNDUP, and ROUNDDOWN?

ROUND
Rounds to nearest value.
=ROUND(A1,2)
Example: 12.456 → 12.46

ROUNDUP
Always rounds upward.
=ROUNDUP(A1,1)
Example: 12.41 → 12.5

ROUNDDOWN
Always rounds downward.
=ROUNDDOWN(A1,1)
Example: 12.49 → 12.4

📌 Useful in financial calculations and reporting.

26. How do you calculate current date and time (TODAY, NOW)?

TODAY
Returns current date.
=TODAY()

NOW
Returns current date and time.
=NOW()

📌 Examples:
• Attendance tracking
• Invoice generation
• Automated timestamps

⚠️ These functions update automatically whenever the workbook recalculates.

27. How do you calculate the difference between two dates?

Basic Formula:
=B1-A1
Returns number of days.

📌 Example: 01-Jan-2026 to 10-Jan-2026 → 9 days

Using DATEDIF:
=DATEDIF(A1,B1,"D")
Units:
Unit - Meaning
"D" - Days
"M" - Months
"Y" - Years

28. How do you use IF for simple logical conditions?

The IF function checks conditions and returns different results.

Syntax:
=IF(condition, value_if_true, value_if_false)
Example:
=IF(A1>=50,"Pass","Fail")
📌 If marks are 50 or more → “Pass”
Otherwise → “Fail”

29. How do you handle errors using IFERROR or IFNA?

IFERROR
Returns custom output when formula gives an error.

Example:
=IFERROR(A1/B1,"Error")
If division by zero occurs, it displays "Error" instead of #DIV/0!.

IFNA
Handles only #N/A errors.
=IFNA(VLOOKUP(A1,D:E,2,FALSE),"Not Found")
📌 Commonly used in lookup formulas.

30. How do you nest multiple IF statements?

Nested IF allows multiple conditions.

Example:
=IF(A1>=90,"A",IF(A1>=75,"B",IF(A1>=50,"C","Fail")))
Logic:
Marks - Grade
90+ - A
75–89 - B
50–74 - C
Below 50 - Fail

📌 Useful for grading systems, incentive slabs, and performance categories.

Double Tap ❤️ For Part-4

✅ Essential Tools for Data Analytics 📊🛠️

🔣 1️⃣ Excel / Google Sheets
• Quick data entry & analysis
• Pivot tables, charts, functions
• Good for early-stage exploration

💻 2️⃣ SQL (Structured Query Language)
• Work with databases (MySQL, PostgreSQL, etc.)
• Query, filter, join, and aggregate data
• Must-know for data from large systems

🐍 3️⃣ Python (with Libraries)
• Pandas – Data manipulation
• NumPy – Numerical analysis
• Matplotlib / Seaborn – Data visualization
• OpenPyXL / xlrd – Work with Excel files

📊 4️⃣ Power BI / Tableau
• Create dashboards and visual reports
• Drag-and-drop interface for non-coders
• Ideal for business insights & presentations

📁 5️⃣ Google Data Studio
• Free dashboard tool
• Connects easily to Google Sheets, BigQuery
• Great for real-time reporting

🧪 6️⃣ Jupyter Notebook
• Interactive Python coding
• Combine code, text, and visuals in one place
• Perfect for storytelling with data

🛠️ 7️⃣ R Programming (Optional)
• Popular in statistical analysis
• Strong in academic and research settings

☁️ 8️⃣ Cloud & Big Data Tools
• Google BigQuery, Snowflake – Large-scale analysis
• Excel + SQL + Python still work as a base

💡 Tip:
Start with Excel + SQL + Python (Pandas) → Add BI tools for reporting.

💬 Tap ❤️ for more!

𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 𝗢𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ( 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀)😍

Learn the Latest 5 Analytics Tools in 2026

Learn Essential skills to stay competitive in the evolving job market

Eligibility :- Students ,Graduates & Working Professionals 

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4tFlovr

(Limited Slots ..HurryUp🏃‍♂️ ) 

𝐃𝐚𝐭𝐞 & 𝐓𝐢𝐦𝐞:- 20th May 2026, at 7 PM

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?

🚀 𝗙𝗥𝗘𝗘 𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿 𝗧𝗲𝗰𝗵 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗨𝗽𝗴𝗿𝗮𝗱𝗲 𝗬𝗼𝘂𝗿 𝗖𝗮𝗿𝗲𝗲𝗿 🔥

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

🚀 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

𝗔𝗜/𝗠𝗟 𝗿𝗼𝗹𝗲𝘀 𝗮𝗿𝗲 𝗳𝗮𝘀𝘁𝗲𝘀𝘁-𝗴𝗿𝗼𝘄𝗶𝗻𝗴 𝗰𝗮𝗿𝗲𝗲𝗿 𝗳𝗶𝗲𝗹𝗱 𝗶𝗻 𝟮𝟬𝟮𝟲😍

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

🚀 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ᵢ)

Double Tap ❤️ For Part-5