Rheznandya Alisya
Transforming messy Excel data into data-driven decisions.
New to Contra
Rheznandya is ready for their next project!
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...
Choosing the right chart in Excel depends entirely on the dataset. This project demonstrates effective data visualization for livestock and meat production insights:
Line Chart: Shows the upward growth trend of total meat production (2020-2022).
Column Chart: Compares the total...
To visualize the top 10 export values of Indonesian commodities in the manufacturing sector, using a bar chart is the right solution because it can display the export values of commodities in order from highest to lowest. Before creating the chart, you need to sort and filter the table you want to visualize.
