This repository contains a curated collection of practical Excel use cases, demonstrating real-world data analysis techniques using Excel functions, formulas, tables, charts, and tools.
It highlights how Excel can be used for exploration, transformation, visualization, and business insights without code.
This repo showcases the following Excel capabilities:
- π Pivot Tables & Charts
- π Filtering and Sorting
- π§ Advanced Formulas (e.g., IF, VLOOKUP/XLOOKUP, INDEX/MATCH)
- π Data Visualization (charts, trend analysis)
- π― Dashboards / Summary Reports
These examples help illustrate techniques commonly used in business analytics workflows.
Each folder contains Excel files with example use cases: