Excel and Power Query Practice

This repository showcases my learning and application of Excel and Power Query — two essential tools for data analysis and transformation.

📁 Folder: Excel/Basic Excel

Includes:

• Excel Basics.xlsx – My worked file with formulas, pivot tables, and charts
• Excel Basics- Fresh File.xlsx – The original raw Excel file

📸 Screenshots

📊 1. Product Sales Summary (Pivot Table + Combo Chart)

A pivot table showing total sales and units sold per product, visualized with a combination of bar and line chart:

---

🏢 2. Department Expense Breakdown (Pivot Table + Bar Chart)

Analyzes office expenses by department and category using a nested pivot table and vertical bar chart:

✅ Skills Demonstrated

• 🔍 XLOOKUP, INDEX, and structured referencing
• 📊 Pivot Tables for dynamic summarization
• 📈 Charts for visual data insights (bar, line)
• 🧮 Logical formulas: IF, SUM, AVERAGE
• 🧹 Data formatting and layout improvements

🔧 Tools Used

• Microsoft Excel (2016/365)
• Power Query (inside Excel) for data transformation

🚀 What’s Next

• Deepen Power Query skills (joins, transformations, appends)
• Explore DAX and Power Pivot for advanced modeling
• Build Excel dashboards combining Pivot + Power Query

💼 Objective

To build a strong data analysis portfolio using Excel and Power Query, demonstrating both technical and business-focused skills.