📊 Excel Data Analytics Assignments
This repository contains my hands-on Excel assignments completed as part of my Data Analytics learning journey at TOPS Technologies Pvt. Ltd.
These assignments focus on building strong fundamentals in Excel functions, data analysis, and automation.
📁 Assignments Covered
🔢 Basic Mathematical & Statistical Functions
- SUM (SUM 1, 2, 3)
- AVERAGE (AVERAGE 1, 3)
- MAX & MIN (MAX MIN 1, 2, 3)
- Basic calculations (Math 1)
📌 Learned how to perform numerical analysis and summarize datasets efficiently.
🔍 COUNT Functions
- COUNT (COUNT 1, 2, 3)
📌 Understood the difference between COUNT, COUNTA, and COUNTBLANK and their real-world usage.
⚙️ Logical Functions
- IF (IF 1, 2, 3, 4)
- Nested IF (Nested IF 1)
📌 Applied conditional logic to categorize and analyze data dynamically.
🔎 Lookup Functions
- VLOOKUP (Exact Match & Approximate Match)
- HLOOKUP
📌 Used lookup functions to retrieve and map data across different tables.
➕ Conditional Functions
- SUMIF (SUMIF 1, 2)
📌 Performed conditional calculations based on specific criteria.
🤖 Macros & VBA
- Macro Recording (Lec Macros 1.1)
- VBA Basics (VBA 1)
📌 Learned automation of repetitive tasks using Macros and basic VBA scripting.
🛠️ Tools Used
- Microsoft Excel
- Excel Formulas & Functions
📈 Key Skills Gained
- Data Cleaning & Formatting
- Excel Automation using Macros
- Data Lookup & Mapping Techniques
🚀 Future Enhancements
- Advanced Excel (Pivot Tables, Dashboards)
- Power BI Integration
- Real-world Data Analysis Projects
Shivam Thakur
Aspiring Data Analyst | Python Learner | Exploring Data Analytics & AI
- 💼 LinkedIn: https://www.linkedin.com/in/shivam-thakur-55b167406/
- 📧 Email: dataanalyst.shivamthakur@gmail.com
⭐ This repository represents my foundation in Excel for Data Analytics and my continuous learning journey.