"Wipro Style Employee Timesheet Excel Template – Attendance & Work Hours Tracker"

                                                                                         

✅ Wipro में Excel पर जो Common Tasks होते हैं:

🔹 Attendance Management

🔹 Employee Database Handling

🔹 Project Timesheet Analysis

🔹 Client Report Generation

🔹 Data Cleaning & Validation

🔹 MIS Reporting

🔹 Dashboard Creation

---

🎯 Practical Example: Employee Timesheet Analysis (Wipro Style)

मान लो कि आपके पास नीचे जैसा डेटा है:

Emp ID	Name	Department	Date	Project Name	Hours Worked
101	Ramesh Kumar	IT	01-Jun-25	Project A	8
102	Sita Sharma	HR	01-Jun-25	Project B	7.5
103	Amit Singh	IT	01-Jun-25	Project A	9
101	Ramesh Kumar	IT	02-Jun-25	Project A	8
102	Sita Sharma	HR	02-Jun-25	Project B	7
103	Amit Singh	IT	02-Jun-25	Project A	8.5
...	...	...	...	...	...

---

🔧 Step 1: Pivot Table Se Total Hours by Employee

1. Select the full data

2. Go to Insert → Pivot Table → New Worksheet

3. Drag:

   • Name → Rows

   • Hours Worked → Values (Sum)

4. Result:

Name	Total Hours
Amit Singh	17.5
Ramesh Kumar	16
Sita Sharma	14.5

---

🔧 Step 2: Total Hours by Project

1. Project Name → Rows

2. Hours Worked → Values (Sum)

Project Name	Total Hours
Project A	33.5
Project B	14.5

---

🔧 Step 3: Create a Monthly Report

1. Add Date to Columns

2. Rows → Name

3. Values → Hours Worked

Name	01-Jun	02-Jun	...	Grand Total
Amit Singh	9	8.5	...	17.5
Ramesh Kumar	8	8	...	16
Sita Sharma	7.5	7	...	14.5

---

🔧 Step 4: Conditional Formatting (Low Performers Identify)

• Select “Total Hours” column

• Home → Conditional Formatting → Highlight Cells < 15 → Red fill

• This helps Wipro HR/Manager identify employees working less than expected hours.

---

🔧 Step 5: Dashboard (Basic)

Use:

• Pie Chart: Hours per Project

• Bar Chart: Hours per Employee

• Slicer: For filtering by date or department

Go to:

• Insert → Charts → Recommended Charts

• Insert → Slicer (for interactivity)

---

🔧 Step 6: Use Formulas for Automation

Total Hours:

excel
=SUMIF(A:A, "101", F:F)

Average Hours per Day:

excel
=AVERAGEIFS(F:F, B:B, "Ramesh Kumar")

IF Statement:

excel
=IF(F2<8, "Below Expected", "OK")

---

✅ Tools Used in Wipro Excel Work:

Tool/Feature	Use
Pivot Table	Data summarization
VLOOKUP / XLOOKUP	Data lookup across sheets/tables
Conditional Formatting	Highlighting based on condition
Charts (Bar, Line, Pie)	Visual data analysis
Data Validation	Dropdowns, restrict entries
Filters & Sort	Quickly find and organize data
Macros (Advanced)	Automate repetitive tasks (for experienced users)

---

📁 Want a Sample File?

Main aapke liye is poore data + pivot + chart ke sath Excel file bana ke de sakta hoon. Aap chahein to:

1. Main Excel file bana kar upload karun

2. Ya aap apna sample data bhejein, to us par main real report bana kar sikhla doon.