Employee Data Analysis Using Microsoft Excel

This project focuses on analyzing employee data using Microsoft Excel functions and formulas.

The dataset contains information about employees such as department, salary, bonus, and years of experience. Several analytical tasks were performed to extract insights from the data.

Key tasks completed in this project include:

Classifying employees based on salary using logical functions (High / Low).

Calculating the total salary for employees in the Sales department.

Summing bonuses for employees in Sales with experience greater than or equal to 3 years.

Counting employees with salaries greater than 5000.

Counting employees in the HR department with bonuses less than 500.

Excel functions used:

IF

SUMIF

SUMIFS

COUNTIF

COUNTIFS

This project demonstrates the ability to analyze datasets and extract meaningful information using Excel formulas.