advanced-excel
There are 105 repositories under advanced-excel topic.
ybg345/data-analysis-viz-excel
I have completed some MS Excel Course. This repository contains all the excel files (practice and exercises solutions by me) which were provided as Homework's or as hands on practice in course section.
YashMotwani/Sakila-DVD-Rental-database-Analysis
Analysis of the Sakila DVD Rental database using SQL
Salmankadiwal/Advanced-Excel-Formulas-and-Functions
This file contains advanced excel formulas and functions like Vlookup with match function, index and match function, offset & counta, logical operators, max if function, formula formatting, text functions, Date and time functions, data cleaning, etc. which I have worked on to take my excel skills at the high level.
zjxte/VBA-Functions
excel vba's
patelom5917/Data_Analysis_Projects
This repository shows my Data Analysis Projects
BasseyIsrael/Employee-Credential-Management-System
This project provides a system for keeping accurate track of the credentials attached to an employee in a man-power driven service providing organization. This system ensures the most suitable employees are always called up for job assignments.
chahat-7/Sales-Analysis-Dashboard-Excel
Conducted in-depth data analysis on E-commerce Sales Data to gain some meaningful insights on Products' Sales for each region and segment.
commnag/super_store_excel_dashboard
This project consists of an excel dashboard on the Super Store data. Along with the dashboard, it tries to answer a few business problems in a report created on a separate worksheet.
Jampana-Jagadeesh/Ecommerce-Sales-Dashboard-By-using-POWER-BI
Ecommerce Sales Dashboard By using POWER BI (DATA ANALYTICS)
NakulSachdeva/T20-Data-Analysis
A Power BI report to identify top 11 players for a T20 cricket team.
PiyushG0999/IMDB-Movie-Analysis
Advanced MS Excel
Shri3131/iNeuron_Full_Stack_Data_Analyst_2.0_Assignments
Ineuron_FSDA_2.0_Course_Assignments
xiaojie-qian/House-and-Urban-development
Housing value predictive model (Using US official datasets to build predictive model by using excel)
BalaTuty/ExcelProjects
You can find all the Excel Projects that I have worked on in here. Thanks for viewing
Bhushan148/Sales-Dashboard-Excel
This project showcases a comprehensive Sales Dashboard designed to provide insightful visualizations and data-driven insights into sales performance across different time frames and categories. 🌟 Inspired by a YouTube tutorial, the project utilizes a combination of PowerPoint and Excel to create a visually appealing and interactive dashboard. 🖥️✨
ChirayushSingh/Anomaly-Detection-Metrics
Created By :-Chirayush Singh
fardousfa/Data-Analysis-Excel-Power-Query-DAX-Power-Pivot
This project demonstrates my end-to-end BI skills using Power Query, Power Pivot (DAX), and Excel Dashboarding. I built a dynamic and interactive sales performance dashboard for a multi-store coffee chain using raw data extracted from an ERP system.
krichmond19/PortfolioProjects
Excel, SQL, Python, and ML projects
mayankyadav23/Air-BNB-Data-Analysis
Data analysis and insights from NYC Airbnb listings, focusing on key metrics such as host performance, neighborhood trends, pricing, and customer reviews. Comprehensive documentation of ETL processes and analytical methodologies is provided. Perfect for understanding Airbnb dynamics and decision-making in the NYC market.
mayankyadav23/Superstore-Retail-Performance-Analysis
An interactive Power BI & Excel dashboard uncovering key insights on sales, customer behavior, and product performance. 🔥
patriciavalentine/GYM-MEMBERSHIP-EXPLORATORY-DATA-ANALYSIS
This project analyzes a Gym Membership Dataset using Excel to uncover insights into member behavior and gym usage patterns. The analysis is visualized through charts and a dashboard.
SK-SCMLab/Complex-Steel-manufacturing-aggregate-production-planning-case-study-using-Excel-Simplex-LP-Solver
This repository represents a comprehensive operations research case study at a steel production plant facility implementing aggregate production planning using Excel solver to minimise scrap generation across three specialised divisions.
SK-SCMLab/Pugh-Analysis-SCAMPER-Method-in-Manufacturing-using-Excel-VBA
This repository contains realistic manufacturing use cases that apply Pugh analysis and the SCAMPER method for process innovation and improvement.
tanjotveer-98/Advanced_Excel_Project
A Microsoft excel project to create a dashboard to analyze and visualize coffee sales worldwide using information about orders, products and customers.
divyasakpal48/divyasakpal
This is my personal GitHub profile.
moosatae123/Data-Analysis-Excel-Power-Query-DAX-Power-Pivot-Coffee-Shop
Excel-based data analysis using Power Query, Power Pivot (DAX), and dashboards for a multi-store coffee chain 🐙, with ERP data to track sales and trends.
nidhip1/Data-Analysis-Portfolio
This repository demonstrates my data analysis expertise through real-world projects. Each analysis showcases my ability to transform raw data into actionable insights that drive strategic business decisions.
noumanjamadar/AtliQ_Hardware_Excel_Sales_and_Finance_Analysis
End-to-end Business Intelligence (BI) solution for AtliQ Hardware using Excel. Designed sales and finance reports with interactive filters for trend analysis, KPI tracking, and actionable insights to support data-driven decision-making.
pragyaagarwal-76/data-analytics-projects
Projects for Data analytics using MS Excel and MySQL
Sahillodhi29/Excelling-Excel
A collection of advanced data analysis practice tasks using Microsoft Excel — covering Power Query, Power Pivot, DAX, and many more for hands-on learning.
saiftamboli/Interactive-Sales-Dashboard-for-New-Product-Launch
Interactive Power BI dashboard analyzing sales performance, product trends, and promotional impact during an early-stage product launch across regions and segments.
sanajjadhav15/Excel-call-centre-dashboard
An interactive Advanced Excel dashboard that transforms raw call centre data into clear KPIs, trends, and insights using Pivot Tables, Charts, Slicers, and Data Modeling.
SatyaCoder29/CRM-Analytics-Power-BI
CRM Analytics Dashboard – An interactive dashboard using Tableau, SQL, and Salesforce CRM Analytics (CRMA) to analyze sales performance, customer segmentation, and churn prediction. Features automated ETL pipelines, predictive analytics, and real-time insights for data-driven decision-making. 🚀📊
TapanJadhav/Projects
Here's the results of hands-on projeccts I have worked on by implementing the different visualisation tools and programming languages.
Wilson-Maho/Excel-DashBoard
Begginer Dash Board using online Data Set In Excel