xlookup

Sales & Operations MIS Dashboard built in Excel/Google Sheets with pivot tables, VLOOKUP, XLOOKUP, IF, SUMIF formulas and charts & kpis

RevSync RCM is an Revenue Cycle Management engine built using excel that ingests hundreds of thousands of Medicare remittance records, reconciles them against simulated bank feeds, and routes every broken claim to the correct internal department — automatically.

Excel data into dashboards

Data analysis of learners assessment data using Excel

Interactive Coffee Shop Sales Performance Dashboard built using Microsoft Excel featuring Pivot Tables, Pivot Charts, KPI Cards, XLOOKUP, Slicers, and Business Insights.

Excel

🔷 Super Store Sales Analysis 🔷 Super Store Sales Analysis Dashboard built in MS Excel to analyze sales, profit, and customer behavior. Used Pivot Tables, Charts, and Slicers for interactive exploration. Explored trends across regions, categories, and customer segments.

Cleaned and analyzed 10,000 hospital admission records in Excel using lookup tables and pivot tables to explore patient demographics, conditions, billing and length of stay.

Automated, multi-criteria B2B financial scoring matrix integrating NBP API and advanced Excel logic.

This analytics Excel dashboard provides a comprehensive overview of Liverpool's forward players' performance across all competitions in the 2024/2025 season. Key metrics include total goals, assists, big chances created/missed, shooting accuracy, dribbling efficiency, and player availability due to injuries.

"Excel and Power Query practice projects: formulas, pivot tables, charts, and data transformation."

An open-source Python library that converts messy, internationally formatted corporate spreadsheets into clean, auditable pandas DataFrames.

Built an interactive Coffee Sales Dashboard in Excel leveraging Pivot Tables, Slicers, XLOOKUP, and INDEX-MATCH to analyze product-wise, regional, and time-based sales trends.

An interactive Retail Sales Performance Dashboard built using Microsoft Excel, featuring KPIs, Pivot Tables, Pivot Charts, XLOOKUP, and Slicers for business insights.

Excel: Events Schedule Management with VBA macros and Formulas

Vrinda Store Analysis data cleaning, processing, analysis and dashboard creation in Excel.

A comprehensive analysis of sales and customer feedback data at Cafe Harmony, leveraging a master sample of 608 entries. Using advanced analytics and Excel visualizations, I uncovered insights into sales trends, stock management, product satisfaction, and consumption patterns—empowering strategic decisions to elevate the overall customer experience

This project presents an interactive coffee sales dashboard built using Microsoft Excel. The dashboard provides insights into sales performance, customer behaviour, and product trends over time.

Interactive HR MIS Dashboard built in Microsoft Excel using Pivot Tables, XLOOKUP, Slicers, KPI Cards, Conditional Formatting, and HR Analytics to support workforce reporting and management decision-making.