index-match

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

Analyzing Coffee Sales in MS Excel using XLOOKUP & INDEX MATCH

Data Analysis Poroject

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.

Coffee Sales Dashboard

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

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

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

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.

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

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