💼 Excel Job Salary Analysis

This repository contains a series of Excel workbooks where I practiced different sets of formulas to analyze job salary data. The goal of this project was to strengthen my Excel skills for real-world data analysis scenarios.

---

📂 Files Included

1. Job_Salary_Formula_Analysis.xlsx

   • General formulas applied to salary data (basic lookups, text handling, and conditional logic).

2. Job_Salary_Function_Analysis.xlsx

   • Additional formulas for data transformation and analysis beyond basics.

3. Job_Salary_Math_Function_Analysis.xlsx

   • Math-related formulas for salary calculations and numeric operations.

4. Job_Salary_Statistical_Function_Analysis.xlsx

   • Statistical functions applied to salary datasets (averages, percentiles, and more).

---

💡 Formulas Practiced

Across these files, I practiced:

• IFERROR, IF, SUMIFS
• LEFT, MID, RIGHT, CONCATENATE
• LARGE, INDEX, XLOOKUP, FILTER
• Math functions (ROUND, ABS, arithmetic operators)
• Statistical functions (AVERAGE, MEDIAN, MAX, MIN, PERCENTILE)

Each workbook focuses on different formula types and their use cases in analyzing salary data — from extracting text and cleaning data to performing calculations and deriving insights.

---

🎯 Why This Project?

This project was created to:

• Gain hands-on experience with essential Excel formulas
• Understand how different function categories (Math, Statistical, Lookup) are applied to real datasets
• Prepare for real-world data analyst tasks involving salary and job-related data

---

🛠 Tools Used

• Microsoft Excel (Office 365)
• Native formulas (no Power Query or macros used)

---

This repo is part of my journey in mastering Excel for data analysis.
Feel free to download and explore these workbooks!