advanced-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.

Analysis of the Sakila DVD Rental database using SQL

excel vba's

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.

This repository shows my Data Analysis Projects

Ecommerce Sales Dasard By using POWER BI (DATA ANALYTICS)

Ineuron_FSDA_2.0_Course_Assignments

Housing value predictive model (Using US official datasets to build predictive model by using excel)

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.

Conducted in-depth data analysis on E-commerce Sales Data to gain some meaningful insights on Products' Sales for each region and segment.

Advanced MS Excel

This project consists of an excel dasard on the Super Store data. Along with the dasard, it tries to answer a few business problems in a report created on a separate worksheet.

A Microsoft excel project to create a dasard to analyze and visualize coffee sales worldwide using information about orders, products and customers.

Excel, SQL, Python, and ML projects

An interactive Power BI & Excel dasard uncovering key insights on sales, customer behavior, and product performance. 🔥

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 dasard.

Data analysis and insights from NYC Airbnb listings, focusing on key metrics such as host performance, neigrhood 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.

You can find all the Excel Projects that I have worked on in here. Thanks for viewing

A Power BI report to identify top 11 players for a T20 cricket team.

Using VBA, analyzing one year of stock data