index-match

Professional Excel training workbook covering 57 formulas — Text, Lookup, Statistical, Financial, Logic, and Math formulas with real-world examples

Coffee Sales Dashboard

Comprehensive Sales & Customer Feedback record analysis at Café Harmony using advanced Excel analytics.

Data Analysis Poroject

Advanced Excel sales workbook on 57,542 order lines: O(n) distinct counting, revenue-weighted margin with SUMPRODUCT, Pareto with INDEX/MATCH/LARGE, locale-proof Power Query loader

Analyzing Coffee Sales in MS Excel using XLOOKUP & INDEX MATCH

Interactive Excel dashboard analyzing 4 years of coffee sales data across the US, Ireland, and the UK. Built using PivotTables, pivot charts, VLOOKUP, INDEX-MATCH, slicers, and timelines to track sales trends, country performance, and top customers dynamically.

Excel-based analytics project solving business questions across orders, customers, and sales rep data using lookups, pivot tables, and advanced formulas.

QuickCart Regional Sales Performance Dashboard : An end to end Excel project where I took a messy, unusable order export and turned it into a clean, live dashboard that regional managers could actually use to make decisions.

Interactive Excel dashboard analyzing coffee sales trends, customer contribution, and country-wise performance using Pivot Tables, XLOOKUP, and slicers.

Advanced Excel data analysis project showcasing dashboards, pivot tables, lookup functions, and data cleaning techniques to generate business insights.