📊 Excel Employee Data

This repository contains an Excel practice workbook designed for entry-level Data Analyst interview preparation.
The file includes datasets and guided exercises to practice Excel functions commonly tested in interviews.

---

📂 File Included

• Data_Analyst_Practice.xlsx → Excel workbook with 3 sheets:
  • Employees → Employee details (ID, Name, Department, Salary, Joining Date)
  • SalesData → Product sales by region with sales amount & date
  • LookupTable → Horizontal table for practicing HLOOKUP and LOOKUP

---

📝 Topics Covered

The questions in this project help you practice:

• Text Functions → LEFT, RIGHT, MID, LEN, UPPER, LOWER, PROPER
• Logical Functions → IF, AND, OR, IFS
• Date & Time Functions → YEAR, MONTH, TODAY, DATEDIF
• Conditional Counting & Summing → COUNTIF, COUNTIFS, SUMIF, SUMIFS
• Lookup Functions → VLOOKUP, HLOOKUP, LOOKUP, XLOOKUP, INDEX + MATCH

---

🎯 Example Questions

1. Extract first and last names from the Employee Name column.
2. Check if an employee is a “High Performer” using IF + AND.
3. Calculate how many days an employee has worked till today.
4. Use COUNTIFS to count employees in Sales with a salary > 50,000.
5. Find an employee’s salary using VLOOKUP and INDEX+MATCH.

---

🚀 How to Use

1. Download the Excel file from this repository.
2. Open in Microsoft Excel or Google Sheets.
3. Attempt the questions in the README or create your own.
4. Practice regularly to strengthen your Excel skills.

---

🤝 Contribution

If you’d like to add more questions or datasets, feel free to fork the repo and submit a pull request.

---

📌 Author

Created by Mohd Fuzail for practicing Excel skills as part of Data Analyst interview preparation.