Excel

Data analysis of learners assessment data using Excel

Dashboard of road accidents occured during the period of 2021-22 with different reasons behind. Using Ms excel for the data processing and creating pivot tables , using fucntions and may more features of excel to create the final dashboard to give quick overview of data

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: Events Schedule Management with VBA macros and Formulas

Excel data into dashboards

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

Analyzing Coffee Sales in MS Excel using XLOOKUP & INDEX MATCH

This repository contains all my Microsoft Excel Reports & Dashboards.

The Excel Formulas and Data Analysis Showcase is an educational repository designed to provide users with an in-depth understanding of Excel formulas and their practical application in data analysis.

Coffee Sales Insights - Excel Dashboard

Resources to learn Excel functions for finding values in a table based on a specific column. Ideal for tasks like finding employee details from a complex database using Employee ID.

In this research, coffee sales data is examined using Microsoft Excel and a dashboard, with a specific focus on crucial elements such as the average sales of various coffee types, cumulative sales by country over time, top customers, and the overall sales trajectory.

**Awesome Chocolates Data Analysis Project** is an insightful exploration of chocolate company employee data using Microsoft Excel. This project aims to uncover valuable trends and patterns within the dataset, shedding light on various aspects such as gender comparisons, salary distribution, and company growth.

Coffee Sales Dashboard

Excel-based project focused on data cleaning, XLOOKUP, Pivot Tables and Pivot Charts

A small showcase to my Excel XLOOKUP - VLOOKUP skills...

Designed an interactive sales performance dashboard using Excel. Incorporated pivot tables and charts for visual representation. | Data Analyst BootCamp and a few Projects

Dynamic coffee sales analysis using MS Excel, XLOOKUP, VLOOKUPS, Pivoting, pivot table visualizations and data analytical principles.