Microsoft Excel Functions and Data Analysis

Overview

This repository contains the implementation of commonly used and advanced Microsoft Excel functions for data analysis, validation, and reporting.
All formulas included in this project have been practically implemented and tested on structured datasets.

---

Features Implemented

Lookup and Reference Functions

• VLOOKUP (Exact and Approximate Match)
• MATCH
• INDEX
• Dynamic lookup using MATCH with VLOOKUP
• Absolute and Relative Cell Referencing ($ usage)
• Named Ranges and Tables

---

Conditional and Logical Functions

• IF
• Nested IF
• IFS
• AND / OR with IF

---

Aggregation and Statistical Functions

• SUMIF / SUMIFS
• COUNTIF / COUNTIFS
• AVERAGEIF / AVERAGEIFS
• MAXIFS

---

Dynamic Data Functions

• FILTER
• SORT
• Combined SORT and FILTER formulas

---

Data Cleaning and Text Functions

• PROPER
• UPPER
• LOWER
• TRIM
• SUBSTITUTE
• Remove Duplicates
• Flash Fill

---

Data Splitting and Extraction

• LEFT
• FIND
• Separator-based text splitting

---

Conditional Formatting

• Row-based formatting using formulas
• Category-based highlighting
• Value-based formatting rules

---

Data Validation

• Dropdown lists
• Numeric and text-length validation
• Custom error messages

---

Sorting and Filtering

• Multi-column sorting
• Formula-based filtering
• Dropdown-based dynamic filtering

---

Tools Used

• Microsoft Excel (Advanced Functions)
• Excel 365 / Excel 2021

---

Sample Dashboard

Figure: Sales performance dashboard created using Excel charts , Pivot tables and Macros.

---