Rheznandya Alisya
Transforming messy Excel data into data-driven decisions.
New to Contra
Rheznandya is ready for their next project!
Turning complex spreadsheet noise into clear business insights! 📊
This project shows how raw sales order records can be converted into a user-friendly, interactive dashboard. Designed to help business owners and managers track revenue trends, monitor segment performance, and spot top-selling products in just a few clicks.🙌
I'm officially open for Excel data entry and formatting projects! If you need help cleaning up your spreadsheets, check out my service below🙌
Glad to discuss and contribute on your projects together!😍
Searching data manually in a matrix table with multiple criteria is inefficient. A two-way INDEX & MATCH function is the perfect solution for dynamic retrieval:
Row Match: Automatically locates the specific food item (e.g., "Mie Goreng") vertically.
Column Match: Identifies the...
Using logical formulas is essential for automated data categorization and reporting. This project demonstrates how to apply IF, IFS, COUNTIF, and SUM functions in Excel to process sales data effectively:
-IF Function (Binary Logic): Automatically flags whether a transaction is...
Travel Package Analytics Dashboard 📊✈️
An interactive Excel dashboard designed for travel agencies to track sales performance, booking conversions, and key business metrics in one place.
Key Highlights:
- KPI Tracking: Displays total Net Revenue (Rp 776.9M - excluding...
