Day - 2 | Excel for Data Analytics | Data Cleaning, Formulas & Charts | TechMonks 🎓

Welcome to Day 2 of our Data Analytics Training Program by TechMonks 🎓

In this session, we covered Excel for Data Analytics, specially designed for beginners and non-tech students. This class focuses on hands-on learning, real-time examples, and practical usage of Excel in the Data Analyst role.

📘 Topics Covered in Day 2 Session

✔ Excel interface & basics
✔ Working with rows, columns & cells
✔ Important Excel formulas (SUM, AVERAGE, IF, COUNT, MAX, MIN)
✔ Sorting & Filtering data
✔ Basic data cleaning techniques
✔ Text functions (TRIM, UPPER, LOWER, CONCAT)
✔ Introduction to Lookup functions
✔ Creating charts for analysis
✔ Real-time sales dataset practice

🎯 Who Should Watch This Video?

Data Analytics beginners

Non-IT / non-coding students

Freshers looking to enter IT

Anyone who wants to learn Excel for analytics

🚀 What You’ll Learn

After watching this video, you’ll be able to:

Clean raw data in Excel

Analyze sales datasets

Create simple reports & charts

Prepare data for SQL, Python & Power BI

📂 Practice Dataset & Notes

📌 Practice dataset and notes will be shared in the TechMonks student group.

📅 About TechMonks Data Analytics Program

Our 4-Month Live Data Analyst Training + Internship Program covers:

Excel (Advanced)

SQL for Data Analytics

Python (Pandas & NumPy)

Power BI Dashboarding

Real-time Projects

Resume, Interview & Placement Support

📩 DM us on Instagram / WhatsApp for more details.

🔔 Don’t Forget

👍 Like the video
💬 Comment your doubts
📌 Subscribe to TechMonks for more analytics content
🔔 Turn on notifications

Видео Day - 2 | Excel for Data Analytics | Data Cleaning, Formulas & Charts | TechMonks 🎓 канала TECHMONKS 🎓