Advanced Excel Data Entry, Cleansing & Dashboard Reporting

A complete data management and reporting project designed to organize, clean, and analyze complex datasets using Advanced Excel.

Key Tasks Executed:

• Cleaned and formatted large-scale raw data, removing duplicates and correcting formatting errors.

• Applied advanced lookup formulas such as VLOOKUP, XLOOKUP, INDEX/MATCH, and conditional logic.

• Built dynamic Pivot Tables and interactive Pivot Charts for key metrics visualization.

• Created structured, print-ready summary reports for administrative decision-making.