📊 Excel-DPP-Assignments:

🔹 Week 01 – Excel Fundamentals: DPP

• Built a strong foundation in Microsoft Excel interface and worksheet handling
• Practiced structured data entry, formatting, and basic data organization
• Applied arithmetic formulas for calculations and analysis
• Worked with relative, absolute, and mixed cell reference
• Improved spreadsheet accuracy and formula consistency
• Strengthened analytical thinking using simple business-style datasets

---

🔹 Week 02 – Excel Functions & Conditional Logic: DPP 01

• Hands-on usage of core Excel functions:
• SUM, AVERAGE, MIN, MAX, COUNT
• Implemented logical conditions using IF and Nested IF
• Used date & time functions like TODAY() and NOW()
• Automated calculations for real-world scenarios
• Improved efficiency by replacing manual calculations with formulas

---

🔹 Week 02 – Data Cleaning & Text Functions: DPP 02

• Worked extensively with text functions:
• LEFT, RIGHT, MID, LEN, FIND
• Extracted and cleaned meaningful information from raw text data
• Combined logical and text functions for data transformation
• Handled inconsistent and unstructured datasets
• Strengthened data preprocessing skills for reporting use cases

---

🔹 Week 03 – Date Analysis & Conditional Formatting: DPP

• Performed date-based calculations

• Used TODAY() for dynamic date comparison

• Implemented conditional formatting to highlight insights visually

• Created Excel-based alerts for past and future dates

• Worked with timestamps and data tracking logic

• Enhanced decision-making using visual cues and rules

  ---

🔹 Week 04 – Advanced Excel Analysis & Business Logic: DPP 01 – 03

• Worked extensively with Excel lookup and reference functions
• Implemented XLOOKUP, VLOOKUP, and HLOOKUP for data retrieval
• Connected multiple tables using key-based lookups
• Improved data accuracy by reducing manual matching
• Applied lookup logic to real-world business datasets

---

✅Key Skills Gained:

1. Microsoft Excel
2. Data Cleaning & Data Preparation
3. Excel Formulas & Functions
4. Logical Analysis & Automation
5. Date & Time Analysis
6. Conditional Formatting