This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as:
Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine future shipping strategies.
Data Analysis of a Superstore using MS Excel with Visualization
Statistical Analysis using Excel Spreadsheets
Developed as a way to keep track of my expenses, allowing me to make informed and smart money decisions based on my complete financial picture.
Created an dashboard on excel using e-commerce datasets
An analysis of Amazon Stock Data from December 2020 to November 2021 that provides information regarding increase/decrease in Amazon's value on any given day.
A tool to monitor expenses, helping to make data-driven and intelligent financial decisions based on a comprehensive overview of my finances.
'Vrinda Store' Data Analysis Project using Excel
This repository serves as a showcase of the skills I've acquired through Datacamp's "Data Analysis in Excel" course.
Advanced MS Excel
Interactive Excel HR Dashboard for analyzing employee, salary, bonus, department, gender, and country data.
My public library of reusable functions, scripts, code snippets, and utilities I have written in PowerQueryM language
Data-driven analysis of inventory management and supply chain efficiency (2015-2018). Identifies key trends in product classes, sales performance, and shipping. Provides actionable insights to optimize inventory levels, reduce costs, and improve customer satisfaction in a complex supply chain environment.
Utilizing Excel and statistics, including t-tests and z-tests, in the analysis of housing prices to determine the most influential factors driving home prices.
End-to-end data analysis and AI workspace using SQL, Excel, Python, Power BI, and GenAI
Disney+ StreamLens is a data analysis project focused on the Disney+ catalog. It features a full preprocessing pipeline—handling missing data, feature engineering, and cleaning—followed by EDA to uncover key insights into content distribution, release trends, audience ratings, and genres.
Personal data analysis project combining insider threat detection, cybersecurity, and exploratory data analytics. Built for portfolio showcase and practical skills demonstration.
To associate your repository with the data-analysis-excel topic, visit your repo's landing page and select "manage topics."