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!😍
https://contra.com/s/ZFkN6Ome-professional-excel-data-entry-and-formatting
2
73
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 correct portion size (e.g., "Besar") horizontally.
Dynamic Result: The INDEX function intersects both criteria to instantly retrieve the exact price.
1
85
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 "Untung" (Profit) or "Rugi" (Loss) based on a single condition.
-IFS Function (Multi-tier Logic): Handles multiple conditions to classify sales performance into tiered categories ("Low", "Medium", "High") based on revenue thresholds.
-COUNTIF Function (Data Aggregation): Calculates the exact number of transactions that fall into each specific performance category.
-SUM Function (Totaling Data): Computes the grand total of all transactions to ensure complete data reconciliation in the summary table.
0
68
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 production volume across different meat categories.
Donut Chart: Illustrates the percentage share and regional distribution of chicken production.
Combo Chart: Displays two metrics at once—feed volume (columns) vs. total expenditure (line).
0
70
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.
0
104