Practice Tasks:

✅ Automated sales report

✅ CSV cleaning workflow

✅ Refreshable dashboard

✅ Week 8: Real Projects + Interview Preparation

Build These Projects:

📊 Project 1: Sales Dashboard

Include:

• KPIs

• PivotTables

• Charts

• Slicers

💰 Project 2: Expense Tracker

Include:

• Budget vs Actual

• Monthly Trends

• Conditional Formatting

👨‍💼 Project 3: HR Analytics Dashboard

Include:

• Attendance

• Employee Performance

• Attrition Analysis

Interview Preparation:

✔ Practice Excel interview questions

✔ Learn keyboard shortcuts

✔ Solve business problems

✔ Explain dashboards confidently

🚀 Best Excel Features Every Analyst Should Master

Skill : Importance

PivotTables : ⭐⭐⭐⭐⭐

Lookup Functions : ⭐⭐⭐⭐⭐

Data Cleaning : ⭐⭐⭐⭐⭐

Dashboards : ⭐⭐⭐⭐⭐

Power Query : ⭐⭐⭐⭐⭐

Conditional Formatting : ⭐⭐⭐⭐

VBA Basics : ⭐⭐⭐

📚 Best Resources to Learn Excel

Official Website

Microsoft Excel

Practice Platforms

• Excel Practice Online

• W3Schools Excel Tutorial

• ExcelJet

YouTube Channels

• Leila Gharani

• Kevin Stratvert

• MyOnlineTrainingHub

📌 Consistency matters more than speed.

Practice daily for 1 to 2 hours and build projects alongside learning.

Double Tap ❤️ For Detailed Explanation